COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Classroom training -  Advanced Power BI

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

  • Locations for Advanced Power BI coursesPossible locations:London, Manchester, Online
  • Next Advanced Power BI course locationNext classroom course:Thu 04 February 2021
  • Advanced Power BI course timesTime: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

Covered if time allows If time

Decomposition tree

  • How it works
  • Formatting the parts
  • Locking levels

Covered if time allows If time

More on Power BI Service

  • Row security
  • Q&A
  • Analysing in Excel

Covered if time allows 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?

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

"A really detailed course! We had a great teacher, and he made everything easy to understand. The course material I took away is really useful for future reference. I'm very impressed with Wise Owl!"

Jemma McColm (City District Ltd)

"Fantastic courses with an engaging trainer. Content and pace was perfect."

Andrew Witt (Coloplast Ltd)

"Excellent delivery of training and interactive exercises. Well delivered course. In-depth manual and exercises to go through in own time."

Ian Lynch (Manchester Metropolitan University)

"Trainer was very good at explaining (Intro PBI). Trainer was patient and entertaining, which made the course enjoyable and useful (Adv PBI)."

Michelle Kennedy (ERCe Energy)

"(Intro Power BI course) Excellent pace for 2 days. Plenty of interaction and humour. Great lunch breaks. (DAX course) Excellent course. Very well delivered on a "tricky" topic which could have sent me slightly mad. Great pace of delivery. This is the first time I felt I could do the same course again! (Advanced Power BI course) Excellent delivery of a new course. Quick measures were very useful after the DAX course (a good compliment)."

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 £795 Book places
Thu/Fri 25-26 March 2021 2 £950 Book places
Thu/Fri 22-23 April 2021 2 £795 Book places
Thu/Fri 03-04 June 2021 2 £950 Book places
Thu/Fri 24-25 June 2021 2 £795 Book places
Tue/Wed 03-04 August 2021 2 £950 Book places
Thu/Fri 19-20 August 2021 2 £795 Book places
Date(s) Venue
04/02
25/03
22/04
03/06
24/06
03/08
19/08

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

Introduction to Power BI

Introduction

2 day course

PowerPivot / Excel Power BI

Introduction

2 day course

DAX

Intermediate

2 day course

Other Power BI training resources

Power BI exercises

Power BI exercises

View Power BI Desktop, DAX or Power Apps exercises

Power BI videos

Power BI videos

View 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