Power BI Advanced Training Course - UK wide

Power BI Advanced Course Overview

Our three-day Power BI Advanced training course provides an in-depth bootcamp for anyone needing to harness all of the capabilities of the Power BI platform to build self-service business intelligence solutions and to gain expert knowledge of the sophisticated data analytics features that Power BI has to offer.

If your learners already have a good level of experience using Power BI, and want to take it further, then this course is just what is required to get everyone up to a competent level of expert knowledge.

The Microsoft Power BI Advanced training course is a three-day, instructor-led event which will be conducted either on-site at your premises or as a live virtual classroom event via MS Teams. Courseware will be provided electronically.

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

This Power BI course also forms part of our Microsoft 365 Masterclass.

Power BI Advanced Training Course Prerequisites

Before attending this advanced level course for Power BI business intelligence, students should already possess a good degree of Power BI knowledge and understanding at the very least up to the equivalent of our beginners Power BI course.

For those with little or no previous knowledge of Power BI (or those who have previously used only the Online Service version), we usually recommend that you take our comprehensive four-day zero-to-hero Power BI masterclass instead.

On-site Power BI Advanced Training in the United Kingdom

These are corporate in-house training courses conducted at your workplace for small groups. You should aim to book at least a month in advance and the maximum group size is eight per course.

Our 'face-to-face' closed courses for Power BI are delivered as private events and afford more flexibility than off-the-shelf courses with opportunities to tailor content to fit your particular learning needs. Your trainer will discuss your requirements with you prior to the course date.

We can attend anywhere in mainland UK (for overseas requirements, please enquire).

With our on-site Microsoft Power BI courses our trainers come to your workplace throughout mainland UK, bringing the training to you whether you're in a major city such as London, Manchester, Birmingham, Leeds, or anywhere else.

This offers a cost-effective way to train Power BI for 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 Advanced Courses - UK & Beyond

If you'd rather that your team learns remotely, these small-group Power BI courses are also available as live virtual, interactive sessions from the comfort of your office or workplace. These courses are taught via Microsoft Teams.

Why choose virtual learning? As we've all become used to Online learning (and live virtual meetings) it is clear that virtual classroom delivery has some advantages over traditional face-to-face learning.

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

The maximum group size is eight per course and you 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 enriched by features such as live chat, private chat, and sharing screens and documents.

Learn More About Virtual Training with MS Teams.

Three-Day Microsoft Power BI Advanced Training Course Cost

Our advanced course costs £2775.00 plus VAT inclusive up to six delegates. There is also a cost of £125.00 p/d to cover accommodation and travel within mainland UK (for offshore requirements additional costs apply). More learners can be added for £50.00 plus VAT per person p/day up to a limit of 8.

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 ❤ helping UK organisations to become Power BI experts. Our only question is: Will it be yours?

Our Power BI Trainers are:

Inspirational subject experts with a wealth of experience, 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 24,000 students trained across almost every industry, sector and background.

Commercial and Corporate Advanced Power BI Courses for the Public and Private Sectors

What is the Teaching Method for Our Power BI Courses?

The teaching methodology for our Power BI courses is Instructor-led training (ILT), which means that our courses are engaging, immersive, hands-on and interactive. With this participatory learning method your staff will retain information better, whether they're studying Power BI subjects in-person or via live virtual classroom.

And, whilst we're happy to provide lectures, show-and-tells and drop-in surgeries, the ILT approach is by far the best way 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 a lunch hour and short breaks morning and afternoon. This timetable is fairly standard across the industry and gives six hours of hands-on Power BI learning, which is an optimal day's training for comfortably absorbing and retaining information and completing practice exercises.

If you want a different start time for your course please let us know.

Courses are run week days, during normal business hours.

Why Choose Our Power BI Courses?

• Step-by-Step Courses: Instructor-led Power BI training provided in-person with engaging step-by-step demos, lessons and hands-on exercises.
  
  
• Q&A Courses: Dynamic and interactive Power BI courses with ample time for questions and answers.
  
  
• Flexible Courses: Expert tuition, tailored to your team's knowledge level and learning needs, and covering the Power BI Measures, features and techniques that your trainees need most.
  
  
• Small Class Sizes: Private, small-group training with a maximum of 8 learners to ensure personalised attention.
  
  
• Scalable Courses: Can be run as one or more courses, or as a training rollout bringing entire departments and organisations up to the benchmark of Power BI knowledge and confidence needed.

Microsoft Power BI Advanced Training Course Outline

• Lesson 1: Power BI Desktop Introduction
  1. Download/ Install Power BI Desktop
  2. Overview of the software and important terminology
  3. Introducing Imports
  4. Introducing Visualisations
  5. Introducing Filters and Queries
  6. Introducing Reports
     
     
