Advanced Power BI and Data Modelling
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.
Modules
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.
Key Outcomes:
Write advanced DAX for complex business calculations
Design efficient data models that scale across an organisation
Implement row-level security for controlled data access
Optimise report performance for large and complex datasets
Deploy and manage reports using Power BI pipelines
Centralise data preparation using dataflows for consistent reporting
Fee: RM 2,800 per participant
Minimum enrolment: 1 participant
Duration: 2 Days
Level: Intermediate to Advanced (prior Power BI experience required)
HRD Corp Claimable
Certificate included