D.O.T.S. Power BI Advanced

Description

This is the Dual Online Training Solution (D.O.T.S.) version of our Power BI Advanced training Course. This 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.
Our Dual Online Training Solution provides your staff with two modes of training: live instructor-led training is followed with three year’s access to the self-paced version of the same course. The material covered in the live training will be very similar to that covered in the self-paced video training. So, the self-paced training provides a very effective form of post-training reinforcement.

Power BI Advanced Training Course Outline

Data Centralization

Creating Dataflows, Gateway configuration, refreshing dataflows, Building reports from dataflows, Centralising datasets, Certifying datasets, Building reports from datasets

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

Advanced Data Modelling and Visualization

Working with multiple fact tables, Using active and inactive relationships, Using the USERELATIONSHIP function, Creating dynamic visual properties, Using BLANK() to make visibility dynamic

Advanced dashboard tiles

Adding custom links to a dashboard; Using the web content widget; Using the video widget; Real-time streaming dashboard tiles, Power Automation and PowerApps integration

Check out our other Microsoft Power BI Training Courses here

Scheduled Instructor-Led Online Courses

We run this scheduled Power BI training course regularly as a public, instructor-led online course. Our online classes are small, with a maximum of eight delegates and each person is given remote access to a computer in our training centre and provided with lots of opportunities to practice all of the techniques being taught.

Training Location for Scheduled Courses

All of our scheduled public courses are now run online. When we resume the running of our in-person scheduled training courses, they will take place at the following address:
Tower Bridge Business Centre
46-48 East Smithfield
London E1W 1AW
Tel: 0800 998 9248

Private Instructor-Led Online Training

If you have several staff members that need to complete this training, we can arrange a private instructor-led online training course tailored to the requirements of your organisation. Each person is given remote access to a computer in our training centre and provided with lots of opportunities to practice all of the techniques being taught remotely. This means that your staff can attend a course either in the office or from home.