Browse 548 attributed reviews, viewable separately for our classroom and online training
Classroom training -  Fast track Power BI

Classroom Training

3-day intensive Power BI training course

Classroom training course - online version also available

3 days

This course is designed for people who tick the following boxes:

  • You've tried teaching yourself Power BI, but realise that you'd learn much more quickly on a formal course (either that or you're self-taught at Power BI and suspect that you've missed lots of tips and tricks along the way).
  • You're normally pretty quick at picking up software, and are happy to cover a lot of material in three days.

If this sounds like you, our three-day fast-track Power BI course could be ideal.  It aims to cover virtually all of the material from our (already busy) two-day Introduction to Power BI and two-day Advanced Power BI courses in three busy days.

Course details

  • Locations for Fast track Power BI coursesPossible locations:London, Manchester, Online
  • Next Fast track Power BI course locationNext classroom course:Mon 01 November 2021
  • Fast track Power BI course timesTime:10.00-16.30

Course Contents

This fast-track course combines topics from the following other Wise Owl courses:

From our INTRODUCTION TO POWER BI course

Data sources

  • SQL Server / databases
  • Excel / text files
  • Websites and web services

Multiple tables

  • Relationships
  • Filter directions

Basic reports

  • Getting data
  • Basic visualisations
  • Shapes, text boxes and images

Formatting visualisations

  • The formatting panes
  • Conditional formatting

Charts

  • Working with charts
  • Specific chart type issues
  • Grouping and binning

Other types of visualisation

  • Working with matrices
  • Working with cards

Dashboard visualisations

  • Gauges
  • Single-number visualisations
  • KPIs

Query editor

  • Filtering rows
  • Manipulating columns
  • Working with data types

Filtering data

  • Slicers
  • Visualisation level filters

Drill-down

  • Interactions
  • "See records" feature

Drill-through filtering

  • Adding drillthrough filters
  • Back buttons

Calculated columns

  • Adding columns
  • IF and SWITCH
  • The RELATED function

Overview of maps

  • The types of map
  • Geo-location
  • Disadvantages of ArcGIS
  • Other mapping visuals

Publishing reports

  • Power BI accounts
  • Power BI files (PBIX)

Power BI Service

  • Publishing
  • Dashboards and tiles
  • Sharing reports
From our ADVANCED POWER BI course

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

Covered if time allows If time

Parameters

  • Filtering and drop-downs
  • SQL stored procedures
  • Dynamic connection strings

Custom visuals

  • The play axis slicer
  • The Chiclet slicer
  • Other examples
  • Pros and cons

Tooltips

  • Tooltip backgrounds
  • Dynamic report tooltips
  • Visual header tooltips

Conditional formatting

  • Based on numerical values
  • Based on a colour name

Covered if time allows If time

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

 Although you don't need to have used Power BI to attend the course, you'll get much more out of this course if you've already started to use Power BI in anger.

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

"Really useful and informative course. Although I had some knowledge of PBI the additional detail was really helpful."

Ian Connolly (Manchester University NHS Foundation Trust)

"Great course, informative and thought provoking. Full of content and exercises are a great way to practice what you've been learning about. Wonderful course materials to help you after - and let's not forget the lunches. (I have received training from you previously.)"

Sarah Kenn (National Fostering Agency (NFA))

"Brilliant, very enthusiastic and engaging trainer. He was very knowledgeable about all aspects of SQL. Lovely guy."

Thomas Critchley (Ministry of Housing, Communities and Local Government (MHCLG))

"The trainer was fantastic - very engaging and informative. Excellent training - thank you."

Victoria Elliott (Bloom Services)

"We had one of the best tutors I've met, brilliant at teaching, explained very complex concepts very easily."

Boris Arkhipov (PricewaterhouseCoopers)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled Fast track Power BI training dates

Here are the classroom Fast track Power BI courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Mon/Wed 01-03 November 2021 3 £1,095 Book places
Date(s) Venue
01/11

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 to Power BI

2 day course

Advanced Power BI

Advanced Power BI

2 day course

DAX

DAX

2 day course

Other Power BI training resources

Power BI exercises

Power BI exercises

We have lots of Power BI exercises on our website.

View Power BI Desktop, DAX or Power Apps exercises

Power BI videos

Power BI videos

Have a look at the videos we've published showing how to use Power BI.

View Power BI videos

Power BI skills assessment

Power BI skills assessment

Take our test to see how good your Power BI skills are.

View Power BI skills skills assessment tests

Power BI blogs

Power BI blogs

Have a look at some of the Power BI blogs that we've published on our site.

View Power BI or Power Apps blogs

This page has 0 threads Add post