Lesson ProgressPhase 4 of 6
Phase 4Independent Practice
Independent Practice: Integration & Presentation: Decision‑Ready Dashboard
Integration mastery challenges with downloadable dataset; executive summary outputs
🧩 Phase 4: Independent Practice
Integration Mastery Challenges
Build your decision‑ready dashboard. Use scenario toggles by name, link visuals, and create an executive summary tied to KPIs.
Download Practice Data
Use this dataset with Base/Stretch/Downside lines, KPI targets, and edge cases for validation:
/resources/unit04-forecasting-integration-practice.csvCheck for: missing scenario names, negative or >100% rates, stale AsOfDate, and broken chart links.
Build Tasks
- Create a driver table with scenario names and assumptions.
- Set SelectedScenario (named cell) and switch by exact name using XLOOKUP or INDEX‑MATCH.
- Link outputs to dashboard charts/tiles using Table[Column] references.
- Add an audit panel: missing names, rate bounds, stale dates.
- Write a one‑paragraph executive summary that updates with KPIs.
Self‑Assessment Checklist
- Scenario switches by name; wrong names show a clear message.
- Charts update when you add rows (no fixed ranges).
- Validation flags appear for rates <0 or >1 and stale dates.
- Executive summary mentions runway, margin, and traffic thresholds.
- All assumptions are documented next to inputs.