Learn how to design awesome dashboards.

The aim of this training is to teach basic visualization and design principles to be applied in static and dynamic dashboards in Microsoft Excel, covering layout and coloring etc. together with the rules and techniques for the correct use of data sets before design phase.

For whom?

For employees who want to bring their data to life with static, dynamic and interactive reports and who use Excel in their daily life.

Course Content

Recap: Data Visualization

• Data visualization and design

• Main principles in dataviz

• A case study: Data visualization

​

Dashboard design

• Dashboard types

• Exploratory vs. explanatory dashboards

• Static vs. dynamic dashboards

​

Dashboard design methodology

• Design based on use of purpose

• How to choose visuals

• Deciding on dashboard content

• Designing in Excel

​

Dashboard design exercises

• A static and explanatory dashboard design: Airlines Ltd. case study

• Dynamic dashboard design: Videogames dataset case study

• Professional dashboard design: Advanced techniques