Who This Helps
This is for junior analysts who want to stop delivering confusing spreadsheets and start shipping analysis that gets a thumbs-up from stakeholders. If you're tired of hearing "what does this mean?" after presenting your work, the Metrics & Dashboards Basics course is your shortcut to clear, actionable insights.
Mini Case
Meet Maya. She's a junior analyst at a fast-growing SaaS company. Her team tracks 20 numbers every week, but nobody agrees on which one matters most. Maya's boss wants a single, trusted metric that drives decisions. Maya picks the North Star Metric from the course: weekly active users. She defines it clearly, sets a target of 12% growth, and builds a weekly scoreboard with guardrails. When active users drop 3% in one week, the guardrail flags it. Maya presents the data with a clear recommendation: run a re-engagement campaign. Her boss approves it in the same meeting. No more confusion.
Do This Now (5 Steps)
- Pick your North Star Metric. Choose one primary metric that aligns with your company's goal. For Maya, it was weekly active users.
- Define 3 supporting metrics. These explain why the North Star moves. Maya used sign-ups, retention rate, and feature adoption.
- Set realistic targets. Use historical data or industry benchmarks. Maya set a 12% weekly growth target for active users.
- Build a weekly scoreboard. List your metrics, targets, and actuals. Add guardrails: if a metric drops more than 5% in a week, flag it.
- Write one clear recommendation. Based on the data, state what action to take. Maya recommended a re-engagement campaign after the 3% drop.
Avoid These Traps
- Tracking too many metrics. Stick to 4-5 key numbers. More than that and you lose focus.
- Vague definitions. Define each metric exactly. "Active users" could mean different things to different people.
- No targets. Without a target, you can't tell if you're winning or losing.
- Ignoring guardrails. A sudden drop can go unnoticed for weeks without alerts.
- Presenting data without a recommendation. Stakeholders want to know what to do next.
- Using complex charts. Simple bar charts or line graphs work best for weekly updates.
- Forgetting to update regularly. A stale dashboard is worse than no dashboard.
- Not testing your dashboard with a colleague. Get feedback before sharing with leadership.
Your Win by Friday
By Friday, you'll have a weekly scoreboard with your North Star Metric, 3 supporting metrics, targets, and guardrails. You'll present it to your boss with one clear recommendation. They'll say "yes" instead of "what does this mean?" And you'll feel like a pro. Plus, you'll have a template you can reuse every week. That's a win.