Intermediate level · Module 6: Excel Reporting System Project · Lesson 2 of 3
Model, Measures and Dashboard
Build the model, measures, scenario sheet, dashboard and automation.
In this lesson you will
- Implement the model and measures
- Build the dashboard and one automation
Key concepts
star schemameasuresscenario sheetdashboard
The lesson
Model the data as a star schema with a date table, and write measures for every agreed figure, each checked independently.
Add a scenario sheet for the key decision and build the dashboard with connected slicers.
Automate one repetitive task, such as exporting the report as PDF.
Step by step
- Build the model.
- Write and check the measures.
- Build the scenario sheet and dashboard.
- Add the automation.
Practice activity
Complete the model, measures, dashboard and automation.
Expected result: A working system with every measure checked.
Check your understanding
-
Why check every measure independently?
Show answer
To be sure the reported figures are correct.
-
What is the scenario sheet for?
Show answer
Exploring the effect of different assumptions on a key decision.
Taught live by an instructor — online or in person. Free course lessons are for self-study and do not lead to a certificate — see registration options.