Microsoft Power BI

Microsoft Power BI


Business Analysts, Financial Analysts, Data Scientists and Staff who need to use Power BI for producing reports from Excel, SQL Server and other databases.


There are no prerequisites for this course.


2 days. Hands on.

Course Objectives

Verhoef's Microsoft Power BI training course shows attendees how to use the latest collection of on-premise and online tools to enable them to find, clean, model, and visualize data, share discoveries, and collaborate in intuitive new ways.

Power BI is the latest set of Microsoft BI tools for data mash up, data modelling, and data visualisation. The results can be deployed on-premise or in the cloud and can be visualised in browsers, on tablets, and on mobile phones.

This course will take you through the product, demonstrating functionality, with plenty of hands on so that you can learn to use this powerful tool to help you transform your rows of data into a compelling interactive visual story.

Course Content

Power BI Service
Self-service BI
Organisational BI
Content Items
Connecting to Data
Visualizing Data

Reading View
Editing View
Visualisations and Custom Visualisations

Power BI Mobile
Native Applications (iOS/Android/Windows)
Viewing Content
Sharing & Collaboration
Configuring Alerts

Power BI Desktop
Data Models
Design Environment
Importing Data

Transforming Data
Queries & the Query Editor
Data Previews
Shaping & Cleansing Data
Basic Transformations
Loading Transformed Data
Combining Datasets
Date Tables

Refining the Model
Tables & Columns
Data View
Exploring Data
Managing Schema & Data Changes
Connections & Tables
Data Refresh
Relating Tables
Rules & Limitations
Relationship View

Data Analysis Expressions
Calculated Columns
DAX Syntax
DAX Functions
Advanced Relationships

Virtual Courses

ALL of our courses can be delivered virtually. And our Bath public schedule of courses are now available as live virtual sessions, using the popular Zoom Virtual Classroom and remote labs. Delegates can test their access at:

Public Courses

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...