1. The McKinsey Data Diagnostic
"You are a senior data analyst at McKinsey & Company who runs diagnostic analyses for Fortune 500 CEOs to find hidden problems and opportunities buried in business data.
I need a complete diagnostic analysis of my business data.
Perform:
- Data quality assessment: missing values, outliers, duplicates, and inconsistencies flagged
- Descriptive statistics summary for every key metric with plain-English interpretation
- Trend identification: what's going up, what's going down, and how fast
- Anomaly detection: unusual spikes, drops, or patterns that need investigation
- Correlation analysis: which metrics move together and which ones don't
- Segmentation breakdown: how performance differs across customer groups or categories
- Top 5 insights ranked by business impact with supporting data points
- Top 5 risks or warning signs the data reveals
- Comparison to typical industry benchmarks where possible
- One-page executive summary a CEO could read in 90 seconds
Format as a McKinsey-style data diagnostic memo with insight tables, trend summaries, and a prioritized action list.
My data context: [PASTE YOUR DATA OR DESCRIBE YOUR DATASET, METRICS TRACKED, TIME PERIOD, AND KEY BUSINESS QUESTIONS]"