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.

236 Reviews
9.6/10 Satisfaction
99.2% 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
2 to 3 February 2027 Tue-Wed Online Available £699 £100 £599 + VAT
1 to 2 April 2027 Thu-Fri Online Available £699 £699 + VAT
27 to 28 May 2027 Thu-Fri Online Available £699 £699 + VAT
19 to 20 July 2027 Mon-Tue Online Available £699 £699 + VAT
23 to 24 September 2027 Thu-Fri Online Available £699 £699 + 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
2 to 3 February 2027 Tue-Wed Online Available £699 £100 £599 + VAT
1 to 2 April 2027 Thu-Fri Online Available £699 £699 + VAT
27 to 28 May 2027 Thu-Fri Online Available £699 £699 + VAT
19 to 20 July 2027 Mon-Tue Online Available £699 £699 + VAT
23 to 24 September 2027 Thu-Fri Online Available £699 £699 + VAT

Private & team training

Get 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

2 to 3 February 2027

Tue-Wed

Location
Online
Places
Available
RRP
£699
Discount
£100
You pay
£599 + VAT

1 to 2 April 2027

Thu-Fri

Location
Online
Places
Available
RRP
£699
Discount
—
You pay
£699 + VAT

27 to 28 May 2027

Thu-Fri

Location
Online
Places
Available
RRP
£699
Discount
—
You pay
£699 + VAT

19 to 20 July 2027

Mon-Tue

Location
Online
Places
Available
RRP
£699
Discount
—
You pay
£699 + VAT

23 to 24 September 2027

Thu-Fri

Location
Online
Places
Available
RRP
£699
Discount
—
You pay
£699 + 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.

236 Reviews
9.6/10 Satisfaction
99.2% Recommend

Excellent explanation of processes. Well organised with files and meeting links sent prior to course. Breaks were well timed.

Jesika – 1 October 2026

Explaining and providing details of each process

Himayat – 18 June 2026

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

Steve – 18 June 2026

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

Annabel – 23 April 2026

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

Vivienne – 23 April 2026

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 – 20 January 2026

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 – 17 December 2025

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

Jamie – 12 December 2025

Swipe for more

Read course reviews

Who attends?

Getting better at your job icon

Getting better at your job

You need a skill for the role you already have, or your employer is investing in the team.

Changing career icon

Changing career

You're moving into a new field and need the practical skills it asks for.

Just graduated icon

Just graduated

You know the theory. A practical course and a certificate of attendance show employers you can do the work.

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?