Who This Helps
This is for junior analysts who need to stop a KPI drop from becoming a confusing blame game. It uses the 'Stakeholder Lens' from the Data Storytelling for Stakeholders course to turn panic into a clear path forward.
Mini Case
Your weekly report shows a 15% drop in user sign-ups. The team is pointing fingers at marketing, the product, and even the weather. You have one hour before the stand-up to figure it out.
Do This Now (5 Steps)
- Freeze the panic. Open a blank doc. Write the exact KPI, the drop (e.g., 'Sign-ups down 15% week-over-week'), and the date range.
- Ask the one question. What is the single decision your stakeholder needs to make from this? Write it at the top. (This is your 'Key Message' mission from the course).
- Map the funnel. Break the KPI into 3-4 core parts. For sign-ups, that's site visits, landing page views, form starts, and form completes.
- Find the leak. Check the change for each part. Did visits drop 15% too? Or did visits stay flat but form completes crash by 30%? The biggest percentage change is your leak.
- Name the cause. The leak points to the system. A visits drop points to traffic sources. A form-complete crash points to a broken button or confusing field. You now have a hypothesis, not a guess.
Avoid These Traps
- Don't start by pulling ten different charts. You'll drown in data.
- Don't present 'the data' without a suggested root cause. Stakeholders need a starting point.
- Don't ignore seasonality. Check if this happened last year.
- Don't mix correlation with causation. Just because a blog launch happened doesn't mean it caused the drop.
- Don't forget to check data quality. Was there a tracking code error?
- Don't present to your boss without a one-sentence summary ready.
- Don't try to diagnose more than one KPI at a time. Focus wins.
- Don't skip writing it down. Your doc is your diagnosis report.
Your Win by Friday
You'll walk into your next KPI fire drill with a simple, repeatable script. Instead of a stressful hour of random queries, you'll spend 20 minutes in a focused hunt and have a clear, evidence-based 'here’s what we think happened' for the team. You'll look like the calm expert in the room. Pretty cool, right?