Who This Helps
Hey Junior Analyst. You just saw your key metric drop 15% this week. Your manager asks 'why?' before lunch. This is for you. It's a core skill from the Metrics & Dashboards Basics course.
Mini Case
Maya's team tracks 20 numbers. Her North Star metric—user signups—suddenly dropped from 500 to 425 per day. Panic? Nope. She built a weekly scoreboard in the course. It showed the drop, but her three supporting metrics told the real story: website traffic was steady, but the signup form's success rate crashed from 12% to 8%. The root cause was a broken form field, not a marketing problem. She fixed it in two days.
Do This Now (5 Steps)
- Open your weekly scoreboard. Don't get lost in other tabs. This is your home base.
- Spot the primary drop. Which main KPI is down? Note the size and time frame (e.g., '15% over 7 days').
- Check the supporting actors. Look at the 2-3 metrics that directly feed your main KPI. Are they all down, or just one? This is your metric tree in action.
- Drill into the broken link. If only one supporting metric fell, that's your culprit. Now you know where to investigate.
- Form your one-sentence diagnosis. Example: 'Signups dropped because the form completion rate fell, not because traffic changed.' Boom.
Avoid These Traps
- Chasing every number. You see 10 charts moving. Ignore the noise. Focus only on the metrics connected to your primary KPI.
- Starting without a baseline. If you didn't set clear weekly targets, you're just watching waves. Know what 'normal' looks like first.
- Blaming 'everything.' A vague root cause helps no one. Your job is to pinpoint the single biggest lever that moved.
- Skipping the guardrails. Did you set up alerts for big swings? If not, you're always reacting to surprises. Not a fun way to live.
Your Win by Friday
Your win is simple: one clear, evidence-based answer. Next time a metric dips, you won't scramble. You'll open your dashboard, follow the trail of supporting metrics, and tell your team exactly what broke. You'll ship clean analysis with a clear recommendation before the meeting even starts. That's the power of a calm, trusted scoreboard.