Power BI Training Courses in London, Online & UK

Award-winning, small, friendly Power BI courses in London, online & across the UK.

Hands-on training using real-world example for all levels from beginner to advanced

All courses CPD certified and include 6 months post-course support.

Learn how to transform raw data into actionable business insights.

Rated: Exceptional since 2013
Over 1,500 external reviews

Feefo Logo
  • Microsoft Partner
    -
    Learn with experts
  • CPD Certified
    -
    Validated by specialists
  • Rated Outstanding
    -
    11 years in a row
  • Moneyback Guarantee
    -
    100% Peace of mind

Our Power BI Courses

1 Day Power BI Introduction Course

Introduction to Power BI Course

CPD Certified
4.79 / 5
1 day.
Client Site Courses Available.
Classroom, Online & Client Site.

This Power BI for beginners course covers all of Power BI’s basics. It is ideal if you will be working with dashboards and reports created by others.

  • Overview of Power BI
  • Importing data (various sources)
  • Ways to manage your data
  • Creating data visualisations
  • Publishing & sharing reports
  • Automatically refreshing data

This Power BI for beginners course covers all of Power BI’s basics. It is ideal if you will be working with dashboards and reports created by others.

  • Overview of Power BI

  • Importing data (various sources)

  • Ways to manage your data

  • Creating data visualisations

  • Publishing & sharing reports

  • Automatically refreshing data

Click on the sections below to see the detailed course syllabus.

  • What is Power BI and when do I use it?
  • Power BI installation and versions.
  • What is Power BI – a Pocket History
  • Power BI vs Competitors
  • Understanding Power BI Desktop vs Service
  • Power Query vs Report Builder
  • Power BI Workflow Summary
  • Different data sources: Files, Databases and the Web.
  • Optimising and transforming your Data
  • Removing Columns/Rows
  • Data Type Changes
  • Filtering data
  • Replacing Data
  • Splitting/merging/Extracting Data
  • Setting up the Report Canvas
  • Matrix
  • Charts
  • Cards
  • Tables
  • Inserting and Using Basic Slicers

This topic is only demonstrated showing how it could look as every company is set up differently

  • Power BI License Types
  • Workspaces – Permissions
  • Power BI Service Tour
  • Editing your Report
  • Sharing and Subscribing
  • Exporting to Web/PowerPoint/SharePoint
  • Creating a Dashboard

This topic is only demonstrated showing how it could look as every company is set up differently

  • Overview of the Data Gateway
  • Scheduling Data Refreshes
  • Refreshing On-Demand

You don’t need any prior knowledge of Power BI to come on this course.

This course assumes that you have a basic understanding of Data sources e.g. Excel/ CSV/ Databases etc.

Oakley is one of our expert trainers for this course with deep Power BI expertise. He has been a Microsoft Certified Trainer for 8 years.

He has 19 years experience training across various Microsoft applications and a very broad foundation in the Microsoft ecosystem.. He has specialised in Microsoft Power BI since 2017, making him a veteran of the platform. This specialisation includes training delegates on advanced data modeling, DAX scripting, data visualisation best practices, and Power Platform integration, ensuring that you don’t just learn to use Power BI, but how to be an effective Power BI developer and analyst.

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £495 (+VAT)

  • Easy booking

  • Money back guarantee

  • Post-course support

Book Now
2 Day Advanced Power BI Course

Advanced Power BI Course

CPD Certified
4.83 / 5
2 days.
Client Site Courses Available.
Classroom, Online & Client Site.

Become a Power BI  power user. Learn to create dashboards and reports, use it for data storytelling and manage data governance and security.

  • Create and customise reports in Power BI
  • Use Drill Down and Drill Through
  • Use Custom Tooltips and Bookmarks
  • Optimize your Data and Relational model
  • Design best practices
  • Security, permissions & ChatGPT

