In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
Exploratory Analysis Plan for a New Dataset
Prompt
Where the data came from and what each row represents: {{DATA_ORIGIN_AND_ROW_MEANING}}
Column list with types and a sentence on each: {{COLUMN_LIST}}
The decision this analysis will inform: {{DECISION_CONTEXT}}
Time available: {{TIME_AVAILABLE}}
Produce a plan, not results:
1. Questions to ask the data owner first (how it was collected, what is missing, what changed over time).
2. A data profile checklist: row count, unique keys, ranges, distributions, missingness, duplicates, and impossible values, with the formula, pivot or code to check each.
3. Five to eight analysis questions ranked by how much they bear on the decision, each with the columns needed, the simplest summary or chart that answers it, and what result would change the decision.
4. Pitfalls specific to my description (survivorship, selection, seasonality, mixed units).
5. A stopping rule: what I should have by the end of my time budget.
Do not invent findings or typical values for my data. If something in my description makes a question unanswerable, say so.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Exploratory Analysis Plan for a New Dataset” is a free prompt for ChatGPT in the Reasoning & Problem-Solving category, 175 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{DATA_ORIGIN_AND_ROW_MEANING}}, {{COLUMN_LIST}}, {{DECISION_CONTEXT}}, {{TIME_AVAILABLE}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 3 times.
Browse all Reasoning & Problem-Solving prompts, the AI prompt database or use the AI prompt finder to search every prompt.