Microsoft Excel BI Dashboards

21/01/2017

Microsoft Excel BI Dashboard Design – Training Course Overview

Microsoft Excel BI Dashboards – Advanced Level Excel

Duration: One Day

When designed well, BI (Business Intelligence) Dashboards help engage the power of visual perception to communicate a dense collection of information efficiently, with exceptional clarity. Learn how this can be achieved by applying visual design skills that address the unique challenges of dashboards on this specialised one day training course.

This course aims to enable delegates to:

  • Match your message to the right type of display
  • Design tables and graphs to communicate information simply, clearly, and accurately
  • Recognise common Issues in dashboard design
  • Avoid clutter and arrange data in a way that communicates clearly and at a glance
  • Recognize the visual characteristics of data that are meaningful
  • Understand each of the prominent quantitative relationships (time, distribution, correlation, etc.)
  • Use the best graphs, visual analysis techniques, and practices for analysing each type of quantitative relationship
  • Navigate through data analytically and efficiently
  • Apply the findings of information visualization research to the analysis of business data

Outline

  • Challenges of quantitative data presentation
  • Introduction to table and graph design
    • Fundamental challenges of data presentation
    • Key characteristics of quantitative information
    • Differing characteristics and uses of tables and graphs
    • Common quantitative relationships featured in graphs
    • Visual perception and how it applies to data presentation
    • Steps in the visual design process
  • Table design
    • Structure, layout & formatting
  • Graph design
    • Visual objects used to encode values in graphs
    • Matching the right visual encoding objects to the fundamental quantitative relationships in graphs
    • Graph design at the component level
  • The definition and potential benefits of dashboards
  • Current trends in dashboard design
  • Common mistakes in dashboard design
  • The characteristics of well-designed dashboards
  • Steps in the dashboard design process
  • Common dashboard information and techniques for enhancing meaning
  • Selecting appropriate media for displaying the data
  • A library of dashboard display mechanisms
  • The best practices of dashboard design
  • An introduction to visual data analysis
  • Visual characteristics to look for in the data
  • Quantitative business analysis techniques by type
    • Analysing time series
    • Analysing rankings
    • Analysing deviations
    • Analysing distributions
    • Analysing correlations
    • Analysing geo-spatial data

Target Audience: Students who have advanced skills with Microsoft Excel who want to learn more professional Excel BI Dashboard design skills.

Scheduled courses are held regularly in Glasgow & Edinburgh, on-site courses by arrangement across Scotland.