Microsoft Fabric Semantic Models: Advanced DAX, Model Design, and Enterprise BI Architecture
Master advanced DAX patterns and semantic model design for enterprise-grade analytics in Microsoft Fabric.
Course Guaranteed to Run
Course guaranteed to run. If only one participant registers, the course is converted into private flexible 1-to-1 training and consulting.
Why This Course Matters
The Business Problem We Solve
Organizations struggle with slow and unperformant DAX measures, leading to inefficiencies in reporting and business decision-making. Many Power BI and Fabric environments suffer from duplicated and poorly engineered models that create confusion and slow page loads. This course addresses these challenges by teaching participants how to create high-performing semantic models in Microsoft Fabric, focusing on advanced DAX techniques and effective model design.
Target Audience
Senior BI developers DAX developers Semantic model architects Power BI platform engineers building enterprise-grade Fabric semantic models
Prerequisites
Solid Power BI experience including creating measures and calculated columns. Understanding of star schema design. Microsoft Fabric or Power BI Premium access required for labs.
Learning Objectives
• Design performant star and snowflake schemas for Microsoft Fabric semantic models
• Implement advanced DAX patterns for complex business requirements
• Optimize semantic model query performance using DAX Studio
• Secure models with Row-Level and Object-Level Security
• Automate semantic model refresh and deployment using XMLA endpoint scripting
Programme
Day 1: Fabric Semantic Model Architecture
• Introduction to the semantic model positioning, including development in Fabric and Power BI
• Hands-on lab: Create and validate a semantic model with DirectLake connection
Day 2: Advanced DAX - Context, CALCULATE, and Time Intelligence
• Deep dive into advanced DAX patterns, including the use of VAR and iterator functions
• Hands-on lab: Implement a custom fiscal calendar time intelligence measure
Day 3: Security, Governance & Performance Optimization
• Designing dynamic Row-Level Security and implementing performance optimization strategies
• Capstone: Build a complete enterprise semantic model including governance parameters and performance metrics.
Teaching Methods
Each session will include a mixture of theory, guided hands-on labs, and peer reviews, ensuring comprehensive knowledge acquisition and practical application.
Assessment Method
Daily DAX challenge exercises assessed against provided datasets. Final capstone assessed on the completeness and effectiveness of the enterprise semantic model built.
Certification Note
This course prepares participants for the semantics model sections of the DP-600 and PL-300 certifications, focusing on enterprise-level understanding and applications.
Who Should Attend
What You Will Be Able to Do
- Design performant star and snowflake schemas in Microsoft Fabric semantic models
- Implement advanced DAX patterns including CALCULATE stacking, KEEPFILTERS, REMOVEFILTERS, and ALL variations
- Optimize semantic model query performance using DAX Studio and VertiPaq Analyzer
- Analyse complex business requirements and translate them into context-aware DAX measures
- Secure semantic models using Row-Level and Object-Level Security
- Automate semantic model refresh and deployment
Programme
Practical Exercises & Labs
- Creating a semantic model in Fabric
- Advanced DAX challenges with performance metrics
- Implementing Row-Level Security in a real-world scenario
Practical Deliverables
Teaching Methods
Certification & Exam Alignment
Certification alignment: PL-300 — Power BI Data Analyst advanced components; DP-600 — Fabric Analytics Engineer (semantic model sections)
This course covers advanced components of PL-300 and the semantic model sections of DP-600, aligning to enterprise BI certification pathways.
The exam is not automatically included unless explicitly stated. The exam may be administered independently by the relevant certification body or testing provider.
Prerequisites
Assessment
Delivery Options
Upcoming Sessions
No upcoming sessions scheduled.
Request a date or private session.
FAQ
Related Courses
Microsoft Fabric Governance and Security
Master the governance principles of Microsoft Fabric to ensure data compliance and secure access management.
Microsoft Fabric End-to-End Implementation
Architect and deliver a complete Microsoft Fabric data platform with expert-level skills in design and governance.
Microsoft Fabric Real-Time Analytics
Unlock the potential of streaming data with Microsoft Fabric Real-Time Analytics.