← Back to blog

Junior Analyst · Board Finance & Runway Narrative

Diagnose a KPI Drop in One Focused Session

Pinpoint root cause fast. Ship clean analysis with clear recommendations.

Who This Helps

This is for junior analysts who get a sudden KPI drop and need to figure out what happened. You want to deliver a clean analysis with clear recommendations, not just a chart that says "something went down." The Board Finance & Runway Narrative course shows you how to build a board-ready story from your numbers.

Mini Case

Imagine you're Viktor, a junior analyst at a SaaS company. Your boss just flagged that the monthly recurring revenue (MRR) dropped 12% in the last 7 days. Panic? Nope. You grab the Runway Trigger Tree mission from the course and start tracing the drop. Turns out, 3 key accounts churned because of a pricing change. You now have a root cause and a recommendation: roll back the change for those accounts.

Do This Now (5 Steps)

  1. Pull the raw data. Get the daily KPI values for the last 30 days. Look for the exact day the drop started.
  2. Segment the drop. Break the KPI by customer type, region, or product line. Find which segment caused the 12% drop.
  3. Trace the trigger. Use the trigger tree approach: ask "what changed?" on the day the drop started. Was it a pricing update, a feature release, or a competitor move?
  4. Quantify the impact. Calculate how much each factor contributed. For example, churn from 3 accounts = 8% of the drop, and downgrades from 2 accounts = 4%.
  5. Write your recommendation. One sentence: "Roll back the pricing change for the affected accounts to recover the 12% MRR drop within 2 weeks."

Avoid These Traps

  • Don't just show the drop. Your boss wants the "why" and the "what now." A chart without a story is just noise.
  • Don't blame one thing too fast. Check at least 3 possible causes before you pick one. The trigger tree helps you stay objective.
  • Don't skip the numbers. Use actual percentages and dates. Saying "a few customers left" is weak. Saying "3 accounts churned on June 5th" is powerful.
  • Don't forget the fun part. Yes, you're diagnosing a problem, but you're also the hero who saves the day. Own it.

Your Win by Friday

By Friday, you'll have a one-page memo that says: "MRR dropped 12% due to 3 account churns from a pricing change. Recommendation: roll back the change for those accounts. Expected recovery: 2 weeks." Your boss will nod, say "nice work," and you'll feel like a rockstar. That's the power of a focused diagnosis session.