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. 

DAVHILL also contributes courses and workshops to the Data Action Lab training catalogue, so for a more comprehensive list of courses in data appreciation, data engineering and tools, data analysis, and data science please visit their workshop catalogue page.

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

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

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

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. 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


Introduction to Data Analysis (1 day)

sysabee-notag small.png
 

This course was developed and is delivered in collaboration with Sysabee.

Who should attend:

Anybody who works with data and would like to increase their understanding of the types of analysis they can carry out on different data types. No technical background is required

Description:

When we do data analysis we often miss key elements and approaches that could make the outputs richer and more valuable for consumers and end users. This course will introduce participants to basic data analysis concepts using hands on demonstrations with familiar tools (e.g. Excel, Power BI). Possible uses and appropriate application of these techniques will also be discussed. The course will conclude by showcasing some more advanced data analysis concepts to lay a foundation for future development. This course will help you to:

Set a baseline:

  • Understand what underpins data analysis

  • Understand what data analysis is

  • How to take the first steps in modeling your data

  • See what types of analytical models exist and what apply to your organization

Get ready to start your analysis:

  • How to set up the data analysis pipeline

  • Understand and communicate the importance of data validation

  • Understand the best practices for dealing with missing values

Do the analysis:

  • How to deal with both quantitative and qualitative analysis

  • The importance of defining and developing measures and metrics

  • Understand and apply basic techniques for analysing categorical data

  • Understand and apply basic techniques for analysing numeric data

  • How to draw appropriate conclusions from your analysis

See the possibilities: a showcase of advanced analysis techniques

  • Time series analysis for forecasting

  • Decision tree classifiers

  • Anomaly detection

  • Unsupervised learning techniques


Introduction to Power BI (1 day)

Who should attend:

For those people who want to learn about the basic functionality in Power BI and want to create their first interactive charts, reports and dashboards.

Description:

This course is aimed at taking participants through the initial stages of inputting data and creating their first interactive charts, reports and visualizations. It is a foundation course for "Beyond the Basics - Getting the most out of Power BI". This course will help you to:

  • Understand the importance of clean data

  • How to import data from single and multiple data sources

  • Manipulating the data as it is imported into Power BI

  • Creating our first calculations

  • Creating our first custom columns

  • Creating our first charts

  • Basic interactive filtering

  • Creating basic hierarchies of data

  • How to layout a report and dashboard

  • How to publish reports and dashboards to end users

To get the most out of this course we highly recommend participants take our "Best Practice in Creating Data Visualizations and Dashboards course)


Beyond the Basics - Getting the most out of Power BI (1 day)

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.