Become a Power BI  power user. Learn to create dashboards and reports, use it for data storytelling and manage data governance and security.

  • Create and customise reports in Power BI

  • Use Drill Down and Drill Through

  • Use Custom Tooltips and Bookmarks

  • Optimize your Data and Relational model

  • Design best practices

  • Security, permissions & ChatGPT

  • Main Concepts
  • Transformation with Power Query
  • Report Design with Report Builder
  • M-Code vs DAX
  • Working with Power BI Backgrounds
  • Introduction to DAX
  • Creating Measures & Calculated Columns
  • DAX Measure and Column Syntax
  • SUM vs SUMX
  • FORMAT & WEEKDAY functions
  • Build a Monthly Sales/Profit Report
  • Using Slicers and Filters
  • Working with Power BI Panes
  • Building Tabular Reports
  • Working with Matrix Layouts
  • Types of Conditional Formatting
  • Adding Drill-Downs
  • Creating Drill-Through Reports
  • Custom ToolTips
  • Bookmarks
  • Creating a Comparison Page
  • Editing Interactions for Slicer/Visual Interactivity
  • Custom and Conditional Formatting
  • Build a YTD Summary and Detailed Report
  • Time Intelligence (MTD, QTD, YTD, Prior Year)
  • Understanding CALCULATE to filter
  • Understanding IF and SWITCH
  • Understanding DIVIDE
  • Using Quick Measures
  • Creating % Ratio and % Change with DAX
  • Working with Charts
  • Optimizing the use of Maps
  • Managing and using imported Power BI Visuals
  • Working with Dynamic Images
  • Adding In-Page Navigation
  • Mobile Layout Design
  • Working with Related Tables
  • Model View and Relationship Management
  • Introduction to Join Types
  • Modelling best practice
  • Merging and Disabling Load

We will briefly introduce you to ChatGPT and its possibilities when using Power BI.

  • ChatGPT vs Bard vs Other AI tools
  • Some of the ways you can use ChatGPT with Power BI
  • A very simple example

As this section is a brief taster, it is not covered in our course materials or post-course support.

This course assumes you already understand the basic of Power BI including measures and creating dashboard. 

It is recommended that you have completed our Power BI Introduction workshop or have equivalent experience before attending this course. It is expected that you will have a working knowledge of Power BI, including Report design techniques and using Measures

Oakley is one of our expert trainers for this course with deep Power BI expertise.

He has 19 years experience training across various Microsoft applications and a very broad foundation in the Microsoft ecosystem as a Microsoft Certified Trainer (MCT). He has specialised in Microsoft Power BI since 2017, making him a veteran of the platform. This specialisation includes training delegates on advanced data modeling, DAX scripting, data visualisation best practices, and Power Platform integration, ensuring that you don’t just learn to use Power BI, but how to be an effective Power BI developer and analyst.

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £995 (+VAT)

  • Easy booking

  • Money back guarantee

  • Post-course support

Book Now
3 Day MS Power BI Training Course: Introduction & Advanced (SAVE £100)

Combined Power BI Course (£100)

CPD Certified
4.8 / 5
3 days.
Client Site Courses Available.
Classroom, Online & Client Site.

Our combined course is the fastest way to learn Microsoft Power BI. Go from complete beginner to expert in 3 days.

Save £100 when you book our Introduction and Advanced Power BI courses at the same time.

Our combined course is the fastest way to learn Microsoft Power BI. Go from complete beginner to expert in 3 days.

Save £100 when you book our Introduction and Advanced Power BI courses at the same time.

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £1390 (+VAT)

  • Easy booking

  • Money back guarantee

  • Post-course support

Book Now
Power BI Training: 1 Day Introduction To DAX Course

Introduction to DAX Course

CPD Certified
4.59 / 5
1 day.
Client Site Courses Available.
Live Online Only.

Start controlling your data with DAX

  • Overview of DAX
  • Using common DAX functions
  • Implementing time intelligence
  • Calculated columns & measures
  • Specifying cross table lookups
  • Filters using tables functions

Start controlling your data with DAX

  • Overview of DAX

  • Using common DAX functions

  • Implementing time intelligence

  • Calculated columns & measures

  • Specifying cross table lookups

  • Filters using tables functions

This one day course covers the following areas:

  1. Overview of the Language
  2. Common DAX Functions
  3. Defining Calculated Columns
  4. Defining Measures
  5. Aggregate Functions
  6. Cross Table Lookups
  7. Evaluation Context in Relationships
  8. Defining Filters with Table Functions
  9. Using Filters with the CALCULATE Function

You do not need any prior experience with DAX to attend this course. 

It is recommended that you are a comfortable Power BI user before attending.

If you already have experience with DAX, it is likely that our advanced course will be most appropriate for you.

He has 19 years experience training a variety of Microsoft applications and has specialised in Microsoft Power BI and DAX since 2017, making him a veteran of the platform. This specialisation allows him to train delegates on advanced data modeling, DAX scripting, data visualisation best practices, and Power Platform integration, ensuring that you don’t just learn to use DAX, but how it is part of being an effective Power BI developer and analyst.

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £495.00 (+VAT)

  • Easy booking

  • Money back guarantee

  • Post-course support

