10 Most Powerful Prompts In Querri
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 Datasets
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 based on primary id
Read this help article for numerous ways to join data sets.
2. Perform EDA (Exploratory Data Analysis)
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.
EDA
3. Draw 5 different graphs with one prompt
Interested in a quick visualization of your data? Copy that prompt with the direction of what you want to see
Draw 5 different graphs that show cash flow
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. Identify factors impacting your business
Do you want to find out what most affects one of your columns in your data, such as customer churn? Just ask.
What factors most affect customer churn
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.
fix dates in orderdate so that they are dd-mm-yy format
7. Remove Duplicates
Are you curious if your data set contains duplicates? Ask Querri to remove them with a simple prompt
remove all duplicates
8. Extract Data From The Dataset Into A New Column
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:
Create a new column with a short summary of column "post"
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,
Querri will analyze your data and create a new column with different groupings.
9. Convert between data formats
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
10. Perform Aggregations
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.