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:London, Manchester
  • Next Advanced Power BI course locationNext course:Tue 15 January 2019
  • Advanced Power BI course timesTime:09.30-16.30

Course Contents


  • Training topicCreating parameters
  • Training topicIncluding in data models
  • Training topicReferencing in measures

Advanced data models

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

Advanced Query Editor

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

Custom visuals

  • Training topicThe play axis slicer
  • Training topicThe Chiclet slicer

Quick measures

  • Training topicCreating quick measures
  • Training topicQuick date measures

More on maps

  • Training topicWorking with shape files
  • Training topicThe MapBox visual
  • Training topicCreating synoptic panels

Action buttons

  • Training topicAssigning actions to shapes
  • Training topicInserting buttons
  • Training topicHover and select effects


  • Training topicCreating bookmarks
  • Training topicFiltering using bookmarks
  • Training topicSpotlighting and hiding visuals

Advanced bookmarks

  • Training topicPage and help buttons
  • Training topicDynamic page titles
  • Training topicInformation pop-ups

Report themes

  • Training topicUsing JSON to create themes
  • Training topicChanging the default font
  • Training topicCreating simple themes
  • Training topicSetting specific property defaults

Power BI Templates

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

Covered if time allows If time

BI mobile

  • Training topicUsing the app
  • Training topicCreating BI apps

Covered if time allows If time

More on Power BI Service

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

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Perfect, real-world applicable, friendly, well paced ... perfect. Course was recommended."

Marc Vautheny (Business Growth Hub)

"The trainer was brilliant, a genuinely nice guy with a wealth of knowledge. Looking forward to my Advanced VBA course in the near future. The course is laid back, lets you wear your own 'out of office' clothing and the complementary lunches were lovely."

Tashan Jackson (Partners for Improvement Islington)

"Great course, relevant. Trainer was really clear and helpful."

Nidhi Bhola (Clorox)

"Lovely venue with everything provided. Trainer took us through some stuff which wasn't on the list. Gave possible solutions about some problems we have with data. Very good price and came recommended."

Harminder Sandhu (NHS Herts Valleys CCG)

"Excellent reference material manuals. Informative website and competitive prices."

Sarah Cradick (Signature)

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

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

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
Tue/Wed 15-16 January 2019 2 £950 Book places
Mon/Tue 21-22 January 2019 2 £795 Book places
Tue/Wed 05-06 March 2019 2 £795 Book places
Thu/Fri 21-22 March 2019 2 £950 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 or PowerPivot exercises

Power BI videos

Power BI videos

View PowerPivot 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 - Excel or Power BI blogs

This page has 0 threads Add post