Classroom Training
Advanced Power BI Reports
Classroom training course - online version also available
£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 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 05 May 2022
Time: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
- Based on numerical values
- Based on a colour name
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
- Creating bookmarks
- Data and display properties
- Spotlighting and hiding visuals
- Case studies of bookmark use
Quick measures
- Showing selected items
- Filtering columns
Dynamic display
- Changing background colours
- Line chart averages
- Dynamic titles
Narratives
- The smart narrative visual
- Text boxes and values
- Analysing differences
Re-using report parts
- Using published datasets
- Using subreports
Dynamic page navigation
- 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
- The infographics visual
If time
More custom visuals
- Better gauges
- Synoptic panels
- Chiclet slicer
- Better KPIs
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 5 people per class
- Proper restaurant lunch included
- 545 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
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).
Richard Jones (Amplifon UK)
Mel Thornton (Bedfordshire Police)
Mark Huskinson (Two Circles)
Chris Carty (Galliford Try Environmental / ESD)
Kate Lawler (Greater Manchester Combined Authority (GMCA))
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 05-06 May 2022 | 2 | Manchester | £795 | Book places |
| Thu/Fri 09-10 June 2022 | 2 | Manchester | £795 | Book places |
| Mon/Tue 04-05 July 2022 | 2 | Manchester | £795 | Book places |
| Date(s) | Venue |
|---|---|
| 05/05 | Manchester |
| 09/06 | Manchester |
| 04/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).
