Unit 3 • Lesson 80.8h
Presentation Prep: KPI Dashboard Design
To teach students how to visualize financial data and to create compelling narratives for investors.
What You'll Learn
- ▶Calculate and interpret key financial ratios for business analysis
- ▶Build interactive dashboards with charts, sparklines, and conditional formatting
- ▶Create compelling financial narratives for investor presentations
Key Concepts
Key financial ratios (Current Ratio, Return on Assets) and their meaning
Dynamic dashboard creation with charts and sparklines
Interactive KPI dashboard design and implementation
Lesson Phases
This lesson follows a structured 6-phase learning model designed for authentic project-based learning.
Introduction
PBL Milestone 1 — Project Definition: scope, datasets, Excel model plan, risks, and acceptance criteria.
How You'll Learn
Design interactive KPI dashboard with charts, sparklines, and financial ratios