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 more about maps, brush up on your DAX skills, find out about parameters, data clusters and binning, explore some of the more advanced chart types and learn more about Query Editor transforms.  This course includes a case study on creating and publishing a Power BI report from scratch.

Course details

  • Locations for Advanced Power BI coursesLocations:Manchester, London
  • Next Advanced Power BI course locationNext course:Tue 13 November 2018
  • Advanced Power BI course timesTime:09.30-16.30

Course Contents

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

Custom visuals

  • Training topicThe play axis
  • Training topicWorking with Visio
  • Training topicThe Chiclet slicer

Advanced calendars

  • Training topicCalendar and Calendar Auto
  • Training topicUsing financial periods

Quick measures

  • Training topicCreating quick measures
  • Training topicQuick date measures

More on maps

  • Training topicWorking with shape files
  • Training topicExploring ArcGIS
  • Training topicThe MapBox visual
  • Training topicOther map custom visuals

Advanced bookmarks

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

Report themes

  • Training topicRGB to HEX
  • Training topicHEX to JSON
  • Training topicJSON to reports
  • Training topicJSON from scratch

Covered if time allows If time

BI mobile

  • Training topicUsing the app
  • Training topicCreating BI apps


  • Training topicPersonal versus public
  • Training topicCreating gateways
  • Training topicConnecting sources

More on Power BI Service

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

Covered if time allows If time

Power BI Templates

  • Training topicCreating templates
  • Training topicIncluding calendars
  • Training topicUsing parameters
  • Training topicIncluding hierarchies

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"We had a wonderful trainer, very attentive and helpful, would highly recommend him."

James Wright (Warwick International Computing Systems)

"Good pace, trainer very responsive to additional questions."

Kaili Jarv (Waltham Forest Council)

"Really enjoyed this course. The trainer made this interesting and informative and his enthusiastic approach has definitely made me enthusiastic too!"

Jacky Marquis (NHBC)

"Excellent course. Perfect for my needs, well paced.(Intro to SQL). Another great course. Covered everything I needed and more (SSRS)."

Robert Morgan (Harbottle Lewis LLP)

"Very good course content and trainer, great venue."

Philip Goudal (Southbank Centre)

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 13-14 November 2018 2 £795 Book places
Thu/Fri 29-30 November 2018 2 £950 Book places
Tue/Wed 18-19 December 2018 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 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