DAVHILL Group provides custom in-house training sessions and we also provide various online Business Intelligence training and courses through our Learning and Development networks. 

If you wish to pay for a public training course by credit card then please click here.

Successful participation of all courses includes a certificate of completion for your employee professional development training records.

To request a seat on one of our public training courses or to book an in-house session please use our contact form, specifying the course title and the date that you would wish to attend.

Course costs:

Training Type Cost
Public Course $550 Per Person + HST
In-House Course $4,600 Per Day + HST
Additional 10% discount for courses booked before 31st March 2018

Our current courses include:


Best Practice in Creating Data Visualizations and Dashboards

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

Description:
This course is aimed at taking participants through the basics of data visualization and design. Weather you are creating Power BI interactive reports, generating charts in Excel or management presentations in PowerPoint. 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 

Beyond the Basics - Getting the most out of Power BI

Who should attend:

For those people who have used Power BI and are moving beyond the creation of their first charts. Also for people who are thinking about switching to Power BI from other BI tools and want to find some “beyond the basics” details.

Description:

This course is aimed at taking participants past their first chart creation in Power BI and to shortcut the user to some relatively sophisticated visualizations that are not technically difficult to create. The course will help you to:

  • Get a head start on Data Modeling: 
    • Where to use M and where to use DAX
    • Best practice in setting up data relationships
    • Columns vs Measures
    • Overview of Quick Measures
  • Get  up to speed in DAX - effective and easy top tips
    • Introduction to DAX for the newbie
    • Similarities and differences to Excel
    • Getting started, easy to use but useful DAX functions
  • Show to how to overcome common data analysis issues
    • Tricks and tricks with date and time fields
    • Basics of filtering
    • Sorting and bucketing
    • Drill through filtering
  • Get on the Power User track with some useful beginner Power BI “hacks”
    • How to dynamically highlight values and over / under limit data points (particularly in line charts)
    • Effective use of colour to highlight values in tables and matrices
    • Setting targets using guages and kpi visualizations
    • Dynamic text - using dynamic cards to tell a story
    • Digging into weeds with the most commonly used charts
    • Getting the most out of maps - simple rules for geo data
  • Introduction to non-standard charts (Microsoft Store add-in charts)
    • Using custom shapes in dynamic charts (using synoptic panel & MS Visio)
    • Overview of a selection of interesting add-in charts, including but not limited to Dot Plot, Bubble Chart, text filter, infographic designer, sparkline, box and whisker, ultimate waterfall (and a few others)

Other custom courses are available on request and we always tailor course content to meet your organizations needs. For more information please contact us using our contact form.