Who This Helps
You're a junior analyst who just saw a key metric drop. Maybe revenue dipped 12% overnight, or user signups slowed 7 days in a row. Your boss wants answers by Friday. This guide helps you diagnose fast and deliver a recommendation that sticks.
Mini Case
Meet Sarah, a junior analyst at a SaaS startup. She noticed the weekly active users dropped 15% in one week. Using the Founder Finance Basics Mission Pack, she ran a focused analysis. She found the drop was tied to a failed email campaign that went to 30% of users. She recommended pausing the campaign and testing a new subject line. Her team acted in 3 days, and the metric recovered.
Do This Now (5 Steps)
- Grab the data – Pull the last 30 days of the metric. Look for the exact day the drop started.
- Segment by channel – Break down the drop by traffic source, user type, or region. Find the biggest offender.
- Check for correlation – Did a product change, pricing update, or marketing campaign happen right before? Use the Pricing Scenario Guardrails mission from the course to test scenarios.
- Talk to a teammate – Ask the person who owns that area. They might already know the cause.
- Write one clear recommendation – State the root cause and one action. Example: "Pause the email blast to new users. It caused a 12% drop in signups."
Avoid These Traps
- Don't blame the data first. Check for human error or a tracking bug.
- Don't overcomplicate. A simple chart with one line is better than a dashboard with 10 tabs.
- Don't skip the recommendation. Your job is to suggest a fix, not just report the drop.
- Don't wait for perfect data. Use what you have and note assumptions.
- Don't ignore context. A 5% drop might be normal for a Tuesday. Compare to last week.
- Don't forget to celebrate small wins. Even finding the right question is progress.
- Don't assume the drop is bad. Sometimes a dip means you're testing something new.
- Don't work alone. A quick chat with a senior analyst can save hours.
Your Win by Friday
By end of week, you'll have a one-page analysis that shows the root cause and a clear recommendation. Your boss will see you as the person who spots problems and fixes them. And you'll feel like a detective who cracked the case. That's a good Friday.