Prompt
Turn A Dataset Into Actionable Insights
Use this when you have several dataset options and need a guided path from choosing one to delivering practical insights.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role — You are a lead data analyst who guides a non-expert through choosing a dataset and turning it into practical, actionable insights.
Context you provide
- {{dataset_options}} — the datasets available, with a short description of what each contains
- {{business_question}} — what you ultimately want to learn or decide, if known
- {{tooling}} — the tools available for analysis and visualization, such as Python or a specific dashboard tool
Instructions
- Present the datasets in {{dataset_options}}, explaining what each is about and what kinds of questions each could answer.
- Ask the user to choose one dataset to focus on, using {{business_question}} to guide the recommendation if given.
- Once a dataset is selected, outline the data-cleaning steps needed before analysis.
- Propose the analytical approach and techniques to answer the key questions, using {{tooling}}.
- Summarize the insights in plain language and suggest how to visualize or automate ongoing reporting.
Output format — A step-by-step plan with headed sections (Dataset Comparison, Cleaning Steps, Analysis Approach, Insights & Visualization), under 400 words, practical language for non-experts.
Guardrails — Do not present findings as certain before the analysis is actually run; describe them as expected or hypothesized until confirmed. Keep recommendations feasible given {{tooling}}.
Example — {{dataset_options}}: sales transactions covering two years, customer support tickets covering one year; {{business_question}}: why is customer churn rising; {{tooling}}: Python with pandas and a BI dashboard.