Power BI Advanced Training Course


SKU: PWB-INGT-030 Category:


This Power BI Advanced training course is aimed at experienced Power BI users. The course delves into the M language behind the Query Editor; as well as the use of advanced DAX formulas. Delegates will also learn how to improve the user experience through the use parameter tables; how to customise the data model by including calculated tables; and how to work with advanced visuals and dashboard tiles.

Power BI Advanced Training Course Outline

The Power Query Formula Language

Using The Formula Bar; Using The Advanced Editor; Overview Of The M Language; Exploring M using #shared

Understanding Automatically Generated Code

Excel.Workbook; File.Contents; Table.TransformColumns; Table.TransformColumnTypes; Table.UnpivotColumns; Table.UnpivotOtherColumns

Creating custom functions in M

Defining a function; Defining input parameters; The goes-to operator; Defining the function body; Using optional parameters; Calling functions

Iteration Techniques

Benefit of generating lists; Generating lists of numbers; Generating lists of dates; Generating alphanumeric lists; Using the each function; Applying a function to a list of files

Advanced DAX

Using DAX Studio; Writing complex formulas; Using variables; Calculating moving averages; Calculating running totals; Percentile calculations; Creating advanced time intelligence formulas; Using multiple date tables; Working with non-standard calendars

Working with calculated tables

Creating calculated tables; DAX functions that return tables; The CALCULATETABLE function; The ADDCOLUMNS function; The SUMMARIZE function; SUMMARIZE with ROLLUP; VALUES and DISTINCT functions; The CROSSJOIN function; The TOPN function; The ROW function; Using calculated tables within the data model

Using parameter tables

What is a parameter table; When to use parameter tables; Using the HASONEVALUE function; Using the VALUES function; Creating custom slicers; Creating multiple parameter table solutions

Using ArcGIS Maps for Power BI

Overview of ArgGIS maps integration; Selecting a base map; Creating heat maps; Adding demographic layers; Searching for layers on ArgGIS online

Using R Visualizations and Datasets

Overview of R integration; Configuring R Script Options; Using the R Script editor; Creating correlation plots; Creating predictive plots; Interacting with Power BI visuals

Advanced dashboard tiles

Adding custom links to a dashboard; Using th web content widget; Using the video widget; Real-time streaming dashboard tiles

Check out our other Microsoft Power BI Training Courses here

Training Location for Scheduled Courses

Our scheduled training courses take place at the following address:
Tower Bridge Business Centre
46-48 East Smithfield
London E1W 1AW
Tel: 0800 998 9248

On-site Training

When booking on-site training, use the pricing zone map below to determine the daily rate based on the location of your organization: zone A, £795, per day; zone B, £895, per day; zone C, £995, per day.

Price Zones

Additional information

Choose a Date

25-26 Jul 2019 – London, 22-23 Aug 2019 – London, 26-27 Sep 2019 – London, 24-25 Oct 2019 – London, 14-15 Nov 2019 – London, 12-13 Dec 2019 – London, 16-17 Jan 2020 – London, 13-14 Feb 2020 – London, 19-20 Mar 2020 – London, 14-15 May 2020 – London, On-site training – Zone A, On-site training – Zone B, On-site training – Zone C