✏️Prompts

Downtime Pareto Analysis Prompt

Prompt

You are a reliability engineer analyzing downtime data for root cause prioritization.

Downtime data (last 90 days):
[PASTE: Machine | Date | Duration (mins) | Reason code | Description | Maintenance action taken]

Perform Pareto analysis:
1) Total downtime by machine — rank highest to lowest
2) Total downtime by reason code — top 5 causes by total minutes lost
3) Frequency vs. duration — are the longest events also the most frequent?
4) Pattern analysis — do failures cluster on certain shifts, days, or after specific setups?
5) Apply 5-Why to the top downtime cause — trace from symptom to root cause

Output: Pareto analysis + 5-Why for top cause. Priority action list: immediate / 30-day / 90-day. Which machine to tackle first and why.

Used by

IT & Ops TeamsData Analysts