Microsoft Office training -  Advanced Power BI

Power BI Training

Advanced Power BI Training Course

£795 + VAT for most venues (£950 + VAT for London)

2 days

If you've mastered the basics of creating Power BI reports, you may like to find out what else it can do - but you should only consider attending this course if you use Power BI regularly.  Learn how to create report themes and templates, find out how to use quick measures and bookmarks, delve further into Query Editor and maps, and much more!

Course details

  • Locations for Advanced Power BI coursesLocations:Manchester, London
  • Next Advanced Power BI course locationNext course:Thu 21 November 2019
  • Advanced Power BI course timesTime:09.30-16.30

Course Contents

The content of this course are as follows:

Advanced data models

  • Training topicConnecting to folders
  • Training topicChanging the source using M

Advanced Query Editor

  • Training topicUnpvioting data
  • Training topicMerge transforms
  • Training topicAppend transforms


  • Training topicFiltering and drop-downs
  • Training topicSQL stored procedures
  • Training topicDynamic connection strings

Custom visuals

  • Training topicThe play axis slicer
  • Training topicThe Chiclet slicer
  • Training topicSynoptic panels


  • Training topicTooltip backgrounds
  • Training topicStatic report tooltips
  • Training topicDynamic report tooltips

Conditional formatting

  • Training topicBased on numerical values
  • Training topicBased on a colour name

Dynamic display

  • Training topicDynamic images in tables
  • Training topicDynamic button hyperlinks
  • Training topicDynamic titles

Quick measures

  • Training topicRunning totals
  • Training topicAbsolute and relative totals
  • Training topicFiltering columns


  • Training topicCreating bookmarks
  • Training topicData and display properties
  • Training topicSpotlighting and hiding visuals

Bookmark case studies

  • Training topicDynamic chart axes
  • Training topicDynamic page titles
  • Training topicInformation pop-ups

Report themes

  • Training topicGetting report themes
  • Training topicCreating basic report themes
  • Training topicVisual themes

Power BI Templates

  • Training topicCreating templates
  • Training topicIncluding themes
  • Training topicUsing parameters

Covered if time allows If time

More on Power BI Service

  • Training topicRow security
  • Training topicQ&A
  • Training topicAnalysing in Excel

Covered if time allows If time

BI mobile

  • Training topicUsing the app
  • Training topicCreating BI apps
  • Training topicLimitations

To attend this course you must be familiar with creating Power BI reports, and use Power BI on a weekly basis.

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Excellent delivery of training and interactive exercises. Well delivered course. In-depth manual and exercises to go through in own time."

Ian Lynch (Manchester Metropolitan University)

"Fantastic courses with an engaging trainer. Content and pace was perfect."

Andrew Witt (Coloplast Ltd)

"Trainer was friendly, knowledgeable and helpful. Liked the way we were asked questions (as a group) to get us thinking."

Alex Wallace (Manchester Metropolitan University)

"(Intro Power BI) Excellent pace for 2 days. Plenty of interaction and humour. Great lunch breaks. (DAX) Excellent course. Very well delivered on a "tricky" topic which could have sent me slightly mad. Great pace of delivery. This is the first time I felt I could do the same course again! (Advanced Power BI) Excellent delivery of a new course. Quick measures were very useful after the DAX course (a good compliment.)"

John Pelan (Coloplast Ltd)

"(Intro Power BI) The trainer's pace was perfect for course. He understood the level at which candidates were at and paced the course accordingly. (Adv Power BI) Excellent course! A lot to take in but the supporting info is superb."

Leo Skelly (Prima Group)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled Advanced Power BI training dates

Here are the Advanced Power BI courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Thu/Fri 21-22 November 2019 2 £950 Book places
Mon/Tue 09-10 December 2019 2 £795 Book places
Mon/Tue 06-07 January 2020 2 £795 Book places
Thu/Fri 16-17 January 2020 2 £950 Book places
Tue/Wed 11-12 February 2020 2 £795 Book places
Tue/Wed 03-04 March 2020 2 £950 Book places
Tue/Wed 24-25 March 2020 2 £795 Book places
Thu/Fri 16-17 April 2020 2 £950 Book places
Tue/Wed 05-06 May 2020 2 £795 Book places
Tue/Wed 02-03 June 2020 2 £950 Book places
Tue/Wed 09-10 June 2020 2 £795 Book places
Tue/Wed 21-22 July 2020 2 £950 Book places
Tue/Wed 04-05 August 2020 2 £795 Book places
Thu/Fri 10-11 September 2020 2 £795 Book places
Thu/Fri 17-18 September 2020 2 £950 Book places
Tue/Wed 20-21 October 2020 2 £795 Book places
Tue/Wed 24-25 November 2020 2 £795 Book places
Tue/Wed 01-02 December 2020 2 £795 Book places
Date(s) Venue

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite Power BI training at your offices (we'll even provide and set up the computers).

Related Courses

Introduction to Power BI


2 day course

PowerPivot / Excel Power BI


2 day course



2 day course

Other Power BI Tools training resources

Power BI exercises

Power BI exercises

View Power BI Desktop exercises

Power BI videos

Power BI videos

View Power BI videos

Power BI skills assessment

Power BI skills assessment

View Power BI skills skills assessment tests

Power BI blogs

Power BI blogs

View Power BI blogs

This page has 0 threads Add post