
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


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