Best Practice in Creating Data Visualizations and Dashboards (1 day)

  • March 21, 2019
    9:00 am - 4:00 pm

Poorly designed visualizations (graphs, reports, charts, slides etc.) can lead to confusion and in the worst case erroneous business decisions. End users are constantly seeking the best ways to understand the data behind the data. The most effective way to help end users is by making it visual for them. This course is aimed at taking participants through the basics of data visualization and design whether you are creating Power BI interactive reports, generating charts in Excel or management presentations in PowerPoint.

Minard's March to Moscow

Who should attend:
Anybody that creates graphs, charts, dashboards and presentations in Power BI, Excel, PowerPoint or any other Business Intelligence software tool.

This course will help you to:

  • Effectively engage with the end users to properly define context
  • Understand the importance of narrative and storyboarding as part of the design process
  • Understand what design elements engage inconic, short and long term memory in the end user increasing engagement
  • Matching visualizations to data, including best practices and implementation hacks (Excel and Power BI) for:
    • Interactive text
    • Data tables
    • Data table heatmaps
    • Scatterplots and bubble plots
    • Line charts
    • Bar Charts (Vertical & Horizontal)
    • Stacked Bar Charts (Vertical & Horizontal)
    • 100% Bar Charts (Vertical & Horizontal)
    • Area Charts
    • Waterfall Charts
    • Treemaps
    • Funnel Charts
    • Key Performance Indicator Gauges
    • Data Geographical Maps and Choropleth Maps
    • Charts to avoid
  • Fully understand the basic rules of Design and Layout including:
    • Gestalt Principles
    • Preattentive Attributes
    • Decluttering your charts, dashboards and reports
    • Size and positioning
    • Basic colour rules and introduction to colour wheel calculations
  • Power BI Themes and Templates
    • Creation of .json template files
    • Use of .pbit files