• Lesson 2: Working with Power BI Data Sources
  1. Discovering Compatible Data Sources
  2. Getting Data from your Data Sources
  3. Performing Direct Queries or Importing Data Options
  4. Defining Hierarchies based on a single data Table
  5. Creating and Managing Tables Relationships
  6. Using 'Append' Queries
  7. Merging Data Tables
     
     
• Lesson 3: Working with Power BI Advanced Data Visualisations
  1. Creating Visualisations and the different visualisation types available
  2. Working with Colour Formatted visuals
  3. Setting the Sort Order
  4. Working with Scatter Chart and Bubble Chart visuals
  5. Editing Visuals with Different Slicer Types¹ (Timeline Slicers & Sync Slicers)
  6. Cross Filtering and Highlighting Visualisations
  7. Visual, Page and Report Level Filters
  8. Drill Mode (Drill Up, Down and Through) for Field Hierarchies
  9. Understanding Hierarchies
  10. Using Dynamic Reference and Constant Lines for Focus
  11. Adding Tables, Matrix Visuals & Conditional Formatting
  12. Using KPIs, Cards and Gauges
  13. Create, Shape and Use Map Visualisations
  14. Working with Custom Visuals
  15. Working with Custom Report Themes
  16. Grouping Data Points and Defining Bin Sizes
  17. The Selection Pane and Bookmarking
      
      
• Lesson 4: Querying Data in Power BI with Power Query²
  1. The Power Query Editor
  2. Working with Filters and Delimiters
  3. Transforming data
  4. Working with Pivot Tables and 'Group By'
  5. Creating Custom Calculated Columns
  6. Creating Data Tables
  7. Adding Conditional Columns
     
     
• Lesson 5: Data Analysis Expression (DAX)³
  1. Introducing DAX Measures⁴ & the DAX formula language
  2. DAX data types and operators
  3. Common DAX functions
  4. Referencing other tables in DAX
  5. Using the CALCULATE and RANKX functions
  6. Using the RELATED, RELATEDTABLE, LOOKUPVALUE functions
     
     
• Lesson 6: Power BI Reports and Exports
  1. Understanding Report Elements and Options
  2. Working with Pages
  3. Including Graphics in your Reports
  4. Report Level Filters
  5. Using Report Themes
  6. Export Power BI Data to CSV
  7. Create a Power BI Template
     
     
• Lesson 7: Sharing and Publishing Power BI Content
  1. The Power BI Service
  2. Sharing Dashboards with Internal and External users
  3. Sharing Content with Microsoft 365 User Groups
  4. Using 'Publish to Web' with Dashboards
     
     
• Lesson 8: Power BI Workspaces⁵
  1. Understanding Workspaces and Collaboration
  2. Creating Power BI Workspaces
  3. My workspace vs shared Workspace
  4. Setting up Permissions and Roles for Workspace Colloboration
     
     
• Lesson 9: The Power BI App
  1. Supported Platforms (iOS, Android, Windows 10 and Windows 11)
  2. Creating Dashboards for Mobile Devices
  3. Accessing Reports and Dashboards from Mobile Devices
     
     
• Lesson 10: Power BI Gateways
  1. The Power BI Personal Gateway⁶
  2. Working with OneDrive
  3. Connecting to SharePoint Lists
     
     

Power BI Terminology in Layman's Terms

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

2) In Power BI, Power Query enables you to "get" (or connect to) data from external data sources and then sculpt and clean (i.e. "transform") that data. Your edited data can then be brought into Power BI to produce pivots, reports and charts. Or, to put it another way, the Power Query Editor is an ETL data integration tool which means that it enables you to Extract external data from multiple sources and then Transform that data before Loading it into a data warehouse (in this instance Power BI) for analysis and reporting.

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) There are over 250 DAX measures available to use in your DAX formulas in Power BI. For a comprehensive reference list for DAX measures by category see the Microsoft article here: DAX function reference.

5) Power BI Workspaces provide a space for collaboration with your colleagues for working upon dashboards, reports and data models. Workspace members will usually need a Power BI Premium Per User or Power BI Professional license. Fabric Free license holders can't share workspaces but workspaces can be shared with them by Premium and Pro license holders. For external users you can invite them as guest users of the workspace through the Azure portal.

6) Whereas the standard Power BI Gateway is for working in a collaborative environment, a Power BI Personal Gateway can be installed on your own PC or laptop for personal/ individual use in an unshared, closed environment. Note that with a Personal Gateway you can share read-only reports etc., but you cannot collaborate. You can only have a maximum of one Personal Gateway and one on-premise standard gateway running on the same computer at any one time.

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 Power Apps Introduction

course duration - two days

Canvas Apps for Power Apps 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