Dashboard Architecture, KPI Metrics & Source Prep
Separate raw transactions from KPI summary calculations and build clean attainment metrics for sales leadership.
Key takeaways while you watch
- Keep Raw Data, Staging Calculations, and Dashboard View on separate tabs.
- Limit the top KPI strip to 3-5 core decision metrics with Actual vs Target comparison.
- Convert raw transaction ledgers into Ctrl+T Tables before linking charts.
Drill: Compute Quota Attainment Percentage
Write a formula for cell D2 that divides B2 (Actual Revenue) by C2 (Target Quota) to compute Quota Attainment %.
| Region | Actual (B) | Target (C) | Attainment % (D) |
|---|---|---|---|
| North America | 420000 | 400000 | =? |
| EMEA | 285000 | 300000 | 95.0% |
Module 01 Knowledge Check
Answer all 3 questions and check your score to unlock credit toward completion.