Microsoft - Power BI

Power BI Training

Power BI Training for Teams – Simple, Practical & Designed for Real‑World Work

If your organisation is dealing with growing amounts of data—and your teams need a smarter, easier way to make sense of it—Power BI training is one of the quickest wins you can offer.

Our courses help your staff turn messy spreadsheets and huge datasets into clean, interactive dashboards that anyone in the business can understand. No jargon, no complicated setup—just practical, hands‑on learning that builds confidence fast.

Whether you’re supporting beginners, growing data‑curious teams, or developing in‑house data champions, we’ve got training options that fit every level.

Why L&D and HR Teams Choose Our Power BI Training

Easy to fit around your schedules – online or on‑site anywhere in the UK

Hands-on learning that boosts skills immediately

Great for all levels – from complete beginners to advanced analysts

Aligned to your business goals so training feels relevant from day one

Delivered by real Microsoft experts who keep things practical, not technical

Ideal for departments dealing with heavy reporting: Finance, HR, Operations, Sales, Service, and more

What Your Teams Will Learn

Our training focuses on real work—not theory. Staff learn how to:

Connect to all kinds of data sources

Clean and transform data effortlessly using Power Query

Build interactive, visual dashboards that tell a clear story

Use DAX for deeper analysis (for those who want to level up)

Share reports securely across the organisation

Make faster, smarter decisions backed by real-time insights

Power BI is designed to handle large volumes of data, and we show your teams how to turn that into meaningful, easy‑to‑read visuals they can use every day.

Who This Training Is Ideal For

Perfect for teams who need to improve reporting, understand their data better, or reduce time spent on manual Excel work:

HR & L&D teams wanting better workforce insights

Finance departments buried in spreadsheets

Operations, sales, and service teams needing better dashboards

Excel power users ready to take the next step

Anyone who wants to feel more confident with data

Course Options for Your Organisation

Introduction to Power BI – for staff who are new to data visualisation

Advanced Power BI – for those ready to dive into DAX, optimisation, and deeper analysis

PL‑300 Data Analyst Certification Training – for employees building professional capability

Two‑Day Power BI Essentials – quick, practical skills for dashboards and reporting

Flexible Delivery Options

Live online training via Teams or Zoom

On‑site sessions at your office (London, Manchester, Birmingham, and anywhere UK‑wide)

Small group formats ideal for team learning and personalised support

Why We’re Different

We use your data and real business scenarios where possible

Learning is practical, engaging, and accessible for all levels

Teams walk away with skills they can use immediately

Training can be tailored to department needs or business goals

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.