Lesson ProgressPhase 2 of 6
Phase 2Introduction
Introduction: Integration & Presentation: Decision‑Ready Dashboard
From model to decision: scenario tools, exact‑match linking, and KPI selection
📚 Phase 2: Introduction
From Model to Decision
Build a driver table, switch scenarios by name, link outputs to visuals, and define KPIs that matter.
Core Integration Tools
Scenario driver table pattern:
Drivers Table Columns: Scenario | PriceChangePct | FoodCostPct | LaborRatePct | WastePct | KPI Targets SelectedScenario (named cell) drives: =XLOOKUP(SelectedScenario, Drivers[Scenario], Drivers[FoodCostPct], "Missing")
Stable visuals via structured references:
=SUM(SalesTable[Units]) // Charts point to model outputs that reference Table[Column]
Safe fallbacks:
=IFNA(XLOOKUP(...), 0) =IFERROR(calculation, "Check Inputs")
Integration Vocabulary
Complete each sentence to lock in the patterns professionals use.
Attempts: 0Score: 0%
📝 Fill in the Blanks
Complete each sentence by typing the missing word or phrase
📚 Word Bank
Available answers