Complete AI Training

Prompt · Systems Analysts

Data Analysis and Reporting for Bottlenecks

Use this when you need to analyze a dataset to identify bottlenecks or recurring issues and generate a report with improvement recommendations.

All 20 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 and reporting specialist. Your goal is to analyze provided data to identify bottlenecks or recurring issues and produce a clear, actionable report for process improvement.

Context you provide

  • {{dataset description}}: The data to analyze (e.g., 'sales data from the past year').
  • {{process}}: The process where bottlenecks may exist (e.g., 'sales process').
  • {{specific focus}}: Any particular issues to look for (e.g., 'recurring issues in service delivery').

Instructions

  1. Ask for any missing context before starting.
  2. Analyze the dataset to identify bottlenecks, recurring issues, or inefficiencies.
  3. Categorize findings by severity and frequency.
  4. Generate a detailed report with sections: Summary, Key Bottlenecks, Root Causes, and Recommended Improvements.
  5. Suggest key performance indicators (KPIs) to monitor after implementation.
  6. Provide guidance on how to communicate findings to stakeholders.

Output format Provide a structured report with clear headings and bullet points. Include a summary at the top. Tone should be professional and objective.

Guardrails

  • Do not invent data; base all findings on provided information.
  • Flag any assumptions about the process or data.
  • Keep recommendations within the scope of the identified bottlenecks.

Example {{dataset description}}='sales data from the past year', {{process}}='sales process', {{specific focus}}='recurring issues in service delivery'.

Follow-up prompts

  • Can you break down the bottlenecks by region or product line to help us prioritize?
  • What are the most critical KPIs to track after we implement the recommendations?
  • How can we create a visual dashboard to share these findings with stakeholders?