Power BI Intermediate to Advanced

Total Duration: 6-Hour
Course level: Intermediate to Advanced
Delivery Method: Instructor Led Online and Classroom Training

Regular Price: £210 (Approximately $282.87 USD)
Batch Price: From £180 (approx. $242 USD) 📅 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:

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 Dates, Prices & Enrolment

All Training Physical Classes Virtual Classes

Time Zone:

Training Method	Dates and Times	Total Hours & Days	Price
Online Training using Zoom	18 Aug 2025 - 22 Aug 2025 Mon, Wed & Fri 10:00 AM - 12:00 PM ET	6-hour over 3-day	£180 £210 (approx. $242 USD)	Enrol Now
Online Training using Zoom	15 Sep 2025 - 19 Sep 2025 Mon, Wed & Fri 10:00 AM - 12:00 PM ET	6-hour over 3-day	£180 £210 (approx. $242 USD)	Enrol Now
Online Training using Zoom	16 Sep 2025 - 25 Sep 2025 2 Tuesdays & 2 Thursdays 01:00 PM - 02:30 PM ET	6-hour over 4-day	£210 (approx. $283 USD)	Enrol Now
Online Training using Zoom	13 Oct 2025 - 17 Oct 2025 Mon, Wed & Fri 10:00 AM - 12:00 PM ET	6-hour over 3-day	£180 £210 (approx. $242 USD)	Enrol Now
Online Training using Zoom	28 Oct 2025 - 06 Nov 2025 2 Tuesdays & 2 Thursdays 02:00 PM - 04:00 PM ET	6-hour over 4-day	£210 (approx. $283 USD)	Enrol Now
Online Training using Zoom	10 Nov 2025 - 14 Nov 2025 Mon, Wed & Fri 10:00 AM - 12:00 PM ET	6-hour over 3-day	£180 £210 (approx. $242 USD)	Enrol Now
Online Training using Zoom	08 Dec 2025 - 12 Dec 2025 Mon, Wed & Fri 10:00 AM - 12:00 PM ET	6-hour over 3-day	£180 £210 (approx. $242 USD)	Enrol Now

Note: Online classes are usually delivered through Zoom video conferencing.

Related/Sample Videos

Microsoft Power BI Beginner Course | Instructor-Led Training (Online & Classroom)

Course Content

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)
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
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
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
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
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

Certification

Certificate of Completion will be provided after completing the course.

Share This Course

Related Courses

Save Money with Packages

SAVE up to 20% by booking this course with other related courses as shown below:

Microsoft Power BI Immersive

£336 (save £84)

This package combines

Microsoft Power BI for Beginners - 6 hours
Power BI Intermediate to Advanced - 6 hours

Find out more & book now

Newsletter Sign-up

First Name

Last Name

Email address

Have a Question?

Please read our frequently asked questions or contact us.

5 Reasons Why Power BI is a Game-Changer for Data Analysis

What can we do with Power BI?

We are providing affordable IT training courses at times to suit you - enhance your employability and stand out from the crowd.

Become an IT expert and get that competitive edge that employers are looking for.

Popular Courses

Useful Links

Contact Us

London Academy of IT

Unit 15, Boardman House
64 Broadway
Stratford
London E15 1NT
United Kingdom

☎️ +44 (0)208 432 6218

WhatsApp: +44 0749 461 6045