Who This Helps
This is for junior analysts who get a sudden KPI drop and need to deliver a clear diagnosis fast. You're not alone—this happens in every board finance and runway narrative course. The goal is to move from panic to precision in under an hour.
Mini Case
Imagine you're Viktor, a junior analyst at a SaaS startup. Your board signal is monthly recurring revenue growth. Last week, it dropped from 12% to 7%. Your CEO wants a root cause by Friday. Using the scenario envelope from the Board Finance & Runway Narrative course, you isolate the issue: a 3-day billing delay in one customer segment. That's your trigger.
Do This Now (5 Steps)
- Grab the last 30 days of data for your key KPI. Look for the exact day the drop started. For Viktor, it was day 14.
- Split the data by customer segment or product line. Compare before and after the drop. Viktor saw the dip only in enterprise accounts.
- Check one operational change on that day. Did you push a new feature? Change a price? Viktor found a billing system update.
- Run a simple correlation between the change and the KPI. Use a spreadsheet—no fancy tools. Viktor's correlation was 0.92.
- Write a one-paragraph recommendation with the root cause and a fix. Viktor suggested rolling back the billing update and monitoring for 7 days.
Avoid These Traps
- Don't chase every possible cause. Pick the top two and test them. Viktor ignored a rumor about competitor moves.
- Don't present raw data without a story. Your boss wants a clear narrative, not a dump. Use the board finance memo format from the course.
- Don't forget to quantify impact. Say "this drop cost us $50k in potential revenue" not "it was bad."
- Don't skip the recommendation. Diagnosis without a fix is just complaining.
Your Win by Friday
By Friday, you'll have a one-page diagnosis with a clear root cause and a recommended action. Your boss will see you as the analyst who can turn a crisis into a plan. And honestly, that feels pretty good—like finding the missing puzzle piece under the couch.