Power BI Desktop Advanced

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.

Power BI Desktop is required to be installed prior to the course

Duration: 3 Day

Timings: 09:30 – 16:30

Max number of delegates – 8

For more information Tel: Call us on 0800 107 6362 / / 01782 390130 to discuss the course further.

Delivery Method: Onsite or virtual via MS Teams

Target student:

This course is intended for people who want to use all the capabilities of the Power BI platform to build self-serviced business intelligence solutions. This course should not be delivered to novice Power BI Users.

Students will learn:

Power BI Desktop Features
Power BI Concepts and Terms
Manage Data Visualizations
Manage DAX formulas
Publish and Share Power BI Reports

Course Guide:

Module 1: Power BI Desktop Introduction

Download Power BI Desktop
Overview and Terminology
Imports
Visualizations
Filters and Queries
Reports

Module 2: Data Sources

Compatible Data Sources
Get Data
Direct Query vs Import Data
Defining Hierarchies based on a single Table
Create and Manage Relationships between Tables
Use Append Queries
Merge Data Tables

Module 3: Visualizations

Creating Visualisations
Colour Formatting
Setting Sort Order
Scatter and Bubble Charts
Slicers, Timeline Slicers & Sync Slicers
Cross Filtering and Highlighting
Visual, Page and Report Level Filters
Drill Up, Down and Through
Hierarchies
Reference / Constant Lines
Tables, Matrices & Conditional Formatting
KPI’s, Cards and Gauges
Map Visualizations
Custom Visuals
Custom Report Themes
Grouping and Binning
Selection Pane and Bookmarks

Module 4: Querying Data

Query Editor
Filters and Delimiters
Transforms
Pivot and Group By
Creating Custom Calculated Columns
Creating Tables
Adding Conditional Columns

Module 5: Data Analysis Expression (DAX)

DAX Overview
DAX data types and operators
Common DAX functions
Referencing other tables in DAX
Using CALCULATE and RANKX
Using RELATED, RELATEDTABLE, LOOKUPVALUE

Lesson 6: Reports and Exports

Report Elements and Options
Working with Pages
Adding Graphics
Report Level Filters
Report Themes
Export Power BI Data to CSV
Create a Power BI Template

Module 7: Sharing Content

Power BI Service
Sharing Dashboards with internal and External users
Sharing content with Office 365 groups
Using Publish to Web with Dashboards

Module 8: Power BI Workspaces

Understanding Workspaces
Creating Workspaces
Personal vs
Workspace Permissions and Roles

Module 9: Power BI App

Supported Platforms
Creating Dashboards for Mobile devices
Accessing Reports and Dashboards from Mobile

Module 10: Gateways

Power BI Personal Gateway
Working with OneDrive
Working with SharePoint Lists

**All of our courses are designed so we can modify and tailor them to your business needs. The outline for this course is for guidance only. The course may not run exactly as laid out in the outline as it will be adapted to meet your requirements.

What our clients say

Scott was very approachable, always willing to answer questions and assist where needed

Onsite, Scotland

Scott is clearly an expert with Power BI and associated areas, and was also able to integrate our specific requirements into the training material very well. I appreciated his desire to ensure we were getting what we needed from the 3 days. I came away from the course confident that we could make great improvements to how we deliver Power BI to our customers and excited about how we can benefit from the Power platform internally.

Onsite, Scotland

We are happy to discuss a tailored 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.

We offer both virtual training and onsite training so we can meet your training needs.