Power BI Training
Advanced Power BI Training Course
£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
Locations:London, Manchester
Next course:Thu 11 July 2019
Time:09.30-16.30
Course Contents
Advanced data models
Connecting to folders- Changing the source using M
Advanced Query Editor
- Unpvioting data
- Merge transforms
- Append transforms
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
- Static report tooltips
- Dynamic report tooltips
Advanced techniques
- Drill through
- Synchronised slicers
- Data analytics
Quick measures
- Dynamic titles
- Running totals
- Absolute and relative totals
- Filtering columns
Bookmarks
- Creating bookmarks
- Data and display properties
- Spotlighting and hiding visuals
Bookmark case studies
- Dynamic chart axes
- Dynamic page titles
- Information pop-ups
Report themes
- Getting report themes
- Creating basic report themes
- Visual themes
Power BI Templates
- Creating templates
- Including themes
- Using parameters
If time
More on Power BI Service
- Row security
- Q&A
- Analysing in Excel
If time
BI mobile
- Using the app
- Creating BI apps
- Limitations
Why Choose Us?
No more than 6 people per class- Proper restaurant lunch included
- 515 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Alex Wallace (Manchester Metropolitan University)
Ian Lynch (Manchester Metropolitan University)
Andrew Witt (Coloplast Ltd)
John Pelan (Coloplast Ltd)
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 reports, and use Power BI on a weekly basis.
Scheduled Advanced Power BI training dates
Here are the Advanced Power BI courses we have scheduled for the next 3 months:
| Dates | Days | Venue | Price | Booking |
|---|---|---|---|---|
| Thu/Fri 11-12 July 2019 | 2 | London | £950 | Book places |
| Thu/Fri 29-30 August 2019 | 2 | Manchester | £795 | Book places |
| Tue/Wed 10-11 September 2019 | 2 | London | £950 | Book places |
| Tue/Wed 01-02 October 2019 | 2 | Manchester | £795 | Book places |
| Thu/Fri 03-04 October 2019 | 2 | Manchester | £795 | Book places |
| Thu/Fri 14-15 November 2019 | 2 | London | £950 | Book places |
| Tue/Wed 26-27 November 2019 | 2 | Manchester | £795 | Book places |
| Date(s) | Venue |
|---|---|
| 11/07 | London |
| 29/08 | Manchester |
| 10/09 | London |
| 01/10 | Manchester |
| 03/10 | Manchester |
| 14/11 | London |
| 26/11 | 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).
