1-2nd Oct 26
Thu-Fri
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 | |
|---|---|---|---|---|---|---|---|
| 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 |
| 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
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
Thu-Fri
Thu-Fri
Tue-Wed
Thu-Fri
Thu-Fri
Mon-Tue
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.
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…
Explaining the logic behind the functions.
Swipe for more
Read course reviews
Professionals who wish to develop skills for their current role and companies who believe in developing their talent.
People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.
Certified courses for those who have earned their theoretical stripes, but need to prove capability to future employers.
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?