10 most Powerful Prompts in Querri - Working with Data made Easy

Do you want quick answers from your data?

Whether you're a seasoned data professional or a novice data wrangler, Querri can help you get answers quickly, saving you time and effort. Understanding your data is crucial if you want to improve the effectiveness of your marketing campaigns, identify productivity bottlenecks, optimize resource use, accurately forecast demand, or make faster and more accurate decisions than your competitors.

Querri was designed to be both powerful and easy to use. Using natural language to interact with your data makes it more accessible for everyone.

Check out these prompts to get fast & powerful results.

1. “Join all data sets”

If you are working with related data sets in various spreadsheets and want answers from them, you can upload them into your Querri project and ask, "Join all data sets.” Querri will then look at your data and join them appropriately.

Read this help article for numerous ways to join data sets.

1 Upload related data sets.

2 Querri looks at your data sets and joins them in a new tab.

2. “EDA”

Would you like to start with exploratory data analysis? Then, simply type in those three letters. Boom! Querri will analyze your data and give you a Summary of the Dataset, Recommendations for Further Analysis, and several data visualizations.

1 Type EDA and get multiple results.

2 Cash Flow Over Years

3 Support Types Distribution

4 Government Support Distribution.
Pro Tip: Click "Explain" to get more info about this step

5 Cash Flow by Mode

3. “Draw 5 different graphs that show ___”

Interested in a quick visualization of your data? Copy that prompt with the direction of what you want to see (like Draw 5 different graphs that show cash flow), and Querri will do just that.

1 Draw 5 different graphs that show Cash flow

2 Distribution of Cash Flow Categories

3 Box Plot of Cash Flow

4 Cash Flow Time Series

5 Cash Flow Scatter Plot

4. "Check for missing values, outliers, and inconsistencies."

To ensure a sound data analysis, you will want to make sure you don't have missing values or inconsistencies, and you will want to know your outliers. To get a quick overview of this, ask Querri to Check for missing values, outliers, and inconsistencies, and it will check your data, report its findings, and provide a visualization and a report on your outliers.

1 Check Missing Values

2 Querri creates a visualization of the Outliers

3 Querri checks for inconsistencies

5. “What factors most affect ___?”

Do you want to find out what most affects one of your columns in your data, such as customer churn? Just ask.

1 What factors most affect customer churn: Visualization & Analysis

2 What factors most affect customer churn? (Pro Tip: Click "Explain" to understand the steps taken)

6. “Fix Dates”

Date columns can come in all kinds of weird formats. If you want to make them uniform in one go, ask Querri to fix the dates. If you want a specific format, give those instructions to Querri, and it can do it for you.

1 Fix Order Date

2 Querri goes ahead and fixes your date column.

7. “Remove Duplicates ”

Are you curious if your data set contains duplicates? Ask Querri to remove them; it will analyze your data for you and remove any duplicates.

8. “Create a new column called___ and ___.”

Querri has an amazing feature called "Row Looper." It can go through each row and read, analyze, change, and summarize the contents of every column.

If you had a text-heavy column, for example, and wanted a new column with a short summary, you could ask: Please create a new column with a short summary of column "post" and Querri will do just that.

Or, if you wanted a column to be grouped differently, you could ask: Create a column grouping Cost of Product by small, medium and large, for example and Querri will analyze your data and create a new column with different groupings.

1 Create a new column with a short summary of column "post"

2 Querri creates a new column with a summary of column "post"

3 Querri Analyzed the data and created a new column grouping the product cost by small, medium, and large. 
NOTE: Querri can handle thousands of rows ;-).

9. “Convert___to integer”

Would you like to get rid of decimals? Converting them to an integer is simple. If you had a weight column with decimals, for example, you could ask Querri to Convert the Weight Column to an integer, and Querri would do that for you.

10. “Aggregate on {column name}, include a column for {column} that shows {metric}, another column for _____ that shows _____, {etc…}

Do you want to get answers from your data aggregated? 
Querri automatically converts and standardizes the date/time formats in all columns and handles data that cannot be formatted or converted. It groups, aggregates, and computes totals without requiring explicit instructions. 

"Aggregate each order to include order number, all the dates, status, comments and customerNumber, then include total items ordered, a list of product lines, and the total profit for each."

Do you still have questions about how to do more with your data? You can join our weekly onboarding webinars or schedule a call with us. We would love to help you. Our mission is to empower everyone to get the most out of their data, regardless of job title or education.