This programme is for participants who already use Power BI and want to move into advanced reporting, complex data modelling, and enterprise-level deployment. It covers DAX patterns, relationships, performance, and Power BI Service governance.
HRD Corp SBL-Khas Claimable
Advanced DAX
Time intelligence functions, CALCULATE, ALLEXCEPT, and complex measure patterns for business calculations that go beyond simple aggregations.
Data Modelling Best Practices
Star schemas, snowflake schemas, managing relationships, and avoiding modelling mistakes that slow down reports.
Row-Level Security (RLS)
Implement dynamic and static RLS so each user sees only the data relevant to their role.
Power Query Advanced
M language basics, custom columns, query parameters, and reusable transformation steps for maintainable data pipelines.
Performance Optimisation
Identify slow reports, reduce model size, apply Vertipaq analyser insights, and optimise for fast load times.
Deployment Pipelines
Move reports through development, test, and production environments in Power BI Premium workspaces.
Dataflows and Shared Datasets
Centralise data preparation using dataflows and reuse certified datasets across multiple reports in the organisation.
Final Activity
Enterprise Report Deployment. Participants build an advanced data model with multiple tables, implement row-level security, and deploy a report through a Power BI pipeline to a shared workspace.
Fee RM 2,800 per day
Minimum enrolment 1 participant
Duration 2 Days
Level Intermediate to Advanced (prior Power BI experience required)
Training Mode Physical / Online / Hybrid
HRD Corp Claimable
Certificate Certificate of Completion included