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.

For more information complete our Contact Form to discuss the course further.

Target student: Power BI Desktop Advanced 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

Power BI Desktop Introduction

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

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

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

Querying Data

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

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

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

Sharing Content

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

Power BI Workspaces

Understanding Workspaces
Creating Workspaces
Personal vs
Workspace Permissions and Roles

Power BI App

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

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.