Specialist - Power BI

Power BI Training

Power BI Training UK – Master Data Visualisation & Business Intelligence Online or On-Site

Unlock the full potential of your data with our expert-led Microsoft Power BI training courses – delivered online or at your location across the UK.

Whether you’re a beginner or an experienced analyst, our Power BI training empowers professionals to transform raw data into actionable insights using interactive dashboards, advanced DAX formulas, and real-time reporting tools.

Why Choose Our Power BI Training?

Hands-on, instructor-led courses tailored to your business goals

Flexible delivery: Online via Teams/Zoom or on-site UK-wide

Customised corporate training for teams across finance, HR, sales, marketing, and more

Microsoft Certified Trainers with real-world experience

Trusted provider of Power Platform and Office training

 What You’ll Learn

Connect to diverse data sources and clean data using Power Query

Build dynamic dashboards and business reports with Power BI Desktop

Apply DAX for advanced data modelling and calculations

Share insights securely across your organisation with Power BI Service

Make smarter decisions with real-time analytics and visual storytelling

Who Should Attend?

Business analysts, data professionals, Excel power users

Teams seeking to improve data literacy and reporting capabilities

Organisations integrating Power BI with Excel, SharePoint, or other Microsoft tools

Course Options

Power BI for Beginners – foundational skills for new users

Advanced Power BI Training – deep dive into DAX, performance, and AI features

PL-300T00 Microsoft Power BI Data Analyst – full lifecycle analytics training [PL-300T00…ta Analyst]

Two-Day Introduction to Power BI – practical skills for report creation and dashboard design [Two-day In…se content]

Delivery Formats

Online Power BI Training – live sessions via Microsoft Teams or Zoom

On-Site Training – delivered at your premises across London, Manchester, Birmingham, and beyond

Small group sessions – ideal for teams (1–6 online, up to 8 on-site)

What Makes Us Different?

Real-world exercises and labs for practical learning

Custom training materials aligned with your data and industry

Flexible scheduling and cancellation terms

Please select the version that you’re interested in

Please select the level that you’re interested in

Power BI Desktop Introduction

Course Overview

Audience:

This course will benefit those who analyse data and create reports. Getting data from different sources and producing dashboards and reports.

Prerequisite:

Learners should have Intermediate/advanced level of knowledge of Microsoft Excel including knowledge of Pivot Table.

Duration:

This is a two day Power BI Course. The course starts at 09:30 and runs until 16:30. 
Alternate timings can be arranged upon request. The course can be held on a date that suits you.

Location:

Our Power BI course can be delivered virtually using online training platforms such as MS Teams or Zoom or face-to-face at any preferred location in the UK, Europe or ROW.

Power BI Desktop Introduction Course Outline

WHAT IS POWER BI?

Power Query

The Data Model/Power Pivot

Rich interactive visualisations

Power BI Desktop and Power BI Service

THE POWER BI DESKTOP INTERFACE

Different Views

Visualisation and Fields pane

Power BI Desktop Options

GETTING DATA INTO POWER BI

From Text Files

From CSV files

From Web

From Folder

From Excel ranges and sheets

UNDERSTANDING POWER QUERY

Understanding the Power Query interface

Renaming and deleting steps

Cleaning messy data example

Refreshing a query

Power Query Options

COMMON POWER QUERY FEATURES

Unpivot Columns

Setting Data Types

Append Queries

Merge Queries

CREATING THE DATA MODEL

Create table relationships

Edit and delete relationships

Understand filter context

Tables & Columns – Understanding basic
data structure.

Data View – Seeing your underlying
data values

Exploring Data – Easy data profiling

Managing Schema & Data Changes –
Dealing with issues of change control

Connections & Tables – Data lineage.

Data Refresh – Optimising new data acquisition.

Relating Tables – Telling Power BI how your data relates internally.

Rules & Limitations – Filter flow options and consequences.

Auto-Detecting – Pros and cons of saving design time

Relationship View – Working on your data model structure

GETTING STARTED WITH DAX

How is DAX different to Excel Formulas

Calculated Columns vs Measures

Creating a Calculated Column

Creating Measures

Using Common DAX Functions

LOOKUP AND FILTER DAX FUNCTIONS

Why these functions are useful?

RELATED Function

CALCUALTE Function

FILTER Function

INTERACTIVE VISUALISATIONS

Adding tiles to a Report

Creating Charts

Using Geographic Data

Creating Matrixes

Using Slicers

Other Filter tools (Report, Pages,
Visualisations)

Editing Interactions

Highlight vs Filter

Formatting Visualisations

Drill Down

POWER BI SERVICE

Publishing your Report

Mobile Layout

Reports and Dashboards

Bookmarks

Understanding Gateways

Refreshing your Reports

Show more
One to One

(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training

Group for up to 8 learners
The Course outlines on our website are standard, however, we would be happy to tailor them to your specific requirements. Please call us on 020 3696 2796 or send us a message to discuss further.

What Our Clients Say

Extras

This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.