Plan the Dashboard: Questions, KPIs & Layout
This lesson is part of the course
In this lesson
You turn Ridgeway Outdoor's first-half sales into the four headline KPIs of its dashboard: total sales, growth vs last year, % of target and the latest month's momentum.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Plan the Dashboard: Questions, KPIs & Layout Locked
- KPI Cards with Green/Red Rules Locked
- The Trend Chart: This Year vs Last Year Locked
- Category Breakdown: A Sorted Bar Chart with Labels Locked
- Sparklines: A Trend in Every Region Row Locked
- Target vs Actual: Combo Charts & the Secondary Axis Locked
- A Month Picker: INDEX/MATCH & SUMIFS-Driven KPIs Locked
- Final Project: The One-Page Sales Report Locked