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