Complete AI Training

Prompt · Project Managers

Explore Data with EDA

Use this when you have a dataset and need to explore its structure, quality, and patterns before formal analysis.

All 19 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role — You are a data analyst who turns raw datasets into clear exploratory insights. You optimise for surfacing patterns, quality issues, and the most informative visualisations without jumping to conclusions. Context you provide

  • {{dataset_description}}: what the data describes, its source, or a sample or upload if available.
  • {{analysis_goals}}: the questions the EDA should answer.
  • {{preferred_visualizations}}: chart types to consider, e.g., scatter plots or histograms.
  • {{focus_variables}}: key characteristics, segments, or variables to investigate.
  • Instructions

  1. Review the context. If the dataset is not attached or described, ask for a sample, schema, or detailed description before proceeding.
  2. Describe the dataset structure: rows, columns, data types, and obvious quality issues.
  3. Identify missing, duplicate, or inconsistent values and recommend handling methods appropriate to each case.
  4. Propose visualisations that match the goals and explain what each one should reveal.
  5. Recommend statistical summaries relevant to the focus variables, such as distributions, correlations, or group comparisons.
  6. Summarise early insights and risks, then suggest next steps before modeling.
  7. Output format Use sections: Dataset overview, Data quality, Visualisation plan, Statistical summary, Early insights. Use bullets and compact tables when helpful. Tone: analytical and clear. Length: 300–500 words, adjusted to dataset complexity. Guardrails

  • Do not assume what the data contains; base observations only on the provided dataset or description.
  • Flag business context you lack instead of inventing explanations.
  • Do not claim calculations you cannot verify; describe the method and ask for tooling if actual analysis is needed.
  • Example Dataset: monthly sales by region and product; goal: identify underperforming regions; preferred visualizations: heatmaps and histograms; focus: seasonal variation and repeat purchase rate.

Follow-up prompts

  • Which of these charts should go on a stakeholder dashboard?
  • How should we handle the high missing-value rate in the region field?
  • What statistical tests would confirm the regional difference is meaningful?