Who This Helps
This is for junior analysts who get a sudden KPI drop and need to ship a clean analysis with clear recommendations. If you're in the Metrics & Dashboards Basics course, you already know your North Star Metric. Now use it to diagnose.
Mini Case
Maya, a junior analyst, saw her team's weekly active users drop 12% in 7 days. She opened her dashboard, but it was cluttered with 20 numbers. She felt stuck. Instead of guessing, she used a focused session to trace the drop to a single supporting metric: new user activation fell 8% after a product change. She found the root cause in under an hour.
Do This Now (5 Steps)
- Pick your primary metric. Start with your North Star Metric from the course. If it dropped, don't panic.
- Check your supporting metrics. Look at the 3-5 metrics that feed your primary one. Which one moved first?
- Set a time window. Compare the drop period to the previous 7 days. Use your weekly scoreboard for this.
- Find the change. Ask: what changed in the product, marketing, or data source? Maya found a new onboarding flow caused the activation drop.
- Write one recommendation. State the root cause and one clear fix. Example: "Revert the onboarding change to restore activation."
Avoid These Traps
- Chasing 20 numbers. Focus on your metric tree, not everything. Clutter hides the signal.
- Blaming the data first. Check your dashboard layout for misleading charts before assuming a real drop.
- Skipping the time comparison. A 12% drop looks scary, but compare to last week's trend first.
- Making vague recommendations. Say "fix the activation flow" not "improve user experience."
- Working alone. Ask a teammate to sanity-check your root cause. Two heads are better than one.
- Forgetting guardrails. Set alerts for your key metrics so you catch drops early, not after 7 days.
Your Win by Friday
By Friday, you'll have a one-page analysis that names the root cause and a clear recommendation. Your team will trust your data. And you'll feel calm knowing you can diagnose any KPI drop in one focused session. Plus, you'll look like a hero when you say "I found it in the activation metric."