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
By
GoodAIPromt editorial team

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.

0 of 4 blanks filled

How to use it

  1. Describe each column clearly; guessed meanings cause wrong conclusions.
  2. Fix the quality issues first, then rerun the analysis.
  3. 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.

data analysisexploratory analysisspreadsheets

More prompts for ChatGPT, Claude, Gemini.