Data analysis prompt pack

ChatGPT Prompts for Data Analysis

Use these ChatGPT prompts to analyze datasets, plan dashboards, summarize metrics, build hypotheses, write reports, and turn data into decisions.

Browse Prompts All Prompts Resources

Use This Page For

Use these prompts to make data work more decision-focused. ChatGPT can structure the thinking, but calculations and conclusions should be checked with reliable tools and source data.

Prompt Selection Framework

Start with the decision

Analysis is stronger when the business question and action are clear.

Describe the data

Include columns, time range, definitions, missing data, and known limitations.

Separate insight from speculation

Ask ChatGPT to label evidence, assumptions, and follow-up checks.

Copy-ready pack

6 Practical Prompts

Each prompt includes the best use case, variables to replace, customization notes, and the output you should expect.

Prompt 1

Analysis Plan

Best for: Planning before touching the data.

Create a data analysis plan.
Business question: [QUESTION]
Dataset: [DATASET]
Columns and definitions: [COLUMNS]
Decision supported: [DECISION]
Return: analysis steps, metrics, segments, charts, data quality checks, and expected outputs.

Variables

  • [QUESTION]
  • [DATASET]
  • [COLUMNS]
  • [DECISION]

Customize

Start with the decision so the analysis stays focused.

Expected Output

A clear analysis workflow.

Prompt 2

Data Quality Checklist

Best for: Checking data before analysis.

Create a data quality checklist.
Dataset: [DATASET]
Columns: [COLUMNS]
Known issues: [ISSUES]
Return: missing value checks, duplicate checks, outlier checks, type checks, consistency checks, and cleanup recommendations.

Variables

  • [DATASET]
  • [COLUMNS]
  • [ISSUES]

Customize

Add known data collection issues to improve the checklist.

Expected Output

A practical data QA checklist.

Prompt 3

Metric Summary

Best for: Explaining performance changes.

Summarize these metrics.
Business context: [CONTEXT]
Metrics: [METRICS]
Date range: [DATE RANGE]
Goal or benchmark: [GOAL]
Return: key changes, possible drivers, anomalies, confidence level, and recommended next checks.

Variables

  • [CONTEXT]
  • [METRICS]
  • [DATE RANGE]
  • [GOAL]

Customize

Include benchmarks so changes are interpreted correctly.

Expected Output

A metric readout with next checks.

Prompt 4

Dashboard Spec

Best for: Planning useful dashboards.

Design a dashboard.
Audience: [AUDIENCE]
Decisions supported: [DECISIONS]
Available data: [DATA]
Update frequency: [FREQUENCY]
Return: dashboard sections, KPIs, chart types, filters, alerts, and questions each section answers.

Variables

  • [AUDIENCE]
  • [DECISIONS]
  • [DATA]
  • [FREQUENCY]

Customize

Design dashboards around decisions, not decoration.

Expected Output

A dashboard blueprint.

Prompt 5

Insight Report

Best for: Turning analysis into a stakeholder update.

Write a data insight report.
Analysis summary: [SUMMARY]
Audience: [AUDIENCE]
Decision needed: [DECISION]
Limitations: [LIMITATIONS]
Return: executive summary, key findings, evidence, implications, recommendations, and caveats.

Variables

  • [SUMMARY]
  • [AUDIENCE]
  • [DECISION]
  • [LIMITATIONS]

Customize

Keep limitations visible so stakeholders do not overread the data.

Expected Output

A decision-oriented report.

Prompt 6

Hypothesis Generator

Best for: Finding explanations to test.

Generate hypotheses for this metric change.
Metric change: [CHANGE]
Context: [CONTEXT]
Segments available: [SEGMENTS]
Recent changes: [RECENT CHANGES]
Return: possible hypotheses, evidence needed, analysis method, priority, and how to falsify each hypothesis.

Variables

  • [CHANGE]
  • [CONTEXT]
  • [SEGMENTS]
  • [RECENT CHANGES]

Customize

Ask how to falsify ideas so the analysis does not chase convenient explanations.

Expected Output

A prioritized hypothesis list.

Related Prompt Paths

Data analysis report generator

Use an individual prompt for data report writing.

Dashboard KPI designer

Plan dashboards and KPI views.

Data prompts

Browse data analysis prompt templates.

FAQ

Can ChatGPT analyze data?

ChatGPT can help interpret pasted summaries, write analysis plans, explain formulas, design dashboards, and draft reports. For actual computation, use verified tools and check results.

What should I include in a data analysis prompt?

Include the business question, dataset description, columns, metric definitions, date range, sample rows or summary statistics, and the decision you need to make.