Who This Helps
This is for you, the Junior Analyst who just saw a key number drop and needs to figure out why—fast. You want to ship a clean analysis with clear recommendations, not a messy spreadsheet. The Metrics & Dashboards Basics program is your shortcut.
Mini Case
Meet Sam, a Junior Analyst at a subscription box company. Last week, the weekly active users dropped 12%—from 5,000 to 4,400. Sam had 90 minutes before the team standup. Using the North Star Metric mission from the program, Sam focused on one primary metric: "active subscribers." Then Sam checked three supporting metrics: new sign-ups, churn rate, and session frequency. The culprit? A 7-day email delivery delay caused a 15% churn spike. Sam shipped a one-page analysis with a clear fix: fix the email pipeline. The team loved it.
Do This Now (5 Steps)
- Pick your primary metric. Don't track 20 numbers. Use the North Star Metric mission to choose one. For Sam, it was active subscribers.
- List three supporting metrics. These are the levers that move your primary metric. New sign-ups, churn rate, and session frequency are good starters.
- Grab the last 7 days of data. Compare to the previous 7 days. Look for the biggest change. Sam saw churn rate jump from 2% to 17%.
- Ask "why" three times. For the churn spike: Why? Email delay. Why? Server issue. Why? Missed alert. Now you have a root cause.
- Write one recommendation. Keep it short. Example: "Fix email delivery pipeline and add a daily alert for churn rate above 5%."
Avoid These Traps
- Don't chase every number. Stick to your primary metric and three supporting ones. Ignore the rest.
- Don't guess the cause. Use data, not hunches. Sam checked the numbers before blaming marketing.
- Don't write a novel. One page max. Bullet points are your friend.
- Don't skip the recommendation. Your job is to diagnose and suggest a fix. Don't just report the drop.
Your Win by Friday
By Friday, you'll have shipped a one-page analysis that pinpoints the root cause of a KPI drop. Your team will see you as the calm, data-driven analyst who gets things done. And you'll feel like a superhero—no cape required.