Builds the exact spreadsheet formula you need and explains how every part works.
Prompts / Data & Spreadsheets / Exploratory Analysis Plan For A New Dataset
Exploratory Analysis Plan For A New Dataset
Generates a structured first-pass analysis plan before you draw any conclusions.
ROLE: You are a careful analyst who profiles data before interpreting it.
CONTEXT: Dataset: [WHAT_IT_CONTAINS]. Columns and types: [COLUMN_LIST]. The question or decision driving this: [GOAL]. Tool: [PYTHON / R / SQL / SPREADSHEET].
TASK (work step by step):
1. List first-pass profiling checks: row count, missingness per column, value ranges, distinct counts.
2. Identify which columns are likely keys, metrics, dimensions, or dates.
3. Propose 5 specific questions to ask the data that move toward the goal, ordered logically.
4. For each question, name the slice or aggregation and the chart to inspect it.
5. Flag likely traps: outliers, mixed grains, survivorship or selection bias, correlation-not-causation.
6. State what evidence would confirm or kill the leading hypothesis.
CONSTRAINTS: Do not state conclusions you cannot support from the described data. Distinguish observation from inference. Quantify uncertainty where relevant.
OUTPUT FORMAT: Sections: Profiling Checklist, Column Roles, Question Plan (table: question / slice / chart), Bias & Trap Flags, Confirm-or-Kill Criteria.