Diagnose a KPI Drop: Junior Analyst’s 5-Step Fix

Who This Helps

You’re a Junior Analyst who just saw a key metric dip. Your boss wants answers by Friday. You want to deliver a clean analysis with a clear recommendation—not a data dump. This guide, based on the Data Storytelling for Stakeholders course, helps you diagnose the drop fast and confidently.

Mini Case

Imagine you track weekly active users. Last week, the number fell 12%—from 10,000 to 8,800. Your stakeholder, Li Wei, needs to know why and what to do. You have one focused session to find the root cause. Let’s walk through how you do it.

Do This Now (5 Steps)

1. Grab the one metric that matters. Don’t look at everything. Pick the KPI that dropped—like weekly active users. Write it down.

1. Check the date range. Was the drop sudden (one day) or gradual (over a week)? For our case, it happened over 3 days. That’s a clue.

1. Slice by a simple dimension. Break the KPI by a key segment—like new vs. returning users. In our case, new users dropped 20%, while returning users stayed flat. Bingo.

1. Ask one “why” question. Why did new users drop? Check if a marketing campaign ended or a sign-up flow broke. You find a 15% increase in sign-up errors on day 2.

1. Write your recommendation. Say: “Fix the sign-up error to recover new users. Expected impact: +15% in 7 days.” That’s your clean analysis with a clear ask.

Avoid These Traps

• Don’t chase every chart. Stick to the one KPI. Too many visuals distract from the story.
• Don’t blame without evidence. Numbers first, then root cause. Avoid guessing.
• Don’t skip the ask. A recommendation without an owner is just noise. Li Wei needs to know who acts next.
• Don’t overcomplicate. Use one page for your snapshot. Stakeholders skim.
• Don’t forget the timeline. Show when the fix will land. 7 days is concrete.

Your Win by Friday

By Friday, you’ll have a one-page executive snapshot that says: “KPI dropped 12% due to sign-up errors. Fix in 7 days. Owner: Engineering.” That’s a win. You’ll feel like the analyst who actually helps decisions happen. And honestly, that’s a pretty good feeling.