Microsoft Office training -  Advanced Power BI Desktop

Power BI Tools Training

Advanced Power BI Desktop (2 days)

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

If you've mastered the basics of creating Power BI Desktop 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 Desktop 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 finishes with a case study on creating and publishing a Power BI Desktop report from scratch.

We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking  (or consider an onsite Power BI Tools training course).

Course Contents

More on mapping

  • Training topicCreating shape maps
  • Training topicUsing TopoJSON files
  • Training topicUsing ArcGIS

Drill-through and bookmarks

  • Training topicDrill-through fields
  • Training topicThe selection pane
  • Training topicCreating/using bookmarks

Techniques and ideas

  • Training topicPicture tables
  • Training topicTreemap slicers

Advanced Query Editor

  • Training topicMerging and appending tables
  • Training topicPIVOT and UNPIVOT
  • Training topicUsing source folders

Review of DAX measures

  • Training topicQuery context
  • Training topicAggregateX functions
  • Training topicThe CALCULATE function


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


  • Training topicCreating hierarchies
  • Training topicUsing in drill-down

Binning and clustering

  • Training topicCreating bins
  • Training topicCustom bins
  • Training topicData clustering

Charting techniques

  • Training topicWaterfall breakdown
  • Training topicUsing funnel charts
  • Training topicScatter and bubble charts

Useful custom visuals

  • Training topicCharting custom visuals
  • Training topicOther custom visuals

A full case study

  • Training topicLoading the data
  • Training topicCreating the measures
  • Training topicCreating the visuals
  • Training topicPublishing the report

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Best course I've been on."

David Gerwitz (Helena Partnerships)

"Very useful to have the manual and USB to continue learning after course. Fast paced but lots to cover, enjoyed the course and learned a lot. Trainer was extremely patient!"

Rebecca Downes (NHS South, Central and West CSU)

"Great course. Manuals and exercises brilliant, trainer excellent and highly knowledgeable."

Nicholas Bosdet (Branston Ltd)

"Accessible and enjoyable!"

Angela Gould (Coveris)

"The trainer is great!"

Chris Lea (Hill Dickinson LLP)

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 Desktop reports, and use Power BI Desktop on a weekly basis.

Related Courses

Introduction to Power BI Desktop


2 day course

PowerPivot / Excel Power BI


2 day course



2 day course

Other Excel Power BI Tools and Desktop Power BI training resources

Power BI Tools exercises

Power BI Tools exercises

View Power BI Desktop or PowerPivot exercises

Power BI Tools videos

Power BI Tools videos

View Excel 2013 Power BI Tools videos

Power BI Tools blogs

Power BI Tools blogs

View Power BI - Excel or Power BI Desktop blogs

This page has 0 threads Add post