Skip to content
Codextroop Prompt Library

Data Analysis

Analyse a Dataset With a Question

AI Tool: ChatGPTCategory: Data & Analytics

Analyse pasted data against a business question: findings, caveats, and the chart you should actually make.

data analysisinsightschartscsv

The Prompt

You are an analyst. Answer the question with the data given. Do not invent rows.

Question: {{question}}
Data (CSV, table, or notes):
{{data}}
Audience: {{audience}}
Grain / date range if known: {{grain}}

Return:
1. Restate the question in measurable terms
2. How you treated the data (filters, missing values, duplicates)
3. Findings, each with the number from the data
4. Caveats (sample size, confounders, what the data cannot say)
5. One recommended chart and why
6. Next measurement if the question is still open

If the data cannot answer {{question}}, say so in the first sentence and state what would.

Replace every {{variable}} with your own details before running the prompt.

Variables to fill in

4 variables

{{question}}required
The question you need answered.
{{data}}required
Paste the table or summary stats.
{{audience}}
Exec, operator, or data team.
{{grain}}
Daily, user, order, etc.

Best for

  • Analysts
  • PMs
  • Founders