• 0208 432 6218
  • WhatsApp
  • Register

Power BI Intermediate to Advanced

An Intermediate to Advanced level 6-hour course delivered via Instructor Led Online and Classroom Training.

View Dates
Regular Price: £210
Batch Price: From £150   📅  View Dates & Prices

Course Overview

This instructor-led training course is designed for learners who have a foundational understanding of Power BI and are ready to elevate their skills in data modelling, analytics, and performance optimisation. Participants will explore advanced topics such as efficient data schema design, managing complex relationships, writing sophisticated DAX formulas for time intelligence and context control, and performing powerful data transformations using the M language in Power Query. This course equips participants with the expertise to build highly interactive, efficient, and insightful Power BI solutions for real-world business scenarios.

Course Objects

By the end of the course, students will:

  • Model complex data using star/snowflake schemas efficiently
  • Write powerful DAX expressions including context transition and time intelligence
  • Perform advanced data transformations using the M language
  • Optimise data models and reports for high performance
  • Use forecasting and Python integration for predictive analytics
  • Enhance reports with advanced visuals and conditional formatting

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:

You may also complete the following course(s) before attending the Power BI Intermediate to Advanced course but they are not mandatory:

Course Content

  1. Advanced Data Modelling & Relationships
    • Star & Snowflake schema design
    • Many-to-many relationships
    • Role-playing dimensions (e.g., multiple date fields)
    • Managing model performance with calculated tables vs. relationships
    • Managing relationships with DAX (e.g., USERELATIONSHIP)
  2. Advanced DAX for Data Analysis
    • Understanding row context vs. filter context
    • Time intelligence functions: SAMEPERIODLASTYEAR, DATESYTD, PARALLELPERIOD
    • Iterator functions: SUMX, AVERAGEX, RANKX
    • Context transition and CALCULATE()
    • Debugging and optimizing DAX
  3. Power Query – Advanced Data Transformation
    • Custom columns using M
    • Merging & appending queries
    • Conditional transformations
    • Handling errors and nulls
    • Parameterizing queries
    • Using functions in Power Query
  4. Advanced Visualisations & UX Design
    • KPI visualizations and custom visuals
    • Bookmarks & buttons for storytelling
    • Drillthrough and tooltip pages
    • Conditional formatting and dynamic visuals
    • Grouping, binning, and segmentation visuals
  5. Performance Optimization & Best Practices
    • Query diagnostics and performance analyzer
    • Reducing model size with summarization
    • Avoiding cardinality issues
    • Using variables in DAX for clarity and performance
  6. Power BI Service & Deployment
    • Publishing to Power BI Service
    • Workspaces and sharing reports
    • Data refresh and scheduled refresh
    • Creating and managing dashboards
    • Row-Level Security (RLS) setup
    • Introduction to Power BI Mobile
Materials Provided
  • Practice datasets
  • Power BI templates and DAX/M cheat sheets
  • Slides and post-course exercise

Course Dates, Prices & Enrolment

All Training Physical Classes Virtual Classes
Scroll right for more details
Delivery MethodDates & TimesHoursPriceEnrolment
Online Training using Zoom
04 May 2026 - 08 May 2026
Mon, Wed & Fri
03:00 PM - 05:00 PM BT
6-hour over 3-day
£150 £210
Enrol Now
Online Training using Zoom
07 May 2026 - 08 May 2026
Thursday & Friday
03:00 PM - 06:00 PM BT
6-hour over 2-day
£150 £210
Enrol Now
Online Training using Zoom
09 May 2026 - 10 May 2026
Saturday to Sunday
04:00 PM - 07:00 PM BT
6-hour over 2-day
£210
Enrol Now
Online Training using Zoom
18 May 2026 - 22 May 2026
Mon, Wed & Fri
03:00 PM - 05:00 PM BT
6-hour over 3-day
£210
Enrol Now
Online Training using Zoom
06 Jun 2026 - 07 Jun 2026
Saturday to Sunday
04:00 PM - 07:00 PM BT
6-hour over 2-day
£210
Enrol Now
Classroom Training
16 Jun 2026 - 18 Jun 2026
Tuesday & Thursday
10:00 AM - 01:00 PM BT
6-hour over 2-day
£210
Enrol Now
Online Training using Zoom
22 Jun 2026 - 26 Jun 2026
Mon, Wed & Fri
03:00 PM - 05:00 PM BT
6-hour over 3-day
£210
Enrol Now
Online Training using Zoom
04 Jul 2026 - 05 Jul 2026
Saturday to Sunday
04:00 PM - 07:00 PM BT
6-hour over 2-day
£210
Enrol Now
Classroom Training
10 Jul 2026 - 10 Jul 2026
Friday
10:00 AM - 04:00 PM BT
6-hour over 1-day
£210
Enrol Now
Online Training using Zoom
01 Aug 2026 - 02 Aug 2026
Saturday to Sunday
04:00 PM - 07:00 PM BT
6-hour over 2-day
£210
Enrol Now
Online Training using Zoom
24 Aug 2026 - 28 Aug 2026
Mon, Wed & Fri
03:00 PM - 05:00 PM BT
6-hour over 3-day
£210
Enrol Now
Classroom Training
25 Aug 2026 - 27 Aug 2026
Tuesday & Thursday
10:00 AM - 01:00 PM BT
6-hour over 2-day
£210
Enrol Now
Online Training using Zoom
29 Aug 2026 - 30 Aug 2026
Saturday to Sunday
04:00 PM - 07:00 PM BT
6-hour over 2-day
£210
Enrol Now
Classroom Training
11 Sep 2026 - 11 Sep 2026
Friday
10:00 AM - 04:00 PM BT
6-hour over 1-day
£210
Enrol Now

Related Posts

×

Popular Courses

Useful Links

Share this page now!

What we do?

At London Academy of IT, we provide instructor-led online and in-person IT training in Data Analytics, SQL, Python, Power BI, and more. Our cutting-edge courses are designed to boost performance and enhance employability, providing the competitive edge employers look for.

Our Contacts

London Academy of IT
64 Broadway
Stratford
London E15 1NT
United Kingdom

Call us: +44 (0)208 432 6218
WhatsApp: +44 0749 461 6045

Chat with London Academy of IT on WhatsApp

Regional Training

USA | UAE | Ireland

2012 - 2026 © London Academy of IT Limited. All Rights Reserved.
UKPRN: 10045491. Registered in England & Wales with company no. 07923992.