Regular Price: £320 Batch Price: From £280 📅 View Dates & Prices Group Booking Discount: From £160 per person 🧮 Calculate & Book 1-to-1 Training: £320 📋 Booking Request Form Course Overview This instructor-led Power BI Intermediate to Advanced course is designed for learners who already have a foundational understanding of Power BI and want to develop more advanced skills in data modelling, transformation, DAX, analytics, report design and deployment. Participants will learn how to design efficient semantic models, perform advanced transformations with Power Query, understand DAX evaluation contexts, create advanced calculations and time intelligence measures, improve report interactivity and performance, and publish secure Power BI solutions. The course combines practical techniques with real-world examples that can be applied across a wide range of industries and organisations. Course Objectives By the end of the course, students will be able to: Design efficient semantic models using fact and dimension tables Work with star and snowflake schemas and manage advanced relationships Perform advanced data transformations using Power Query, including M language fundamentals Understand row context, filter context and context transition in DAX Write advanced DAX measures using CALCULATE, iterators, variables and filter functions Work with inactive relationships using USERELATIONSHIP Create time intelligence calculations including YTD, previous-year and year-over-year analysis Build interactive reports using drillthrough, tooltips, bookmarks and conditional formatting Analyse and improve Power BI report performance Publish reports, configure refresh and implement Row-Level Security in Power BI Service Requirements Basic Power BI knowledge Installed latest version of Power BI Desktop Optional: Power BI Service account for deployment practice We highly recommend you complete the following course(s) before attending the Power BI Intermediate to Advanced course: Microsoft Power BI for Beginners You may also complete the following course(s) before attending the Power BI Intermediate to Advanced course but they are not mandatory: SQL for Beginners Course Content Advanced Data Modelling & Relationships Understanding fact and dimension tables Understanding the grain of a fact table Star and snowflake schema design Relationship cardinality and filter direction Active and inactive relationships Role-playing dimensions Introduction to many-to-many relationships Model organisation and best practices Advanced Power Query & Data Transformation Advanced data cleaning and transformation techniques Creating custom and conditional columns Introduction to the M language Merging queries Appending queries Handling errors, missing values and nulls Using query parameters Introduction to query folding and Power Query performance Advanced DAX & Context Measures vs calculated columns Understanding row context and filter context Using CALCULATE and understanding context transition Modifying filter context using REMOVEFILTERS and related functions Using iterator functions such as SUMX Ranking data using RANKX Using variables with VAR and RETURN Working with inactive relationships using USERELATIONSHIP DAX readability and performance best practices Time Intelligence & Advanced Analysis Preparing and using a dedicated Date table Creating year-to-date calculations Comparing results with previous periods and previous years Calculating year-over-year growth Creating running totals and cumulative calculations Performing period comparisons using DATEADD Combining time intelligence with other DAX measures Advanced Reporting & Performance Creating drillthrough pages Creating report page tooltips Using bookmarks, buttons and report navigation Applying advanced conditional formatting Using Performance Analyzer Identifying inefficient visuals, calculations and model elements Report and model performance best practices Power BI Service, Security & Deployment Publishing reports to Power BI Service Understanding and using workspaces Sharing and distributing reports Configuring scheduled refresh and understanding data gateways Creating, managing and testing Row-Level Security (RLS) Power BI deployment best practices Course Dates, Prices & Enrolment All Training Physical Classes Virtual Classes UTC British Time (UK, Ireland, Iceland) Central European Time (France, Germany, Sweden) Eastern European Time (Finland, Cyprus) Eastern Time (New York, Toronto, Montreal) Central Time (Chicago, Houston, Winnipeg) Mountain Time (Calgary, Denver, Edmonton) Mountain Time (Phoenix) Pacific Time (Los Angeles, Seattle, Vancouver) Singapore Time Arabic Standard Time (Qatar, Saudi Arabia) Gulf Standard Time (UAE, Oman) Australian Eastern Time (Sydney, Melbourne) Australian Central Time (Adelaide) Western Australia Time (Perth) New Zealand Time China Standard Time (China, Taiwan, Hong Kong) Scroll right for more details Online Training using Zoom 12 Oct 2026 - 21 Oct 2026 Mon & Wed (2 wks) 03:00 PM - 05:00 PM BT £280 £320 Enrol Now Classroom Training 26 Oct 2026 - 27 Oct 2026 Monday to Tuesday 10:00 AM - 02:00 PM BT £320 Enrol Now Online Training using Zoom 01 Nov 2026 - 22 Nov 2026 4 Sundays 03:00 PM - 05:00 PM BT £280 £320 Enrol Now Online Training using Zoom 09 Nov 2026 - 18 Nov 2026 Mon & Wed (2 wks) 03:00 PM - 05:30 PM BT £280 £320 Enrol Now Classroom Training 23 Nov 2026 - 24 Nov 2026 Monday to Tuesday 10:00 AM - 02:00 PM BT £320 Enrol Now Online Training using Zoom 23 Nov 2026 - 25 Nov 2026 Monday & Wednesday 10:00 AM - 02:00 PM BT £320 Enrol Now Online Training using Zoom 29 Nov 2026 - 20 Dec 2026 4 Sundays 03:00 PM - 05:00 PM BT £280 £320 Enrol Now Online Training using Zoom 07 Dec 2026 - 16 Dec 2026 Mon & Wed (2 wks) 03:00 PM - 05:00 PM BT £280 £320 Enrol Now Classroom Training 17 Dec 2026 - 18 Dec 2026 Thursday to Friday 10:00 AM - 02:00 PM BT £320 Enrol Now Online Training using Zoom 18 Jan 2027 - 27 Jan 2027 Mon & Wed (2 wks) 03:00 PM - 05:00 PM BT £280 £320 Enrol Now Classroom Training 22 Jan 2027 - 22 Jan 2027 Thursday to Friday 10:00 AM - 02:00 PM BT £320 Enrol Now Online Training using Zoom 30 Jan 2027 - 07 Feb 2027 2 Saturdays & 2 Sundays 03:00 PM - 05:00 PM BT £280 £320 Enrol Now Online Training using Zoom 15 Feb 2027 - 26 Feb 2027 Mon & Fri (2 wks) 03:00 PM - 05:00 PM BT £280 £320 Enrol Now Classroom Training 18 Feb 2027 - 19 Feb 2027 Thursday to Friday 10:00 AM - 02:00 PM BT £320 Enrol Now Online Training using Zoom 20 Feb 2027 - 28 Feb 2027 2 Saturdays & 2 Sundays 03:00 PM - 05:00 PM BT £280 £320 Enrol Now Price Calculator & Booking Request Form Calculate prices for Corporate, 1-on-1 or group training and request a booking. Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to: book a course on different dates book for a group of delegates book corporate training book a customised training book a one-on-one training The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below: How many hours? How many people? Total Cost Price per person Preferred Dates and Times Any other information
07 June 2025 5 Reasons Why Power BI is a Game-Changer for Data Analysis In today’s data-driven world, professionals across industries are expected to interpret and communicate data effectively. Whether you're a business analyst, a marketer, or a student preparing for a tech-savvy career, knowing how to extract insights from data is essential, and Power BI makes it easier than ever. Learn five reasons why Power BI is transforming the way we analyse and present data.
16 February 2026 Connecting Power BI to the Modern Cloud Data Stack for Real-Time Insights This article provides a technical overview of how Power BI integrates with cloud data warehouses to overcome the limitations of traditional reporting. It explains the benefits of DirectQuery, push-down processing, and centralised security for maintaining a high-performance, governed data environment.
07 August 2024 What can we do with Power BI? Power BI is a powerful data visualization and business intelligence tool developed by Microsoft. It offers a wide range of functionalities to help organizations analyze data, share insights, and make data-driven decisions.