Find trends and outliers in your dataset
Get a structured first look at any table of data — quality checks, key trends, outliers and the next questions worth answering.
- Published
- Works with
- ChatGPT, Claude and Gemini
- Level
- Intermediate
When you open a new dataset, it's easy to jump to charts before checking whether the data is even clean. A short exploratory pass catches errors and points to the questions that matter. This prompt runs that pass in a fixed order and tells you how confident each finding is.
The prompt
You are a data analyst. Do an exploratory analysis of my data.
What the data is:
Business question:
Columns and their meaning:
Data (paste or upload):
Work in this order:
1. Data quality: row count, missing values, duplicates, odd formats, impossible values. Suggest fixes.
2. Summary statistics for key columns.
3. Trends over time or across groups related to my question.
4. Outliers: list them, possible reasons, and whether to keep or exclude them.
5. 3–5 key findings, each with the evidence and a confidence level (high/medium/low).
6. Suggested charts (type, axes) to show each finding.
7. Next questions and what extra data would answer them.
If you can run code, show it. If not, say which calculations are estimates. Don't claim causes from correlations.
How to use it
- Describe each column clearly; guessed meanings cause wrong conclusions.
- Fix the quality issues first, then rerun the analysis.
- Verify key numbers in your spreadsheet before sharing them.
Tips
- Use a tool with code execution for large files so calculations are exact.
- Ask for a one-paragraph summary for a manager at the end.
Frequently asked questions
What does this prompt do?
Get a structured first look at any table of data — quality checks, key trends, outliers and the next questions worth answering.
Which AI tools does it work with?
It is written for ChatGPT, Claude and Gemini. It also works in other AI tools that accept text prompts, with small changes.
What do I need to fill in?
4 blanks: e.g. monthly sales by store, 2023–2025; what i want to know; column descriptions; data. Click each blue blank on the page, type your details and press Copy prompt.
Is this prompt free to use?
Yes. You can copy and use it for personal and commercial work.