Book Now
Power BI Training: 1 Day Advanced DAX Course

DAX Advanced

CPD Certified
4.64 / 5
1 day.
Client Site Courses Available.
Live Online Only.

Learn to use DAX’s most powerful functions.

  • Using variables
  • Creating a Measures table
  • Time intelligence calculations
  • Working in DAX studio
  • Parameters & What-If scenarios
  • Information Functions

Learn to use DAX’s most powerful functions.

  • Using variables

  • Creating a Measures table

  • Time intelligence calculations

  • Working in DAX studio

  • Parameters & What-If scenarios

  • Information Functions

This one day course covers the following areas:

  1. Creating a Measure Table
  2. Using Variables
  3. Time Intelligence Calculations
  4. DAX as a Query Language: EVALUATE Function
  5. Advanced Table Functions
  6. Advanced Filter Context & Control: Cross Filters, Row Context
  7. Exploring the Evaluation Context with Information Functions
  8. Defining and Using Parameters
  9. Defining and Using What-If scenarios

If time allows, the trainer will briefly introduce you to the possibilities when using Microsoft CoPilot with DAX. This section will not be covered in course materials or post-course support.

This course is for existing users of DAX who want to develop their understanding of DAX.

Before coming on this course, you should have attended our introduction to DAX course or have equivalent Power BI skills.

Oakley is one of our expert trainers for this course with deep Power BI expertise. He has been a Microsoft Certified Trainer for 8 years.

He has 19 years experience training a variety of Microsoft applications and has specialised in Microsoft Power BI and DAX since 2017, making him a veteran of the platform. This specialisation allows him to train delegates on advanced data modeling, DAX scripting, data visualisation best practices, and Power Platform integration, ensuring that you don’t just learn to use DAX, but how it is part of being an effective Power BI developer and analyst.

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £495.00 (+VAT)

  • Easy booking

  • Money back guarantee

  • Post-course support

Book Now
Power BI DAX: Combined Course

DAX Combined Course

CPD Certified
4.89 / 5
2 days.
Client Site Courses Available.
Live Online Only.

Our combined DAX course is the quickest way to become a DAX expert.

Save £100 when you book our Introduction and Advanced DAX courses at the same time.

Our combined DAX course is the quickest way to become a DAX expert.

Save £100 when you book our Introduction and Advanced DAX courses at the same time.

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £890.00 (+VAT)

  • Easy booking

  • Money back guarantee

  • Post-course support

Book Now

Easy booking & payment

Money back guarantee

Post-course support

Power BI Training FAQ

For General FAQs and Booking questions, see our FAQ Page.

Claire Caple – Microsoft 365 Adoption & Change Manager – Rennie Grove Peace

Claire Caple from Rennie Grove Hospital

“Alpesh was very knowledgeable, and I was confident in his training from the start.

He was enthusiastic and excited to help us get to know the software.

Alpesh gave us useful tips, everyone was comfortable and asked questions throughout.

We all took away ideas and felt able to start using Power BI immediately.”

The Client: 

Rennie Grove Peace Hospice (Rennie Grove Peace) is a palliative care and bereavement support charity working in Buckinghamshire and Hertfordshire.

It was formed from the merger of Rennie Grove Hospice Care and Peace Hospice Care in 2022 and employs approximately 300 people across a range of functions spanning from fundraising and training to palliative care.
Rennie Grove Hospital staff taking care of patients

The Problem: 

Rennie Grove Peace wanted to upgrade its business analytics capability and make better use of their data across the organisation.

Having decided that Power BI would be the best solution, team members from their fundraising, marketing, clinical reporting and IT teams wanted to learn how to use Power BI to analyse and present their data. 

The Solution: 

Rennie Grove Peace ultimately decided that a private Power BI course at their offices would meet their needs best.

Doing this was more cost-effective than attending public courses, saved on staff travel time and allowed the training to be focused on their exact requirements.  

The Outcome: 

A private one-day introduction to Power BI course was run at Rennie Grove Peace’s offices.

Everyone left having learned a huge amount about Power BI and ready to start putting it into practice.  

After the course, each attendee was tasked with sharing what they learned with their department to broaden the organisation’s understanding of Power BI.   

Our Power BI introduction training course is for complete beginners, you do not need any previous experience with Power BI to attend.

