Course curriculum

  • 1

    Introduction

  • 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

  • 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

      FREE PREVIEW

    • 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

  • 10

    Qualified Assessment

    • Qualified assessment

    • Dashboards & Data Visualization course evaluation