Dashboard Design.png

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.

Participants

12

Tools

excel-icon.png

Online live class

In-class exercises

Length

1 day

Free Resources

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