Total Duration:
6-Hour
Course level:
Intermediate to Advanced
Delivery Method:
Instructor Led Online and Classroom Training
Certification:
Certificate of Completion will be provided after completing the course.
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
You may also complete the following course(s) before attending the Power BI Intermediate to Advanced course but they are not mandatory:
Course Dates, Prices & Enrolment
All Training
Physical Classes
Virtual Classes
Time Zone:
Training Method | Dates and Times | Total Hours & Days | Price | |
Classroom Training
|
25 Jul 2025 - 01 Aug 2025
2 Fridays
05:00 AM - 08:00 AM
ET
| 6-hour over 2-day |
£210
(approx. $285 USD)
| Enrol Now |
Classroom Training
|
14 Aug 2025 - 15 Aug 2025
Thursday & Friday
05:00 AM - 08:00 AM
ET
| 6-hour over 2-day |
£210
(approx. $285 USD)
| Enrol Now |