Skip to content
New this week26 prompts for Sora, Veo and Runway video workflows.
Explore video prompts→
AIPrompt123Prompt library

Search AIPrompt123

Search prompts, categories, platforms and repositories

26 prompts · reviewed by editors

Data Analysis prompts

Turn raw tables, surveys and logs into clean summaries, charts, SQL and decision-ready findings with explicit assumptions.

Survey analysisSQL queriesExecutive summariesCohort analysis

Language models do not replace a statistics package, but they are excellent translators. They can turn a business question into a SQL query, explain a regression output in plain English, suggest the right chart for a comparison, or spot that a survey question is double-barrelled. The risk is fabricated precision: a confident-looking number with no source. Every prompt in this category asks the model to state assumptions, show its working and flag what it cannot verify from the data provided.

The best workflow is boring and repeatable. Paste a small, representative sample or a schema rather than the whole dataset. Describe the grain of the table, the definition of each metric and the time window. Ask for a query or a Python snippet you can run yourself, then check the result against a known total. When you ask for an interpretation, require confidence levels and alternative explanations. This turns the model into a careful analyst rather than an answer machine.

Prompts here cover exploratory analysis, SQL generation, data cleaning, survey coding, cohort and retention analysis, forecasting sanity checks, chart selection and executive summaries. They are written for analysts, product managers and founders who can read a query but would rather not write every one from scratch. Where a prompt touches financial or medical data, treat the output as informational and consult a qualified professional.

All 26 data analysis prompts

Filter in library →
Intermediate

Turn a business question into SQL

This copy-ready data analysis prompt helps you turn a business question into SQL with fewer blank-page decisions. Paste it into ChatGPT and Claude, fill the variables, and you get a structured first draft you can edit. It is written for repeatable results and tells you what to check before publishing.

ChatGPTClaudeDeepSeek
4.7(26)1.7k copies
Advanced

Analyse a survey without overclaiming

A data analysis prompt for analyse a survey without overclaiming. It gives ChatGPT and Claude a clear role, explicit constraints and a defined output, so the first answer is closer to usable. Fill in the variables, run it once, then use the verification notes on this page to review the result.

ChatGPTClaudeDeepSeek
4.7(56)290 copies
Beginner

Choose the right chart for the question

Choose the right chart for the question with a prompt built for ChatGPT and Claude. It supplies context, constraints and an output contract, then asks the model to surface assumptions and gaps. Copy it, fill the variables and treat the result as a structured draft, not a final answer.

ChatGPTClaude
4.7(62)216 copies
Intermediate

Write a data cleaning plan

This copy-ready data analysis prompt helps you write a data cleaning plan with fewer blank-page decisions. Paste it into ChatGPT and Claude, fill the variables, and you get a structured first draft you can edit. It is written for repeatable results and tells you what to check before publishing.

ChatGPTClaude
4.9(76)210 copies
Advanced

Explain a regression output to a stakeholder

A data analysis prompt for explain a regression output to a stakeholder. It gives Claude and ChatGPT a clear role, explicit constraints and a defined output, so the first answer is closer to usable. Fill in the variables, run it once, then use the verification notes on this page to review the result.

ClaudeChatGPT
4.9(58)912 copies
Advanced

Design a cohort retention analysis

Design a cohort retention analysis with a prompt built for Claude and ChatGPT. It supplies context, constraints and an output contract, then asks the model to surface assumptions and gaps. Copy it, fill the variables and treat the result as a structured draft, not a final answer.

ClaudeChatGPTDeepSeek
4.8(24)428 copies
Beginner

Summarise a dataset for an executive

This copy-ready data analysis prompt helps you summarise a dataset for an executive with fewer blank-page decisions. Paste it into ChatGPT and Claude, fill the variables, and you get a structured first draft you can edit. It is written for repeatable results and tells you what to check before publishing.

ChatGPTClaude
4.8(51)965 copies
Beginner

Write Python to explore a CSV

A data analysis prompt for write Python to explore a CSV. It gives ChatGPT and DeepSeek a clear role, explicit constraints and a defined output, so the first answer is closer to usable. Fill in the variables, run it once, then use the verification notes on this page to review the result.

ChatGPTDeepSeekCursor
4.9(46)972 copies
Intermediate

Check a metric definition for ambiguity

Check a metric definition for ambiguity with a prompt built for Claude and ChatGPT. It supplies context, constraints and an output contract, then asks the model to surface assumptions and gaps. Copy it, fill the variables and treat the result as a structured draft, not a final answer.

ClaudeChatGPT
4.8(78)1.1k copies
Advanced

Design an A/B test

This copy-ready data analysis prompt helps you design an A/B test with fewer blank-page decisions. Paste it into Claude and ChatGPT, fill the variables, and you get a structured first draft you can edit. It is written for repeatable results and tells you what to check before publishing.

ClaudeChatGPT
4.8(57)607 copies
Advanced

Interpret an A/B test result

A data analysis prompt for interpret an A/B test result. It gives Claude and ChatGPT a clear role, explicit constraints and a defined output, so the first answer is closer to usable. Fill in the variables, run it once, then use the verification notes on this page to review the result.

