Power BI Advanced Training

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 – Next Online Training Dates

15-16 Oct 20
12-13 Nov 20
10-11 Dec 20

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 the web content widget, Using the video widget, Real-time streaming dashboard tiles

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.

On-site Training

N.B. For the moment, we have replaced on-site training with private online courses.

The fee for running in-house Power BI courses in Colchester is £795, per day.
The cost for running customized Power BI courses in Luton is £795, per day.
Our fee for delivering customized Power BI training in Tyneside is £895, per day.
The charge for running customized Power BI training in Liverpool is £895, per day.
Our price for delivering on-site Power BI courses in Medway Towns is £895, per day.
The fee for running customized Power BI training in Doncaster is £895, per day.
The fee for running customized Power BI training in Exeter is £895, per day.
Our charge for delivering on-site Power BI courses in Farnborough/Aldershot is £895, per day.
The charge for running customized Power BI training in Greater Manchester is £895, per day.
Our charge for delivering Microsoft Power BI courses in Chesterfield is £895, per day.
Our price for supplying on-site Power BI courses in Reading is £795, per day.
Our price for delivering on-site Power BI courses in Blackpool is £895, per day.
Our fee for delivering in-house Power BI courses in High Wycombe is £895, per day.
The charge for running Microsoft Power BI courses in Chelmsford is £895, per day.
The fee for running on-site Power BI training in Edinburgh is £995, per day.
Our price for delivering in-house Power BI courses in Oxford is £895, per day.
Our price for running on-site Power BI training in The West Midlands is £795, per day.
The fee for running on-site Power BI training in Telford is £795, per day.
The cost of supplying on-site Power BI courses in Accrington/Rossendale is £895, per day.
Our charge for supplying Microsoft Power BI courses in Sunderland is £895, per day.
Our price for supplying in-house Power BI courses in Derby is £795, per day.
Our price for delivering customized Power BI courses in Basingstoke is £895, per day.
Our price for delivering customized Power BI courses in Eastbourne is £895, per day.
Our fee for delivering on-site Power BI training in Northampton is £895, per day.
The fee for running customized Power BI training in Ireland is £995, per day.
The charge for running in-house Power BI courses in Preston is £895, per day.
Our price for running Microsoft Power BI courses in Sheffield is £895, per day.
Our price for running customized Power BI training in Plymouth is £895, per day.
Our price for supplying in-house Power BI courses in Slough is £895, per day.
Our charge for supplying on-site Power BI training in Newport is £895, per day.
The fee for running customized Power BI courses in Torquay is £895, per day.
Our price for delivering customized Power BI courses in Burnley is £895, per day.
Our fee for delivering customized Power BI courses in Ipswich is £895, per day.
The fee for running on-site Power BI training in West Yorkshire is £795, per day.
Our price for supplying Microsoft Power BI courses in Dundee is £995, per day.
Our fee for delivering customized Power BI courses in Cardiff is £895, per day.
Our fee for delivering Microsoft Power BI courses in Bristol is £895, per day.
The fee for running customized Power BI training in Norwich is £795, per day.
Our charge for supplying on-site Power BI courses in Birkenhead is £895, per day.
Our charge for delivering customized Power BI courses in Coventry is £795, per day.
Our fee for delivering on-site Power BI courses in Warrington is £895, per day.
Our price for delivering in-house Power BI courses in Mansfield is £895, per day.
The fee for running on-site Power BI courses in Greater Glasgow is £995, per day.
The charge for running customized Power BI courses in Lincoln is £795, per day.
Our charge for delivering customized Power BI training in Wigan is £895, per day.
The cost for running in-house Power BI courses in Poole is £895, per day.
The fee for running on-site Power BI courses in Worcester is £895, per day.
The charge for running customized Power BI courses in Stoke-on-Trent is £795, per day.
Our charge for supplying on-site Power BI courses in Maidstone is £895, per day.
Our price for running customized Power BI training in Nottingham is £795, per day.
Our price for supplying Microsoft Power BI courses in Basildon is £895, per day.
The cost for running customized Power BI courses in Hastings is £895, per day.
Our charge for delivering customized Power BI courses in Swindon is £895, per day.
Our price for delivering customized Power BI training in Brighton and Hove is £895, per day.
The cost of supplying Microsoft Power BI courses in Cheltenham is £895, per day.
Our price for running on-site Power BI courses in Teesside is £895, per day.
Our price for supplying customized Power BI training in Cambridge is £795, per day.
The charge for running customized Power BI courses in Thanet is £895, per day.
The charge for running customized Power BI courses in Birmingham is £795, per day.
The cost of supplying on-site Power BI courses in Grimsby is £895, per day.
The cost of supplying on-site Power BI courses in Burton-upon-Trent is £895, per day.
Our price for supplying on-site Power BI courses in Greater London is £895, per day.
The cost of supplying customized Power BI courses in Crawley is £895, per day.
The fee for running in-house Power BI courses in York is £895, per day.
Our charge for supplying customized Power BI training in Leicester is £795, per day.
Our fee for delivering customized Power BI training in Southend-on-Sea is £895, per day.
The cost of supplying in-house Power BI courses in South Hampshire is £895, per day.
The cost for running customized Power BI training in Bedford is £895, per day.
Our fee for delivering Microsoft Power BI courses in Barnsley is £895, per day.
Our price for delivering in-house Power BI courses in Blackburn is £895, per day.
Our price for running Microsoft Power BI courses in Gloucester is £895, per day.
Our charge for supplying customized Power BI training in Bournemouth is £895, per day.
Our price for supplying customized Power BI training in Aberdeen is £995, per day.
The fee for running on-site Power BI courses in Peterborough is £795, per day.
Our price for running customized Power BI courses in Milton Keynes is £795, per day.
The cost for running customized Power BI courses in Kingston upon Hull is £895, per day.
Our price for running Microsoft Power BI courses in Swansea is £895, per day.
Our charge for supplying on-site Power BI training in Belfast is £995, per day.