← Back to blog

Junior Analyst · Founder Finance Basics Mission Pack

Diagnose a KPI Drop: Junior Analyst Guide

Find root cause fast in one focused session. Ship clean analysis with clear recommendations.

Who This Helps

You're a junior analyst who just saw a key metric drop. Maybe revenue dipped 12% this week, or user signups fell off a cliff. Your boss wants answers by Friday. You want to deliver a clear diagnosis without getting lost in spreadsheets.

This guide uses the Founder Finance Basics Mission Pack approach to help you pinpoint root cause fast. One mission, "Unit Economics Snapshot," teaches you to spot the real story behind the numbers.

Mini Case

Imagine you work at a SaaS startup. Last month, monthly recurring revenue (MRR) grew 8%. This month, it dropped 5%. Your CEO asks why. You pull data and see new customer adds fell 20%, but churn stayed flat. The real culprit? A pricing page change that confused visitors. Conversion rate dropped from 3% to 2.1%.

Numbers like these help you focus. You don't need to guess. You need a system.

Do This Now (5 Steps)

  1. Grab the last 7 days of data. Compare to the prior 7 days. Look for the biggest change.
  2. List all possible causes. Write down 3 to 5 ideas. Example: traffic drop, conversion issue, pricing glitch.
  3. Check one metric at a time. Start with the one that changed most. For our case, that's conversion rate.
  4. Ask "why" three times. Why did conversion drop? Because fewer visitors clicked "Start Free Trial." Why? Because the button moved. Why? Because the team tested a new layout.
  5. Write one clear recommendation. Example: "Revert pricing page to old layout. Monitor conversion for 3 days."

Avoid These Traps

  • Chasing every metric. Pick one root cause. Don't try to fix everything at once.
  • Blinding yourself with data. Too many charts can hide the story. Start simple.
  • Forgetting the business impact. A 5% MRR drop matters. Connect your analysis to dollars.
  • Skipping the recommendation. Analysis without action is just noise. Always end with a next step.
  • Waiting for perfect data. You have enough to start. Ship your first draft today.

Your Win by Friday

By end of week, you'll have a one-page diagnosis your boss can act on. You'll know the root cause, the impact (like 12% revenue dip), and the fix. That's a clean analysis with clear recommendations. And you'll feel like the person who saved the day.

Fun fact: The best analysts don't know everything. They just know where to look first. You've got this.