ClaudeChatGPT
4.9(55)1.4k copies
Intermediate

Build a KPI tree

Build a KPI tree with a prompt built for ChatGPT and Claude. It supplies context, constraints and an output contract, then asks the model to surface assumptions and gaps. Copy it, fill the variables and treat the result as a structured draft, not a final answer.

ChatGPTClaude
4.9(85)671 copies
Advanced

Detect anomalies in a time series

This copy-ready data analysis prompt helps you detect anomalies in a time series with fewer blank-page decisions. Paste it into DeepSeek and ChatGPT, fill the variables, and you get a structured first draft you can edit. It is written for repeatable results and tells you what to check before publishing.

DeepSeekChatGPTClaude
4.9(58)688 copies
Beginner

Write a data dictionary

A data analysis prompt for write a data dictionary. It gives ChatGPT and Claude a clear role, explicit constraints and a defined output, so the first answer is closer to usable. Fill in the variables, run it once, then use the verification notes on this page to review the result.

ChatGPTClaude
4.7(62)992 copies
Intermediate

Compare two periods fairly

Compare two periods fairly with a prompt built for Claude and ChatGPT. It supplies context, constraints and an output contract, then asks the model to surface assumptions and gaps. Copy it, fill the variables and treat the result as a structured draft, not a final answer.

ClaudeChatGPT
4.9(70)584 copies
Advanced

Build a forecasting sanity check

This copy-ready data analysis prompt helps you build a forecasting sanity check with fewer blank-page decisions. Paste it into Claude and ChatGPT, fill the variables, and you get a structured first draft you can edit. It is written for repeatable results and tells you what to check before publishing.

ClaudeChatGPT
4.9(16)380 copies
Intermediate

Turn a dashboard request into a spec

A data analysis prompt for turn a dashboard request into a spec. It gives ChatGPT and Claude a clear role, explicit constraints and a defined output, so the first answer is closer to usable. Fill in the variables, run it once, then use the verification notes on this page to review the result.

ChatGPTClaude
4.7(65)627 copies
Beginner

Explain statistical power simply

Explain statistical power simply with a prompt built for ChatGPT and Claude. It supplies context, constraints and an output contract, then asks the model to surface assumptions and gaps. Copy it, fill the variables and treat the result as a structured draft, not a final answer.

ChatGPTClaude
4.8(33)483 copies
Beginner

Clean and normalise messy categories

This copy-ready data analysis prompt helps you clean and normalise messy categories with fewer blank-page decisions. Paste it into ChatGPT and Claude, fill the variables, and you get a structured first draft you can edit. It is written for repeatable results and tells you what to check before publishing.

ChatGPTClaude
4.7(53)179 copies
Intermediate

Write a reproducibility checklist

A data analysis prompt for write a reproducibility checklist. It gives Claude and ChatGPT a clear role, explicit constraints and a defined output, so the first answer is closer to usable. Fill in the variables, run it once, then use the verification notes on this page to review the result.

ClaudeChatGPT
4.9(76)226 copies
Advanced

Investigate a metric drop

Investigate a metric drop with a prompt built for Claude and ChatGPT. It supplies context, constraints and an output contract, then asks the model to surface assumptions and gaps. Copy it, fill the variables and treat the result as a structured draft, not a final answer.

ClaudeChatGPTPerplexity
4.8(63)666 copies
Intermediate

Write a SQL window function explanation

This copy-ready data analysis prompt helps you write a SQL window function explanation with fewer blank-page decisions. Paste it into DeepSeek and ChatGPT, fill the variables, and you get a structured first draft you can edit. It is written for repeatable results and tells you what to check before publishing.

DeepSeekChatGPT
4.9(55)261 copies
Advanced

Design a data quality monitoring plan

A data analysis prompt for design a data quality monitoring plan. It gives Claude and ChatGPT a clear role, explicit constraints and a defined output, so the first answer is closer to usable. Fill in the variables, run it once, then use the verification notes on this page to review the result.

ClaudeChatGPT
4.8(81)867 copies
Advanced

Create a research analysis plan

Create a research analysis plan with a prompt built for Claude and ChatGPT. It supplies context, constraints and an output contract, then asks the model to surface assumptions and gaps. Copy it, fill the variables and treat the result as a structured draft, not a final answer.

ClaudeChatGPT
4.8(15)685 copies
Intermediate

Explain correlation versus causation with this case

This copy-ready data analysis prompt helps you explain correlation versus causation with this case with fewer blank-page decisions. Paste it into Claude and ChatGPT, fill the variables, and you get a structured first draft you can edit. It is written for repeatable results and tells you what to check before publishing.

ClaudeChatGPT
4.8(72)930 copies
Advanced

Convert a spreadsheet into a normalised schema

A data analysis prompt for convert a spreadsheet into a normalised schema. It gives ChatGPT and Claude a clear role, explicit constraints and a defined output, so the first answer is closer to usable. Fill in the variables, run it once, then use the verification notes on this page to review the result.

ChatGPTClaudeDeepSeek
4.8(60)532 copies
Verified Knowledge · FAQ

Data Analysis prompt FAQ

What this collection covers, which models it supports and how to get a usable draft on the first try.