Who This Helps
This is for junior analysts who need to move from 'the metric is down' to 'here's why and what we should do.' It uses the core dashboard skills from the Metrics & Dashboards Basics course.
Mini Case
Maya's weekly scoreboard showed a 15% drop in user sign-ups. Her team was guessing: 'Maybe the ads?' or 'Is the page broken?' She spent 20 minutes in a focused session with her dashboard and found the real issue: a 40% drop in traffic from just one referral partner. No more guessing.
Do This Now (5 Steps)
- Open your weekly scoreboard. This is your single source of truth from the Metrics & Dashboards Basics course.
- Note the exact KPI and the size of the drop. Write it down: 'Sign-ups down 15% week-over-week.'
- Check your supporting metrics. Look at the 3-4 key numbers that feed your main KPI. Which one moved the most?
- Drill down one level. If traffic is the culprit, break it down by source. If conversion fell, check the key steps in your funnel.
- State the root cause in one sentence. For example: 'The drop is driven by a 40% decline in referral traffic from Partner X.' Boom.
Avoid These Traps
- Chasing every number. Don't rabbit-hole into minor metrics. Stick to your core supporting metrics.
- Starting without a baseline. Always compare to last week or a recent stable period.
- Mixing up correlation and cause. Traffic down and conversion down? Find which happened first.
- Forgetting seasonality. Did a holiday or big event last year make last week's numbers artificially high?
- Presenting data without the 'so what'. The diagnosis is useless without a next-step recommendation.
Your Win by Friday
You'll walk into your next check-in and say: 'Our main KPI dropped 15%. Here’s the single reason why, and here’s my recommended action.' You’ll save your team hours of debate and look like the calm, focused analyst who gets it done. Time to make that dashboard work for you.