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:
| There is no date for this course at this moment. Please complete the BOOKING REQUEST FORM below or come back to this page again later. |