Classroom Training
Advanced Power BI
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 it can do - but you should only consider attending this course if you use Power BI regularly. Learn how to create report themes and templates, find out how to use quick measures and bookmarks, delve further into Query Editor and maps, and much more!
Course details
Possible locations:London, Manchester, Online
Next classroom course:Thu 04 February 2021
Time:10.00-16.30
Course Contents
The contents of this course are as follows:
Advanced data models
- Connecting to folders
- Changing the source using M
Advanced Query Editor
- Unpivoting data
- Merge transforms
- Append transforms
Data load error handling
- Viewing errors
- Fixing/removing errors
Parameters
- Filtering and drop-downs
- SQL stored procedures
- Dynamic connection strings
Custom visuals
- The play axis slicer
- The Chiclet slicer
- Synoptic panels
Tooltips
- Tooltip backgrounds
- Dynamic report tooltips
- Visual header tooltips
Conditional formatting
- Based on numerical values
- Based on a colour name
Dynamic display
- Dynamic images in tables
- Dynamic button hyperlinks
- Dynamic titles
Quick measures
- Date tables
- Time intelligence
- Showing selected items
- Filtering columns
Bookmarks
- Creating bookmarks
- Data and display properties
- Spotlighting and hiding visuals
Bookmark case studies
- Dynamic chart axes
- Dynamic page titles
Dynamic page navigation
- Page navigation buttons
- Controlling with slicers
- Drill-through with slicers
Power BI Templates
- Creating templates
- Using parameters
If time
Decomposition tree
- How it works
- Formatting the parts
- Locking levels
If time
More on Power BI Service
- Row security
- Q&A
- Analysing in Excel
If time
Power BI mobile
- Creating mobile reports
- Limitations
To attend this course you must be familiar with creating Power BI reports, and use Power BI on a weekly basis.
Why Choose Us?
- No more than 5 people per class
- Proper restaurant lunch included
- 505 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).
Jemma McColm (City District Ltd)
Andrew Witt (Coloplast Ltd)
Ian Lynch (Manchester Metropolitan University)
Michelle Kennedy (ERCe Energy)
John Pelan (Coloplast Ltd)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Scheduled Advanced Power BI training dates
Here are the classroom Advanced Power BI courses we have scheduled for the next 3 months:
| Dates | Days | Venue | Price | Booking |
|---|---|---|---|---|
| Thu/Fri 04-05 February 2021 | 2 | Manchester | £795 | Book places |
| Thu/Fri 25-26 March 2021 | 2 | London | £950 | Book places |
| Thu/Fri 22-23 April 2021 | 2 | Manchester | £795 | Book places |
| Thu/Fri 03-04 June 2021 | 2 | London | £950 | Book places |
| Thu/Fri 24-25 June 2021 | 2 | Manchester | £795 | Book places |
| Tue/Wed 03-04 August 2021 | 2 | London | £950 | Book places |
| Thu/Fri 19-20 August 2021 | 2 | Manchester | £795 | Book places |
| Date(s) | Venue |
|---|---|
| 04/02 | Manchester |
| 25/03 | London |
| 22/04 | Manchester |
| 03/06 | London |
| 24/06 | Manchester |
| 03/08 | London |
| 19/08 | 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).
