Microsoft Office training -  Advanced Power BI Desktop

Power BI Training

Advanced Power BI Desktop Training Course

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

2 days

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 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
  • Training topicAction buttons

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

"Thoroughly enjoyed the introduction to the vast possibilities of VBA."

Matthew Walker (BerryWorld Ltd)

"Manuals and exercises are brilliantly comprehensive."

Caroline Prado-Marin (Beck Pollitzer)

"Brilliant, the trainer was engaging throughout, patient and willing to take time out to answer ad-hoc questions. I'm an avid viewer of Wise Owl tutorials on YouTube."

Raul Gonzalez (Halfords Media UK)

"All really good thanks. Had good reviews on Google, so booked."

Michael Barlow (Garic Ltd)

"Good course, really nice to have an extensive guide to come away with for future reference. Good pace & great to have a small class so free to ask questions."

Nick Stringle (IBM Business Consulting Services)

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 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 blogs

Power BI blogs

View Power BI - Excel or Power BI Desktop blogs

This page has 0 threads Add post