Home Specialist skills Data and Analytics Power BI Mastery: Advanced Analytics and Insights
Power BI Mastery: Advanced Analytics and Insights
-
Build and optimise advanced data models using star schema design
-
Write and apply advanced DAX calculations for complex analytical needs
-
Transform and shape data using Power Query and M language
-
Create dynamic and parameter-driven visualisations
-
Implement row-level security and manage access controls
-
Use Power BI Service features such as workspaces and deployment pipelines.
Overview
Off the shelf (OTS)
This course is designed for experienced Power BI users such as data analysts, report developers, and business intelligence professionals who want to deepen their understanding of complex modelling, advanced DAX functions, and dynamic reporting techniques.
Attendees should have prior experience with Power BI, including building basic reports and data models.
The Power BI Advanced Training Course builds on core Power BI knowledge and introduces more sophisticated capabilities for enterprise-level reporting. It covers advanced DAX, data modelling with star schemas, M language for complex transformations, and deployment strategies using the Power BI Service.
Key Topics Covered:
• Advanced DAX functions and time intelligence
• Complex transformations using Power Query and M
• Data modelling with relationships and star schema design
• Creating dynamic and parameter-driven reports
• Implementing row-level security and data governance
• Power BI Service features and workspace management
The course is delivered over three days and includes hands-on exercises throughout.
Delivery method
Virtual
Course duration
21 hours
Competency level
Working
Delivery method
-
Virtual
Course duration
21 hours
Competency level
-
Working
Spark login – Alpha testing