Specialist - Power BI

Power BI Training

Unlock the Power of Your Data with Power BI Training – Online or On-Site


Microsoft Power BI is a game-changing business intelligence tool that enables users to connect, visualise, and analyse data from multiple sources—bringing it all together in one place. With our expert-led Power BI training courses, you’ll learn how to create immersive, interactive dashboards and insightful reports that drive real business decisions.


Our Power BI training is ideal for professionals, analysts, and teams looking to master data storytelling, enhance data visualisation skills, and turn raw data into actionable insights. Whether you’re new to Power BI or want to expand your knowledge, we offer Power BI for beginnersadvanced Power BI training, and customised corporate training solutions.


Learn how to:

  • Connect to multiple data sources with Power BI
  • Create stunning, interactive dashboards and business reports
  • Use Power BI DAX formulas for powerful data modelling
  • Share insights across your organisation with real-time collaboration
  • Make smarter, faster decisions with up-to-the-minute business intelligence


We deliver Microsoft Power BI training both online and at client sites across the UK, making it easy for individuals and businesses to learn in the format that suits them best. Our hands-on, instructor-led courses ensure you not only learn Power BI features but also how to apply them effectively in your day-to-day work.


 – Trainer-led online Power BI courses with expert trainers
 – On-site Power BI training delivered at your business location
 – Custom Microsoft training tailored to your data and goals
 – Suitable for all industries – finance, sales, marketing, HR, and more
 – Trusted provider of Microsoft Office and Power Platform training


Whether you’re building dashboards from scratch or integrating Power BI with Excel, SharePoint, or other Microsoft tools, our training helps you build confidence and skills that make a difference.


Get in touch today to discover how our Power BI training solutions can help you and your team make smarter decisions—faster.

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 run at our training venue near Liverpool Street (London) or any preferred location in the UK or Europe.

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.