2 to 3 February 2027
Tue-Wed
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.
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.
| 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 |
| 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
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.
Swipe for more dates
Tue-Wed
Thu-Fri
Thu-Fri
Mon-Tue
Thu-Fri
Private & team training
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.
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
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
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
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
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
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
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
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.
Excellent explanation of processes. Well organised with files and meeting links sent prior to course. Breaks were well timed.
Explaining and providing details of each process
Tom was amazing, made it easy and clear to follow and understand.
Great at interacting with the class/group and keeping things relevant and interesting
The Power BI Business Analytics course was excellently delivered, with consistently engaging and meaningful interaction throughout the sess…
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…
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…
The course was very useful to understand data visualisation and transformation. Claire was excellent at explaining complex concepts and bre…
Swipe for more
Read course reviews
You need a skill for the role you already have, or your employer is investing in the team.
You're moving into a new field and need the practical skills it asks for.
You know the theory. A practical course and a certificate of attendance show employers you can do the work.
Power BI is one of the most in-demand data skills in business.
Microsoft Power BI turns raw data into clear, actionable insights.
Looking to impress your audience with amazing Powerpoint design presentation skills?