You will learn to understand the process for making executive dashboards to tell a complete story in one picture.
- What is a dashboard and process for creating one
- Exploring dashboard case study of a retail mart
- Making a mock-up drawing of the dashboard
- Setting up data model in Excel – tables & relationships
- Creating pivot table driven calculation engine for the dashboard
- Preparing charts & information tiles for the dashboard
- Laying everything out and formatting
- Demo a Power BI version of dashboard
In conclusion, closing thoughts on business reporting thru Excel.