Who This Helps
This is for junior analysts who need to explain a sudden drop in a key metric, like a 15% dip in weekly sign-ups. It uses the Stakeholder Lens from the Data Storytelling for Stakeholders course to focus your search.
Mini Case
Your dashboard shows a 15% drop in new user sign-ups this week. Your boss asks, "What happened?" Panic sets in. You could spend hours digging through every data point. Instead, you use the Stakeholder Lens to ask: "What decision does my boss need to make from this?" The answer is likely, "Should we adjust our marketing spend?" That question guides your whole investigation.
Do This Now (5 Steps)
- State the Problem Simply. Write down the exact KPI drop. Example: "Weekly sign-ups fell 15% from 2,000 to 1,700."
- Apply the Stakeholder Lens. Ask: "What one decision does my stakeholder need to make?" Write it down.
- Check the Obvious First. Look for data collection errors or one-off events from the past 7 days.
- Segment Your Data. Break the KPI down by 3 key dimensions: traffic source, device type, and geographic region.
- Find the Story. Identify the single biggest contributor to the drop. For example, you might find a 40% decline from one specific ad campaign.
Avoid These Traps
- Don't present a list of 8 possible causes. It overwhelms people.
- Don't start deep analysis before checking for simple data errors. That's a classic time-waster.
- Avoid jargon like "multivariate anomaly." Say "the main problem is..."
- Don't forget to connect the cause back to the stakeholder's decision. Why does this 40% ad campaign drop matter to them?
Your Win by Friday
By Friday, you can walk into a meeting and say: "The 15% sign-up drop is primarily from our Brand X campaign, which saw a 40% decline. I recommend we pause that ad set and reallocate the budget by next Monday." You've pinpointed the root cause and given a clear next step. Your analysis is clean, and your recommendation is ready to ship. Nice work!