Skip to main content

Power BI Business Analytics Course

Turn raw data into clear, interactive dashboards and reports with Power BI.

A two-day practical course covering data connections, visualisations, DAX and Power Query.

Turn raw data into clear, interactive dashboards and reports with Power BI. A two-day practical course covering data connections, visualisations, DAX and Power Query.

234 Reviews
9.6/10 Satisfaction
99.1% Recommend
See reviews
Power BI Business Analytics training course

Power BI Business Analytics Course

Turn raw data into clear, interactive dashboards and reports with Power BI on this two-day practical course.

You'll learn how to navigate the Power BI interface, connect to and import data from Excel, CSV and other sources, use Power Query to clean and transform data, create calculated measures using DAX, build interactive visualisations including charts, tables and maps, design dashboard layouts with slicers and filters, and share and publish your reports.

Suitable for business professionals, analysts and anyone who works with data.

View course outline

Course Dates

Course Dates Days Location Places RRP Discount You Pay
1-2nd Oct 26 Thu-Fri Online Available £699.00 £100.00 £599.00 + VAT
17-18th Dec 26 Thu-Fri Online Available £699.00 £699.00 + VAT
2-3rd Feb 27 Tue-Wed Online Available £699.00 £699.00 + VAT
1-2nd Apr 27 Thu-Fri Online Available £699.00 £699.00 + VAT
27-28th May 27 Thu-Fri Online Available £699.00 £699.00 + VAT
19-20th Jul 27 Mon-Tue Online Available £699.00 £699.00 + VAT
No in-person dates available at the moment.
No in-person dates available at the moment.
Course Dates Days Location Places RRP Discount You Pay
1-2nd Oct 26 Thu-Fri Online Available £699.00 £100.00 £599.00 + VAT
17-18th Dec 26 Thu-Fri Online Available £699.00 £699.00 + VAT
2-3rd Feb 27 Tue-Wed Online Available £699.00 £699.00 + VAT
1-2nd Apr 27 Thu-Fri Online Available £699.00 £699.00 + VAT
27-28th May 27 Thu-Fri Online Available £699.00 £699.00 + VAT
19-20th Jul 27 Mon-Tue Online Available £699.00 £699.00 + VAT

Private & team training

Request a quote for Power BI : Business Analytics

Available as private, bespoke or team training at our centre, live online, or at your venue. Customise the outline, train as a group, or book a one-to-one with an expert.

Course dates

Swipe for more dates

1-2nd Oct 26

Thu-Fri

Location
Online
Places
Available
RRP
£699.00
Discount
£100.00
You pay
£599.00 + VAT

17-18th Dec 26

Thu-Fri

Location
Online
Places
Available
RRP
£699.00
Discount
You pay
£699.00 + VAT

2-3rd Feb 27

Tue-Wed

Location
Online
Places
Available
RRP
£699.00
Discount
You pay
£699.00 + VAT

1-2nd Apr 27

Thu-Fri

Location
Online
Places
Available
RRP
£699.00
Discount
You pay
£699.00 + VAT

27-28th May 27

Thu-Fri

Location
Online
Places
Available
RRP
£699.00
Discount
You pay
£699.00 + VAT

19-20th Jul 27

Mon-Tue

Location
Online
Places
Available
RRP
£699.00
Discount
You pay
£699.00 + VAT

Course Outline

1

1. Introduction to Power BI Desktop

Understanding the Power BI ecosystem and where Power BI Desktop fits

Navigating the Power BI interface, ribbons, and panes

Creating and saving your first Power BI Desktop report

Best practices for file management (.pbix files) and version control

Trying out Preview features

2

2. Connecting to Local and File-Based Data Sources

Importing and connecting to Excel, CSV, and text files

Working with folder connections for batch imports

Introduction to basic database connections (SQL Server, Access, etc.)

Overview of DirectQuery vs Import – when to use each

Using Power Query Editor to clean, merge, and shape data

3

3. Preparing and Transforming Data

Understanding data types, properties, and relationships

Applying filters, transforms, pivot, unpivot, and group by

Creating custom and conditional columns

Using data profiling tools (Column Quality, Distribution, and Profile)

Introduction to M language basics in Power Query for automation

4

4. Building Effective Visualisations

Choosing the right chart type for your analysis

Working with tables, matrices, bar, line, pie, and combo charts

Adding cards, KPIs, and gauges for key metrics

Using conditional formatting to highlight insights

Building interactive visuals with slicers, drill-through, and drill-down

Creating simple hierarchies and grouping for summarised views

5

5. Enhancing and Customising Reports

Designing clear and accessible dashboards in Power BI Desktop

Adding bookmarks and navigation buttons for interactivity

Using the Selection Pane and Sync Slicers

Building Geo-data visualisations with built-in Maps (no cloud dependency)

Enhancing reports with consistent themes, colours, and templates

Tips for storytelling with data and effective layout design

6

6. Introduction to DAX (Data Analysis Expressions)

Understanding the difference between calculated columns and measures

Using core DAX functions: SUM, AVERAGE, COUNTROWS, CALCULATE, FILTER

Building simple time-intelligence measures (YTD, MTD, growth rates)

Using RELATED and RELATEDTABLE for relational data

Troubleshooting and managing DAX formula errors

7

7. Sharing and Exporting Reports

Exporting data and visuals to Excel, PDF, and PowerPoint

Printing and distributing static reports from Power BI Desktop

Creating user roles and activating Row Level Security

Understanding options for publishing with a free license

Saving Power BI templates for reuse and consistency

Who is this course for?

For business analysts, finance professionals, marketers and managers who need to turn data into interactive dashboards. Requires intermediate Excel knowledge or our Excel Intermediate course.

234 Reviews
9.6/10 Satisfaction
99.1% Recommend

Explaining and providing details of each process

Himayat – 18th June 26

Tom was amazing, made it easy and clear to follow and understand.

Steve – 18th June 26

Great at interacting with the class/group and keeping things relevant and interesting

Annabel – 23rd April 26

The Power BI Business Analytics course was excellently delivered, with consistently engaging and meaningful interaction throughout the sess…

Vivienne – 23rd April 26

Claire was an excellent trainer, she was very thorough, clear, and patient. She had a lot of knowledge and made the course very engaging an…

Fatemeh – 20th January 26

I cannot fault anything!! It was an amazing course, an amazing venue. Claire is a great instructor and I learnt so much in these 2 days! Ca…

Leah – 17th December 25

The course was very useful to understand data visualisation and transformation. Claire was excellent at explaining complex concepts and bre…

Jamie – 12th December 25

Explaining the logic behind the functions.

Misael – 5th November 25

Swipe for more

Read course reviews

Who attends?

Career Progressives icon

Career Progressives

Professionals who wish to develop skills for their current role and companies who believe in developing their talent.

Career Changers icon

Career Changers

People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.

Graduates icon

Graduates

Certified courses for those who have earned their theoretical stripes, but need to prove capability to future employers.

Further Reading

How Learning Power BI can help your Career  article image

How Learning Power BI can help your Career

Power BI is one of the most in-demand data skills in business.

Why You Should Learn Microsoft Power BI? article image

Why You Should Learn Microsoft Power BI?

Microsoft Power BI turns raw data into clear, actionable insights.

Ways To Make Your PowerPoint Presentation Stand Out article image

Ways To Make Your PowerPoint Presentation Stand Out

Looking to impress your audience with amazing Powerpoint design presentation skills?