Power BI Masterclass Training Course - UK wide

Power BI Masterclass Course Overview

Our four-day Power BI masterclass training course provides an in-depth instructor-led course that takes novices through to an expert level of knowledge modelling data with Power BI's self-service business intelligence solutions.

This four-day, in-depth Zero-To-Hero Power BI Masterclass provides everything your organisation needs to start engaging with data modelling, analytics and visualisations at a sophisticated level of competence.

Email us or call 0844 493 3699 to find out more about booking Power BI training for your team.

The Microsoft Power BI Masterclass is an interactive instructor-led event which will be conducted either on-site at your premises or as live virtual classroom via MS Teams. We will provide all courseware and reference materials electronically to use for reference.

Our expert trainers come to you and can deliver this masterclass Power BI course at your premises anywhere in mainland UK.

Power BI Masterclass Prerequisites

Whether your staff have only ever used the Online Service version of Power BI before, or they have no previous experience at all with Power BI, this is the course they should undertake if you need an end-to-end bootcamp which takes rookie users from scratch and converts them into skilled data modellers with the Desktop version of Power BI. Some prior understanding of data management would be advantageous.

Who should take this Power BI Masterclass course?

If you need to get your staff from absolute beginners through to an advanced level of competency with Power BI in under a week then this is the course that we recommend.

If your learmers already have a fair level of experience working with the Power BI desktop, then we recommend our three-day advanced course instead.

On-site Power BI Masterclasses in the United Kingdom

These are corporate in-house training courses conducted at your workplace for small groups and are exceptional value and very popular. You will usually need to book at least one month in advance and the maximum number of learners is eight per course.

Our 'face-to-face' closed courses for Power BI are delivered as private courses for your delegates offering more flexibility than off-the-shelf public courses and topics taught can often be tailored to match your learning needs. One of our trainers will discuss your training requirements with you prior to the course.

Our trainers can attend anywhere in mainland UK (for overseas requirements, please enquire). On rare ocassions travel supplements may apply for Power BI training in Central London to cover additional expenses such as congestion charges, but we will endeavour to waive these when possible.

With our on-site Microsoft Power BI courses our regional trainers come to your workplace throughout mainland UK, bringing the training to you regardless of whether you are in a major city such as London, Manchester, Birmingham or Leeds, or anywhere else. This offers a really cost-effective way to train small groups and entire departments in the comfort of familiar surroundings from the Capital City of London to The Cotswolds, from Hampshire to Northamptonshire, West Midlands to West Yorkshire, Sussex to South Yorkshire, Norfolk to Northumberland, Lancashire to Lincolnshire, Cambridgeshire to Gloucestershire, Bristol to Berkshire, Essex to the East Riding and everywhere inbetween.

Live Virtual Classroom Power BI Masterclasses, United Kingdom and Beyond

If you have a group of staff that you would prefer to be tutored remotely rather than having a trainer come out to you these small-group Power BI masterclasses are also available Online as live virtual, interactive training sessions from the comfort of your own office or workplace. These live, instructor-led virtual courses are taught via Microsoft Teams.

Why choose virtual learning? As we are all becoming more used to Online learning and live virtual meetings it has become apparent that the virtual classroom method of delivery has many advantages over traditional face-to-face learning venues.

If you are looking for local training near you, then you can't get any closer to your doorstep than you can with virtual learning.

The maximum number of learners is eight per course and you can benefit from full and immersive interaction with your trainer just as if they were in the classroom with you, with engaging hands-on training via advanced live video conferencing that is further enhanced by features such as live chat, private chat, and sharing screens and documents.

You can find out more about live virtual classroom Power BI training delivered across Microsoft Teams video conferencing here: Learn More About Virtual Training with MS Teams.

Four-Day Microsoft Power BI Masterclass Cost

Our masterclass course is charged at £3,200.00 plus VAT and is available at this price for anywhere between one and six delegates. There is also a charge of £125.00 per day to cover the instructor's accommodation and travel costs to anywhere within the UK mainland (for offshore requirements additional costs will apply). If you have additional delegates you can add them for £50.00 plus VAT per person per day up to a maximum of 8 in total.

Please note that for tailored Power BI training courses, we can only provide you with a quote for training and courseware once we have evaluated your requirements.

We really ❤ love helping UK organisations to become Power BI virtuosos. Our only question is: Will it be yours?

Our Power BI Trainers are:

Specialist educators with a wealth of experience and expertise, proven track records and excellent feedback.

Our Closed Power BI Courses are:

Flexible instructor-led courses catering to YOUR specific learning needs and training requirements.

Education is Our Passion:

Over 18,000 students trained across almost every industry, sector and background.

Commercial and Corporate Power BI Masterclasses for the Public and Private Sectors

How Many People Should Attend Our Private Power BI Courses?

Whilst the number of people who attend our private Power BI courses is essentially up to you and dependant upon the number of learners you have who need to receive the training, we encourage all of our clients to keep your class sizes small where possible and recommend a maximum of eight learners for technical courses such as Power BI. This provides a more personable and effective learning experience for you and allows the trainer to give more individual attention to each and every student.

What is the Teaching Method for Our Power BI Courses?

The teaching method for our private Power BI courses is Instructor-led training (ILT), which means that our courses are engaging, immersive, hands-on and interactive, and thereby facilitate more effective learning and information retention. With this participatory learning method your staff will retain information better, whether they are studying Power BI subjects in-person or via live virtual classroom. And, whilst we are happy to provide lectures, demonstrations and show-and-tells for larger groups (plus drop-in surgeries for ad hoc technical advice and explanation), the instructor-led training approach is by far the most reliable teaching methodology to bring your Power BI know-how to life in a small-class-size setting.

