Querri is 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:
(Link to blog with visuals is here.)
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.
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.
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.
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.
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.
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.
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.
For example, if you had a text-heavy column 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.
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."
