Smart data presentation. Design and present charts and dashboards.

14+ hours of e-learning in 10-minute micro-modules "as needed" + downloadable templates. This course provides all you need to effectively convey quantitative information through tables, graphs, and dashboards.

Buy €290,00 Free Preview

Pricing options

€290,00

Regular price (enrolment duration 60 days )

Get started now

Introduction to the course

Course sheet

Objectives

Using tables, graphs and dashboards to communicate quantitative information is a common practice in the business world for every managerial function.

Through this course, you will learn how visual perception works from a neuroscientific point of view and which graphic object to use according to the message you want to communicate or the situation you want to represent.

Take away

A clear understanding of the neuroscience mechanisms of visual perception.

The ability to choose and build the right chart to represent quantitative information.

An actual library of graphics in PowerPoint format, ready to be used in your presentations and dashboards.

Testimonials

Key Account Manager

Martina Masenga

The course was exciting! Congratulations, because in all the video clips, Roberto always manages to keep the attention high. In addition, the ppt 'template' is a handy tool; it will be helpful for my future professional life! I learned a lot, and it gave me a lot of new insights.

Course curriculum

1. Introduction to the course.
  FREE PREVIEW
2. How to use the Template provided with the course.
3. DOWNLOAD - PowerPoint template for graphics.
1. Scales, measures and categories. In-depth study with bibliography and curiosities.
2. Objective and subjective variables. A misunderstanding to avoid.
1. Neuroscientific basis of visual perception. How to communicate effectively.
2. Psychophysics. Persuade and not confuse the audience.
3. The laws of Gestalt. How do our brains perceive structure and patterns to understand better the environment around us?
4. Limits to the perception of diversity. Why "less is more"!
1. Graphs and Tables. When are they used and why.
1. Drawing effective tables.
2. Rules for drawing effective tables.
1. Types of basic graphic components.
1. Vertical and horizontal bar charts. Express comparisons and orderings.
2. OPERATING INSTRUCTIONS - Vertical bar chart, 1 nominal category with the Template.
3. OPERATING INSTRUCTIONS - Vertical bar chart, 2 nominal categories with the Template.
4. The bar chart to express parts of a whole (substitute for pie / donut charts).
5. OPERATING INSTRUCTIONS - Horizontal bar chart (ranking) with the Template.
6. The bar chart with the reference line. Express deviation from a reference.
7. OPERATING INSTRUCTIONS - Vertical bar chart with reference line with the Template.
8. OPERATING INSTRUCTIONS – Bar charts with reference lines. How to build them from scratch with Excel (and PowerPoint).
1. Line chart and time series. Show trends over time.
2. Line chart and reference area. Express deviation from a reference.
3. OPERATING INSTRUCTIONS - Line chart (one or more categories) and time series with the Template.
4. OPERATING INSTRUCTIONS - Line chart and reference area with the Template.
5. OPERATING INSTRUCTIONS - Line charts with reference area. How to build them from scratch with Excel (and PowerPoint).
1. Small Multiples Charts.
1. Scatter Plots.
2. OPERATING INSTRUCTIONS - Scatter Plots with the Template.
1. Dot Plots. Besides the scatter plot!
2. OPERATING INSTRUCTIONS - Dot Plots to compare small differences, with the Template.
3. OPERATING INSTRUCTIONS - Dot Plots to represent concentrations of events, with the Template.
4. OPERATING INSTRUCTIONS - Dot Plots to represent evaluations, with the Template.
1. Heat Maps & Spatial Maps.
2. OPERATING INSTRUCTIONS - Create a Heat Map with Excel.
3. OPERATING INSTRUCTIONS - Create a Spatial / Geographical Map with Excel.
4. DOWNLOAD - Examples of Geographic Maps with Excel.
1. Pareto Graph.
2. OPERATING INSTRUCTIONS - Pareto Graph with the Template.
1. Basics of Descriptive Statistics.
2. Basics of Descriptive Statistics. How to calculate the indicators of central tendency and dispersion with Excel.
3. DOWNLOAD - Example of calculation of descriptive statistics indicators (mean, median, range, standard deviation).
1. Histograms and frequency distribution. Distribution of a measure in a population.
2. OPERATING INSTRUCTIONS - Histogram Charts with the Template.
1. Box plots, Box and Whiskers Charts. Distribution of a measure in a population.
2. OPERATING INSTRUCTIONS - Box plots, Box and Whiskers charts with Excel.
1. DASHBOARD: Situation awareness at a glance.
1. Bullet graphs.
2. OPERATING INSTRUCTIONS - Vertical Bullet graphs with the Template.
3. OPERATING INSTRUCTIONS - Horizontal Bullet graphs with the Template.
1. Sparklines Charts.
2. OPERATING INSTRUCTIONS - Sparklines Graphs with Excel and the Template.
1. Alert & On-Off icons.
2. OPERATING INSTRUCTIONS - Alert & On-Off icons from Excel to PowerPoint.
1. Developing a dashboard. A comprehensive example.
2. DOWNLOADABLE TEMPLATE - Questions and guidelines for choosing Dashboard charts.
3. DOWNLOADABLE TEMPLATE - Example of dashboard.
1. Before we finish ...

About this course

€290,00
83 micro-modules of 10-15 min: videos, readings, interactive quizzes.
Downloadable chart library template.

Instructor(s)

Senior Trainer and Coach, HURACT Roberto Bonanomi

PsyD. MSc Occupational Psychology & researching in OP/OB at University of London, Birkbeck. Graduate Member of the British Psychological Society in the UK (MBPsS). MSc Computer Science, MSc Clinical Psychology, Roberto is an enthusiastic trainer and coach with sound communication skill, a robust corporate culture gained in years of professional experience as a consultant and psychologist and rooted academic background. Roberto was the founder, director and principal instructor of the master in organizational coaching at the Palo Alto School in 2012-2013 and 2013-2014.