It is designed for people who will be:

  1. Using complex dashboards and reports which have been prepared by other analysts
  2. Creating simple data visualisations from scratch.
  3. Going on to attend our Advanced course and need to master the basics.

By the end of this course, you will be able to:

  1. Connect to a range of data sources using Power BI
  2. Prepare and transform your data.
  3. Create data visualisations like KPIs and charts.
  4. Publish reports that you have crated via the web or PDF.

This course gives you a high-level overview of Power BI and introduces basic best practices and its drag and drop functionality.

Our advanced training course is for people who are already Power BI users and want to develop their skills further.

It is designed for people who will be creating complex dashboards and reports from scratch.

By the end of this course, you will be able to:

  1. Customise a report.
  2. Use the query editor to interrogate the data in a data model, data relationships and hierarchies.
  3. Build interactivereports like drill-through reports and relative date reports.
  4. Creating a wide variety of compelling visualisations including maps, bullet and scatter charts.
  5. Set security and data permissions, and control when your data is updated.

We provide certificates of completion to everyone who completes one of our Microsoft Power BI programmes.

Our training is not an official PL-300 Microsoft Power BI Data Associate course, however, taken together our courses cover the vast majority of the syllabus and so would work very well for someone working towards that certification.

We have mapped our training in detail against the official Microsoft PL-300 exam syllabus, please contact us if you would like more details.

You do not need to be an advanced Power BI user to attend our introduction to DAX course.

The pre-requisite to attend is that you are comfortable using Power BI and understand it to at least the level that you would if you had attended our Introduction course.

This course covers creating basic DAX formulas using M langugage.

Power BI is Microsoft’s data analytics and business intelligence platform.

It allows you to connect to hundreds of data sources, prepare data, and create beautiful, interactive reports and dashboards converting raw data into easily actionable insights.

It was launched in 2014 and its main competitors are data tools like Tableau, Google Data Studio and Qlik.

It comes in a range of versions from Power BI Desktop which is free through to Power BI Premium which is a full enterprise business intelligence solution hosted in the cloud.

Microsoft Excel is widely used as a general purpose tool for all sorts of calculations and simple data management.

Power BI is a business intelligence platform designed specifically for data analytics and visualisation for large volumes of data which Excel could not handle. It allows users to very quickly and simply share data and business insights across their organisation.

Power BI Desktop:

Power BI Desktop (free) gives you access to Power BI’s basic features and is where you create data models and carry out data cleansing and analysis. It is also how you access the full cloud-based version of Power BI – Power BI Service – if you are a subscriber.

Power BI Pro:

Power BI is the full version of Power BI. It includes the ability to build and share dashboards and reports that you have built which you can’t with BI Desktop.

Power BI Service or Premium:

Power BI Service is designed for large organisations. It gives your company access to its own dedicated capacity and allows for analysis of very large scale datasets.

Power BI toolkit is comprised of several key components:

1. Power Query: A data extraction and transformation tool used to connect to, clean, and shape data in Power BI Desktop.
2. Power Pivot: An in-memory data modeling component that allows for the creation of relationships between data tables.
3. Power BI Desktop: A free tool for building for analysing your data, building data models and designing reports.
4. Power BI Service: A cloud-based service for publishing, sharing (inc via mobile app) and collaborating on reports and dashboards.
5. DAX (Data Analysis Expressions): A formula language with a library of functions and operators. It allows you to create custom calculations, measures and calculated columns, and usee complex logic to derive deeper insights.

Power BI can connect to a wide variety of data sources, including Microsoft Fabric, Excel files, SQL Server databases, SharePoint lists, and online services like Google Analytics and Salesforce allowing you to bring all your data together in one place.

A Power BI report is a multi-page collection of visualisations and data created from a single dataset.

A dashboard is a single-page interface that provides a high-level overview of key metrics, with visualisations, drawn from multiple reports.

Where Do You Run Your Microsoft Power BI Training?

London Training Venue & Course Details

44 Southampton Buildings
London, WC2A 1AP
Tel: 0203 603 0150

See the full London location details here.

Guildford Training Venue & Course Details

Surrey Technology Centre, 40 Occam Road
Guildford, GU2 7YG
Tel: 01483 688 488

See the full Guildford location details here.

Online Courses

What Previous Delegates Say About Our Power BI Courses

Getting To Know You

It is very helpful for us to know which areas of the course are most important to you when planning your course.

Tell Us What You Are Looking To Get From Your Course ->