Who This Helps
If you're a Junior Analyst tired of last-minute data requests and shifting priorities, this is for you. The Metrics & Dashboards Basics course gives you the system to move from reactive to proactive. You'll stop answering 'what happened?' and start guiding 'what should we do next?'
Mini Case
Maya's team tracked 20 different numbers every week. Each meeting, someone would highlight a different metric, causing the team to pivot. One week it was 'signups are down 12%!' The next, 'session time is up 7 minutes!' It was chaos. She built a weekly scoreboard with one primary metric and three supporting ones. In 4 weeks, meeting time dropped by 30 minutes, and the team agreed on next steps 90% faster. No more whiplash.
Do This Now (5 Steps)
- Pick your North Star. From the 20 numbers you track, choose the single metric that best reflects your core goal. Is it active users? Revenue? Customer satisfaction? Write it down with a crystal-clear definition.
- Choose three supporting actors. Pick three metrics that directly influence your North Star. For 'active users,' that might be 'new signups,' 'feature adoption rate,' and 'weekly retention.' Give each a realistic target.
- Build your weekly scoreboard. Open your dashboard tool. Create one big chart for your North Star. Place the three supporting metrics right below it. This is your new home screen.
- Add simple guardrails. For each supporting metric, set a basic rule. If 'new signups' drops 15% below target for two weeks, it's time to investigate. This turns noise into a signal.
- Schedule the ritual. Block 30 minutes every Monday morning for you and your key stakeholder to review this scoreboard together. Consistency is your secret weapon.
Avoid These Traps
- The Everything Dashboard: Don't try to display every chart you've ever made. If it doesn't connect to your North Star this week, it doesn't go on the main board. You can keep other tabs for deep dives.
- Moving Target-itis: Once you set your supporting metrics and targets, stick with them for at least a month. You can't judge progress if you change the test every week.
- Skipping the Ritual: The dashboard is useless if no one looks at it. The weekly meeting is non-negotiable. It's the heartbeat of your analysis.
- Analysis Paralysis: Your job is to provide a clear recommendation, not just the data. Every weekly review should end with: 'So, based on this, I recommend we...'
Your Win by Friday
By this Friday, you will have a one-page dashboard with your North Star and three supporting metrics. You'll have sent a calendar invite for a recurring 30-minute weekly review. Your stakeholder will know exactly what to look at, and you'll have a clear path for your analysis. You'll trade chaos for calm, one chart at a time. Go make your scoreboard!