← All cheatsheets

AI prompts

AI data-analysis prompts — turn AI into a junior analyst

Prompts that make AI a careful junior analyst: sanity checks, summary stats, cohort segmentation, anomaly hunts and trend analysis.

Eight prompts that work when you paste a CSV, SQL result, or data table after the prompt.

1. Describe + sanity-check

Describe this dataset in 5 bullets: what each column is, the row count,
any obvious anomalies, what scale the numbers are in, and any
suspicious values worth flagging.

2. Top-N + summary stats

Show the top 10 rows by <column>. Then summary stats (count, mean,
median, min, max, p95) for that column. Then a one-line interpretation.

3. Cohort segmentation

Segment this data into 3-5 cohorts based on <column or behavior>.
Show each cohort's size + key descriptive stats + a one-line
characterization.

4. Anomaly hunt

Flag any row that's an outlier in any column (3+ stddev from mean,
or otherwise unusual). For each flagged row, explain why it's
suspicious.

5. Trend analysis (time series)

Identify the trend in <metric> over <time column>. Distinguish:
overall direction, seasonality, breakpoints. Give a one-paragraph
narrative an exec would understand.

6. Cohort-vs-cohort comparison

Compare cohort A (<criterion>) to cohort B (<criterion>) on these
metrics: <list>. Show a side-by-side table. End with the single
biggest difference and its likely explanation.

7. Hypothesis generation

What 3 hypotheses does this data suggest? For each, what additional
data would you need to confirm or reject it?

8. SQL drafting

I want to answer: <question in plain English>. Schema is: <paste
DDL>. Write the SQL. Explain the WHERE and GROUP BY choices.

Tip

Always verify the AI's specific numerical claims against the source data. AI is a research assistant, not an oracle.