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.