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

Possible locations:London, Manchester, Online
Next classroom course:Thu 07 July 2022
Time:09:30-16:30

SCHEDULED DATES Course Contents - PDF

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

Analytics

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

Tooltips

Tooltip backgrounds
Dynamic report tooltips
Visual header tooltips

Bookmarks

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

Narratives

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?

No more than 6 people per class
Proper restaurant lunch included
520 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

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	Manchester	£950	Book places

Date(s)	Venue
07/07	Manchester

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).