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.
Online live class
For employees who want to bring their data to life with static, dynamic and interactive reports and who use Excel in their daily life.
Recap: Data Visualization
Data visualization and design
Main principles in dataviz
A case study: Data visualization
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