Unit 4 • Lesson 60.8h
Integration & Presentation: Decision‑Ready Dashboard
Students turn Lesson04–05 forecasting into a live, investor‑ready system: scenario controls, linked visuals, validation, and clear decision cues.
What You'll Learn
- ▶Integrate forecasting outputs into a single, decision‑ready dashboard
- ▶Implement scenario switching (Base/Stretch/Downside) with exact‑match logic
- ▶Link model outputs to charts/tiles using structured references
- ▶Apply validation (IFNA/IFERROR) and audit checks for investor‑ready reliability
- ▶Communicate insights with concise executive summaries tied to KPIs
Key Concepts
Named‑range or driver table scenario control
XLOOKUP/INDEX‑MATCH exact‑match switching with IFNA/IFERROR fallbacks
Structured references (Table[Column]) for stable visuals
+2 more concepts
Lesson Phases
This lesson follows a structured 6-phase learning model designed for authentic project-based learning.
Hook
Live demo: one dashboard view with Base/Stretch/Downside and decision cues
Introduction
From model to decision: scenario tools, exact‑match linking, and KPI selection
Guided Practice
Build Sarah’s café dashboard with scenario controls, linked charts, and validation
Independent Practice
Integration mastery challenges with downloadable dataset; executive summary outputs
Assessment
Mastery check: scenario switching, linking, chart stability, and KPI judgment
Closing
Synthesis and reflection: reliability improvements and presentation readiness
How You'll Learn
Integrate prior skills into a scenario‑driven dashboard and present