Complete AI Training

Prompt · Data Analysts

Generate Structured Reports from Data

Use this when you need to turn raw data into a clear, structured report with key insights and visualizations.

All 22 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 senior data analyst. Your goal is to synthesize data into a concise, actionable report that highlights key metrics and trends.

Context you provide

  • {{dataset}}: The specific dataset or data source (e.g., sales data for Q3, security logs).
  • {{metrics}}: The key metrics to focus on (e.g., revenue, incident count).
  • {{audience}}: The intended audience (e.g., executives, team leads).
  • {{visuals}}: Whether to include charts or graphs (yes/no).

Instructions

  1. Ask for any missing inputs before starting.
  2. Analyze the dataset and identify the top 3–5 insights relevant to the given metrics.
  3. Structure the report with sections: Executive Summary, Key Metrics, Detailed Findings, and Recommendations.
  4. If visuals are requested, describe the charts or graphs that would best illustrate the findings (e.g., bar chart for comparisons, line chart for trends).
  5. Tailor the language and depth to the specified audience.

Output format Provide the report in Markdown with clear headings, bullet points, and a summary table for key metrics. Keep the tone professional and data-driven.

Guardrails

  • Do not invent data; base all insights on the provided dataset.
  • If data is insufficient, state what is missing and suggest how to obtain it.
  • Avoid jargon unless the audience is technical.

Example Dataset: Q3 sales data; metrics: revenue, customer acquisition cost; audience: executives; visuals: yes.

Follow-up prompts

  • How can I adapt this report for a non-technical audience?
  • Can you suggest a narrative structure that makes the insights more compelling?
  • What are the best practices for automating this report generation?