How Long are our Power BI Courses?

Usual teaching hours for our Power BI courses are 9.30AM to 4.30PM with an hour for lunch and two short breaks morning and afternoon. This timetable is fairly standard across UK training providers and gives six hours of hands-on Power BI learning, which is an optimal day's training when it comes to comfortably absorbing knowledge, undertaking practice exercises and retaining information.

If you need an earlier or later start time for your course please let us know and we will do our best to accommodate you.

Courses are delivered week days, Monday to Friday during normal business hours.

More About Our Power BI Training Delivery Method for Closed Courses

• Step-by-Step Courses: Instructor-led Power BI training provided in-person with step-by-step demonstrations, lessons and hands-on exercises.
  
  
• Q&A courses: Dynamic and interactive Power BI courses with plenty of time for questions and answers.
  
  
• Flexible Courses: Professional tuition that's tailored to match your team's present knowledge level and learning needs, and covering the Power BI Measures, features and techniques that your trainee staff, co-workers or employees need the most.
  
  
• Small Class Sizes: Private, Power BI training for small group sizes with a maximum of 8 learners on any course.
  
  
• Scalable Courses: Can be run as a single course, tutorial or workshop; Or as a training rollout bringing whole teams, departments and organisations up to the benchmark level of Power BI knowledge and confidence that you require.

Microsoft Power BI Masterclass Outline and Agenda

• Lesson 1: Power BI Overview
  1. Understanding the different Power BI Products and Services
  2. Power BI Desktop version (What does it do? / What is it for?)
  3. Understanding Power BI Licensing
     
     
• Lesson 2: Loading Data into PBI
  1. Load Data from CSV Text Files, Excel Worksheets and from MS SQL Server databases
  2. Comparing Import and DirectQuery Storage Modes
  3. Load Data from OneDrive and SharePoint sources
  4. Load Data from a Webpage
  5. Connecting Live to a Published Dataset
     
     
• Lesson 3: Transforming Data with PBI
  1. Profiling, Cleaning & Transforming Data
  2. Optimising CPU usage and memory capacity with Query Folding
  3. Shaping and Sculpting Datasets
  4. Merging and Appending Data
  5. Applying Fuzzy Lookups¹
  6. Structuring and Managing your Queries
  7. Viewing Query Dependencies
  8. Power Query Parameters
  9. Using Power BI Template Files
  10. Using the M Language²
      
      
• Lesson 4: Data Modelling in PBI
  1. Basic Data Modelling Concepts
  2. Configuring Tables
  3. Categorising Data
  4. Sorting Columns
  5. Creating Hierarchies
  6. Organising Content with Display Folders and Views
  7. Using Relationships
  8. Understanding Filter Propagation
     
     
• Lesson 5: The DAX Language³ for PBI
  1. Introduction to DAX
  2. Using Calculated Columns
  3. Creating Custom Groups
  4. Using DAX Measures
  5. Using the Filter Context with CALCULATE
  6. Using Variables
  7. The DAX Query View Environment
  8. Iterator Functions
  9. Using the FILTER Function
  10. Creating Calculated Tables
  11. Dynamic Format Strings
      
      
• Lesson 6: Visualising Data in PBI
  1. Formatting Tables and Matrix Visuals
  2. Conditionally Formatting Visual Content
  3. Using Card Visuals
  4. Formatting Charts
  5. Report Themes
  6. Using Sparklines for quick-reference chart visualisations
  7. Using Tooltips
  8. Continuous Axis versus Categorical Axis
  9. Automatically Identify Clusters of Data
  10. Working with Animating Scatter Charts
  11. Using the Analytics Pane
  12. Forecasting and Anomaly Detection
  13. Using the Analyse Feature
  14. Using Tree Maps for hierarchical, nested data
  15. Analysing Data with a Decomposition Tree⁴
  16. Using Gauges and KPIs
  17. Using Map Slicers⁵
  18. Using Filters
  19. Importing Visuals
      
      

1) A fuzzy lookup allows you to return results based upon parameterised similarities as opposed to ones based upon exact matches.

2) Not dissimilar to DAX (see below), M Language is a Power Query formula language which allows you to use functions to filter and combine data from one or more sources.

3) Simply put, DAX measures are what you might refer to as functions and/or formulas in other applications such as Excel. The DAX formula language is more specialised than this suggests though and it provides measures for working with relational data and aggregating data from multiple sources. As a formula language, DAX consists of all the components of a formula including its functions, constants and operators.

4) In its simplest sense, a decomposition tree is a type of visualisation in Power BI which allows you to drill down through your data (with AI) to perform "root cause analysis". The term orginates from graph theory which uses the tree decomposition model to map the fastest computational route to solving a mathematical question.

5) Power BI Slicers provide a means of quickly filtering portions of your data model with the click of a button. In Power BI Slicers provide a really simple way of sculpting your visualisations. The two main types of slicer tools are dropdown slicers and slider slicers.

Other Power Platform Courses

Power Platform Master Class course

course duration - five days

Microsoft Power Automate Introduction

course duration - two days

Microsoft Power Automate Advanced

course duration - two days

Microsoft Powerapps Introduction

course duration - two days

Canvas Apps for Powerapps Training

course duration - three days

Microsoft Power BI Online Training

course duration - one day

Microsoft Power BI Desktop Training

course duration - three days

Power BI Beginners Training

course duration - one day

Power BI Intermediate Training

course duration - two days

Power BI Advanced Training

course duration - three days

Power BI Masterclass

course duration - four days

Power Apps and Power Automate Combined Training

course duration - four days

Microsoft Dataverse Beginners

course duration - three days