Course curriculum

  • 1

    Introduction

    • Course introduction

    • Objectives

    • Downloadable files

    • Storytelling with data

    • Data visualization

    • Bad vs good visuals

    • Interactive exercise 1

  • 2

    Context

    • Objectives

    • Know your audience

    • Tailor your message

    • The main idea

    • Storyboarding

    • Interactive exercise 2

  • 3

    Visuals

    • Objectives

    • Text, tables and heatmap

    • Line chart

    • Scatter plot

    • Column and bar charts

    • Combination charts

    • Tornado chart

    • Waterfall chart

    • Gauge and bullet charts

    • Interactive exercise 3

    • What not to do

    • Visual exercise

  • 4

    Focusing Attention

    • Focusing attention objectives

    • Pre-attentive attributes

    • Examples of pre-attentive attributes

    • Color

    • Enclosure

    • Shape and positioning

    • Other attributes

    • Interactive exercise 4

    • Focusing attention exercise

  • 5

    Design Principles

    • Objectives

    • Guides

    • Accessibility

    • Aesthetics

    • Interactive exercise 5

  • 6

    Dashboard #1

    • Objectives

    • Downloadable files

    • Why use dashboards

    • Executive decision making

    • Dashboard making process

    • Interactive exercise 6

    • Page orientation and print area

    • Making sections

    • Two-series line chart

    • Area chart

    • Column and marker chart

    • Gauge charts - data setup

    • Gauge charts - doughnut

    • Gauge charts - pie

    • Creating multiple gauge charts

    • Dashboard #1 final product

    • Quiz

  • 7

    Dashboard #2

    • Dashboard #2 preview

    • Downloadable files

    • Page layout and heading

    • Stacked column chart

    • Setting up for actual vs forecast

    • Combo - stacked column and line chart

    • Waterfall chart

    • Stacked area chart

    • Five-year performance summary table

    • Sparklines

    • Conditional formatting for variance analysis

    • P&L summary and balance sheet summary

    • Dashboard #2 final product

  • 8

    Dashboard #3

    • Dashboard #3 preview

    • Downloadable files

    • Net earnings waterfall

    • Combo - cash flow and cash balance

    • Bullet charts preview

    • Creating bullet chart

    • Formatting bullet charts

    • Setting up data tables for bullet charts

    • Dashboard #3 final product

  • 9

    Conclusion

    • Summary

  • 10

    Qualified Assessment

    • Qualified assessment

    • Share Your Feedback

    • Course Completion