Power BI - Visualise and Report 14th July 2026

A practical guide to using Desktop Power BI app to manipulate large data sets using DAX formulas, measures and calculated columns in Power Query.

Once data is in the correct format we will create Relationships to join tables from different sources and use this data to create interactive visualisations which may be published to the web and shared with colleagues.

Prepare Reports for import

Import files

Importing text files

Creating DAX formulas

=RELATED

Calculated columns

Fields for slicers

Creating Measures

Visualisations

Using Slicers to view data

To enrol on this course, delegates must either have completed our Excel Levels 1-4 training or demonstrate equivalent proficiency. This course builds on advanced Excel foundations, and assumes a high level of day-to-day use. It is specifically designed for professionals whose roles demand regular, in-depth use of Excel, and who are looking to apply power user techniques to enhance productivity, streamline complex tasks, and unlock greater value from Excel’s advanced features. If you're not confident in your current Excel capabilities at an advanced level, we recommend completing the earlier courses first to ensure you gain the most from this training.

Venue: Enjoy expert-led training live online via Microsoft Teams, delivered by a qualified Microsoft Certified Trainer. Join from home, office or desk—no travel, no extra cost, no wasted time. You receive full access to a video recording of your session, so you can revisit every tip and technique.