WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 520 reviews for our classroom and online training
Classroom training -  Advanced Power BI Reports

Classroom Training

Advanced Power BI Reports

Classroom training course - online version also available

£950 + VAT for most venues (£1,095 + VAT for London)

2 days

If you've mastered the basics of creating Power BI reports, you may like to find out what else they can do (although you should only consider attending this course if you already know the basics of Power BI).  Among other things on this course, you will learn:

  • what all those extra visuals in the visualisations pane do;
  • new ways to analyse your data using smart narratives, Q&A visuals and analytics; and
  • how to make your reports easier to use using tooltips and bookmark ideas.

This course is a companion to our two-day Advanced Power BI Data classroom / online course, which shows advanced ways to work with data in Power BI (there is no overlap between the two courses).

Course details

  • Locations for Advanced Power BI Reports coursesPossible locations:London, Manchester, Online
  • Next Advanced Power BI Reports course locationNext classroom course:Thu 07 July 2022
  • Advanced Power BI Reports course timesTime:09:30-16:30

Course Contents

The contents of this course are as follows:

Advanced tables

  • Showing URLs as icons
  • Images in tables
  • Sorting multiple columns
  • Preventing data grouping

Conditional formatting

  • Gradients and rules
  • Based on a field value
  • Icons and data bars

Dynamic display

  • Format properties as expressions
  • Examples of dynamic formatting


  • Adding constant lines
  • Adding trendlines
  • Showing anomalies

Decomposition tree

  • How it works
  • Formatting the parts
  • Locking levels

Other visuals

  • Key influencers
  • Ribbon charts
  • Waterfall charts

Q & A visuals

  • Setting synonyms
  • Adding FAQs
  • Training Q&A visuals


  • Tooltip backgrounds
  • Dynamic report tooltips
  • Visual header tooltips


  • Data and display properties
  • Spotlighting and hiding visuals
  • Bookmark navigators
  • Some design case studies

Quick measures

  • Comparison against single items
  • Line chart averages
  • Listing selected items
  • Running totals


  • The smart narrative visual
  • Text boxes and values
  • Analysing differences

Dynamic page navigation

  • Page navigators
  • Page navigation buttons
  • Controlling with slicers
  • Drill-through with slicers

Advanced drill-through

  • Category vs summarized explained
  • Drill-through between reports
  • Disabling drill-through
  • Mouse buttons/action buttons

Custom visuals

  • Ways to import
  • Pinning custom visuals
  • Infographics (picture charts)

Covered if time allows If time

More custom visuals

  • The play axis visual
  • Synoptic panels
  • Chiclet slicer

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

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"The course was great! I've learned a lot in a few days, there's still a long way to go but I've now got a strong foundation. A great teacher, competent and helpful. I'm glad I've the manual too because it is very well written. Thanks again!"

Christian Radici (Nexperia UK Ltd)

"An excellent trainer, clearly very knowledgeable and experienced in running the course. He was personable and witty, keeping it light but also quite firm to ensure we kept on track. The pace felt right, and I liked that there was in-person training, not just on-line; that helps me focus on learning as it's easier to get distracted when on-line. The support materials for reference afterwards are also very useful"

Karen Skinner (LifeArc)

"Hands on course that will enable me to hit the ground running when I will need to use Power BI for analytics. Trainer is very knowledge and very easy to follow. The course covers a lot of topics and I reckon it is well structured. All in all, very satisfied with the Wise Owl offering!"

Carlo Pisoni (PricewaterhouseCoopers)

"Really great course, expert trainer and great resources. I chose the course based on recommendations and my previous experience of both the supplier and trainer – would highly recommend."

Bowie Penney (Department for Levelling Up, Housing and Communities (DLUHC, ex MHCLG))

"The trainer is very personable and knowledgeable. Fircroft has used Wise Owl many times and I would highly recommend them!"

Louise Gorry (Fircroft Engineering Service Ltd)

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

Scheduled Advanced Power BI Reports training dates

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

Dates Days Venue Price Booking
Thu/Fri 07-08 July 2022 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

Advanced Power BI Data RECOMMENDED


2 day course



2 day course

Other Power BI training resources

Power BI exercises

Power BI exercises

View Power BI Desktop or DAX exercises

Power BI videos

Power BI videos

View Power BI or DAX for 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