Power BI Training Course

Audience: This Power BI training course is intended for people who want to use all the capabilities of the Power BI platform to build self-serviced business intelligence solutions.

Duration: 3 Day

Max number of delegates – 10

Course Description: This is a three-day course covering the functionality of Power BI. Power BI is a suite of business analytics tools to analyse data and share insights. Power BI Desktop transforms your company’s data into rich visuals for you to monitor your business and get answers quickly with rich dashboards available on every device.

Courseware: Courseware will be provided electronically

Course Outline:

Module 1: Power BI Desktop Introduction

1.1 – Get Power BI Desktop
1.2 – Overview and Terminology
1.3 – Imports
1.4 – Visualizations
1.5 – Filters and Queries
1.6 – Reports

Module 2: Data Sources

2.1 – Compatible Data Sources
2.2 – Get Data and Query Editor
2.3 – Direct Query vs Import Data
2.4 – Defining Hierarchies based on a single Table
2.5 – Set up and Manage Relationships between Tables
2.6 – Use Append Queries
2.7 – Merge Data Tables

Module 3: Visualizations

3.1 – Creating Visualisations
3.2 – Colour Formatting
3.3 – Setting Sort Order
3.4 – Scatter and Bubble Charts
3.5 – Slicers, Timeline Slicers & Sync Slicers
3.6 – Cross Filtering and Highlighting
3.7 – Visual, Page and Report Level Filters
3.8 – Drill Up, Down and Through
3.9 – Hierarchies
3.10 – Reference / Constant Lines
3.11 – Tables, Matrices & Conditional Formatting
3.12 – KPI’s, Cards and Gauges
3.13 – Map Visualizations
3.14 – Custom Visuals
3.15 – Custom Report Themes
3.16 – Grouping and Binning
3.17 – Selection Pane and Bookmarks

Module 4: Querying Data

4.1 – Query Editor
4.2 – Filters and Delimiters
4.3 – Transforms
4.4 – Pivot and Group By
4.5 – Creating Custom Calculated Columns
4.6 – Adding Conditional Columns
4.7 – Introduction to Data Analysis Expression (DAX)
4.8 – Histograms

Module 5: Reports and Exports

5.1 – Personal vs App Workspaces
5.2 – Power BI Service
5.3 – Report Elements and Options
5.4 – Working with Pages
5.5 – Adding Graphics
5.6 – Report Level Filters
5.7 – Report Themes
5.8 – Export Power BI Data to CSV
5.9 – Create a Power BI Template

Module 6: Sharing Content

6.1 – Sharing Dashboards with internal and External users
6.2 – Sharing content with Office 365 groups
6.3 – Creating Power BI Apps
6.4 – Consuming Power BI Apps
6.5 – Using Publish to Web with Dashboards

Module 7: Power BI App

7.1 – Supported Platforms
7.2 – Creating Dashboards for Mobile devices
7.3 – Accessing Reports and Dashboards from Mobile

Module 8: Data Analysis Expression (DAX)

8.1 – DAX Overview
8.2 – DAX data types and operators
8.3 – Common DAX functions
8.4 – Referencing other tables in DAX
8.5 – Using CALCULATE
8.6 – EARLIER and EARLIEST

Module 9: Gateway

9.1 – Power BI Personal Gateway
9.2 – Working with OneDrive
9.3 – Working with SharePoint Lists

Power BI Training

We are happy to discuss a tailored Power BI training course if the above does not meet your exact requirements.  Our aim is to ensure all of our clients get the best experience from our training and our trainers.  Contact us now to discuss course dates training@blackbirdcorporate.co.uk or call our office on 0800 107 6362.
All courses are delivered onsite on client premises, unfortunately we do not offer public courses.