Lesson ProgressPhase 5 of 6
Phase 5Assessment
Assessment: Integration & Presentation: Decision‑Ready Dashboard
Mastery check: scenario switching, linking, chart stability, and KPI judgment
✅ Phase 5: Assessment
Integration & Dashboard Mastery Check
Show technical skill and business judgment. Aim for investor‑ready standards: clarity, reliability, and auditability.
Integration Mastery
Answer to confirm scenario control, linking patterns, and KPI decisions.
1. Best pattern for scenario switching by name?
2. Chart ranges break when rows are added. What fixes it?
3. A scenario name is misspelled. What should the model show?
4. Which KPI set supports an investor decision for the café?
5. What is a sign of fragile integration?
6. Why use exact match instead of approximate match?
7. Which statement defines "investor-ready" here?
8. Which fallback communicates best during live Q&A?
9. When is INDEX-MATCH preferred?
10. Best way to prove chart stability?
0 of 10 questions answered
Executive Summary Artifact
Write a brief executive summary (2-3 sentences) that a café owner would use to make a decision about expanding operations. Your summary must cite specific KPIs from your dashboard.
Your summary should include:
- Name the scenario you recommend (Base/Stretch/Downside)
- Cite at least one specific KPI value and threshold
- State the action (expand/hold/reduce) and the reason
- Include one risk or limitation
Example:
Based on the Base scenario with a 12% profit margin exceeding our 10% threshold, I recommend expanding weekend hours. However, the Stretch scenario shows cash runway dropping to 8 weeks, which creates risk if customer traffic doesn't materialize.