Site Loader

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

  • February 7, 2019
    9:00 am - 4:00 pm

Description:
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

Post Author: Stephen Davies

Stephen is the CEO of DAVHILL Group, a Business Intelligence and Data Analytics company based in Ottawa, Ontario.

He has more than 25 years of experience working in both public and private sectors. Early in his career in operations management he started to do data analysis and never quite escaped.

With an academic background in Physics and Engineering he has worked in semiconductor and OEM manufacturing as an engineer and supply chain director. As a Business Intelligence and Process Transformation consultant he seems to spend most of his time either playing with aircraft in the aviation industry or with the Federal Canadian Government.

As the CEO of the DAVHILL Group, Stephen's main focus is to make data real and useable for everybody. DAVHILL specializes in Business Intelligence, Artificial Intelligence and Machine Learning systems implementation and is delighted to provide training courses to the Data Action Lab.