"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com

Microsoft Power BI Advanced DURATION 2 Days

Course Overview

This advanced 2-day course is intended for anyone who has existing experience working with Power BI and who wants to extend and enhance their knowledge beyond the basics. You will gain deeper insights into the inner workings of Power BI by implementing your own code in Power Query using the M language, further enhance the data model using the DAX expression language and get a better understanding of your data using advanced capabilities and features in Power BI. In addition to understanding the technical workings of Power BI, it is also intended to demonstrate best practices and highlight practical solutions to common data analytic scenarios. Also, as Power BI Desktop and the Power BI Service are continually evolving, this course is regularly reviewed and updated to keep the delivered content as fresh and relevant as possible, thus ensuring maximum productivity from the learning experience.




With the course structure being fully modularised, customised versions of this course can be devised and delivered to suit individual requirements – just ask for details.

Full course breakdown available – training@jcstraining.com


Delegates should have previously attended the 2-day “Power BI Introduction” course or possess equivalent knowledge and experience of Power BI.


Upon successful completion of this course, students will be able to:

  • Load Data from a Database
  • Process Multiple Files in a Folder
  • Understand Supported Storage Modes
  • Match Imported Data to Master Data
  • Prepare Data for Modelling
  • Understand M Language Data Types
  • Enhance Transforms with M
  • Implement and Optimise a Data Model
  • Resolve Common Modelling Problems
  • Review the DAX Expression Language
  • Address Common Scenarios with DAX
  • Implement Custom Data Grouping
  • Use Built-In Analytics Features
  • Implement Advanced Filters
  • Implement Drillthrough Reports
  • Work with the Q&A Feature
  • Implement Custom Visuals and Slicers
  • Share Content in the Power BI Service
  • Secure Data
  • Secure Objects
  • Refresh Data
  • Manage Changing Data


Part 1: Power Query Advanced Techniques

1. Loading Data

Load Data from Relational Databases

Process Multiple Files

Storage Modes

Load Data from the Internet

Connect to a Published Dataset

2. Transforming Data

Profile Data

Improve Performance with Query Folding

Fuzzy Lookups

Split a Table into Multiple Tables

Structure and Manage Queries

View Query Dependencies

Getting Acquainted with the M Language

Tweak Existing M Language Formulae

Create User Defined Functions with M

Invoke Custom Functions

Create Date and Time Tables with M

Best Practices

Part 2: Advanced Data Modelling and DAX

3. Data Modelling

Data Modelling Revisited

Fact and Dimension Tables

Many-to-Many Relationships

Resolving Some Common Data Modelling Issues

4. Enhancing the Data Model with DAX

Getting up to Speed with DAX

Calculated Columns and Measures

Manipulating the Filter Context

Creating Calculated Tables

Use Variables

Create a Date Table with DAX

Time Intelligence Revisited

Useful DAX Querying Techniques

Organise Content with Display Folders

Part 3: Enhance Reports and Visuals

5. Enhanced Data Visualisation

Report Themes

Use the Small Multiples Chart Option


Implement Reports as Tooltips

Continuous v Categorical Axis

Custom Grouping

Use the Analytics Pane

Forecasting & Anomaly Detection

Visual, Page, and Report Level Filters

Synchronise Slicers across Pages

Analyse Data with Decomposition Trees

Analyse Data with Key Influencers

Drillthrough Reports

What-If Parameters

Field Parameters

Implement and Manage Q&A

Custom Visuals and Slicers

Mobile Report Layout

Part 4: Manage Content in the Power BI Service

6. The Power BI Web Service

Set up Data Alerts

Share Content and Workspaces

Create and Distribute Apps

Promote & Certify Content

Secure Data with Row Level Security (RLS)

Object Level Security

Refresh Datasets

Understand Data Gateways

Incremental Refresh

Quick Insights

Analyse in Excel

Export Reports