Training Course Modules
Stop guessing with DAX — learn how to structure calculations with clarity and precision.
Build data models that scale with your organization — not break it.
Master advanced DAX and data modeling techniques that make reports faster, smarter, and more accurate.
Course Overview
Power BI is only as good as the models that power it. Without structured relationships and reliable measures, your dashboards can mislead rather than inform.
This 5-day instructor-led course is designed for experienced Power BI users and analysts looking to master Data Analysis Expressions (DAX) and data modeling techniques. The workshop covers the full DAX language (DAX 2019), model design, many-to-many relationships, snapshots, hierarchies, date intelligence, segmentation, and granularity.
You’ll not only write complex DAX but also build sustainable, accurate, and high-performing data models—ensuring that your reports deliver insights your business can trust.
Learning Objectives
Mastering the DAX language
Writing complex calculated columns and measures
Using table functions, variables, and iterators
Applying time intelligence (YTD, YOY, running totals)
Understanding row and filter context, CALCULATE, and ALLSELECTED
Handling many-to-many relationships and segmentation
Designing models with multiple date tables, snapshots, and interval analysis
Working with different data granularities and model performance tuning
Who Should Attend
Power BI developers and analysts using DAX regularly
Data modelers working with Power Pivot or SSAS Tabular
BI professionals optimizing complex reporting scenarios
Anyone who has basic knowledge of Power BI and wants to go deeper into DAX and modeling
Prerequisites
Basic understanding of Power BI, Power Pivot, or Analysis Services Tabular
Prior exposure to DAX is required
Familiarity with relationships and basic model concepts
Course Modules
Modules 1–5: DAX Language Mastery
Learn calculated columns, measures, evaluation contexts, table functions, CALCULATE, and iterators like RANKX, MINX, MAXX.
Modules 6–10: Time Intelligence, Hierarchies & Segmentation
Apply DATEADD, DATESINPERIOD, semi-additive measures, FILTER, ALLSELECTED, and static/dynamic segmentation strategies.
Modules 11–17: Advanced Data Modeling Techniques
Design star schemas, header/detail models, multiple date tables, snapshots, date intervals, and multi-granularity structures.
Public Class Details
Professional Outcomes
This course supports advanced roles such as Power BI Data Modeler, BI Developer, or Analytics Solution Architect — professionals building scalable, enterprise-grade BI models.
Certification Details
No specific exam for this course
Frequently Asked Questions
Is this course suitable for beginners?
No. It’s designed for users who already know Power BI and want to deepen their understanding of DAX and modeling.
Will I be writing DAX every day?
Yes. Each day includes lab exercises focused on DAX applications.
Does this course cover visuals and storytelling?
No. The course is focused on backend modeling and calculations, not visual design.
Are snapshot and segmentation models included?
Yes. You'll handle non-additive measures, parameter tables, and dynamic segmentations.
Is Power BI required?
Yes. Labs are conducted using Power BI Desktop with data sources like SharePoint and custom datasets.
Is this a Microsoft certification course?
No. This is a GemRain original advanced course without official Microsoft exam alignment.
Is this course HRDC claimable?
Yes. Fully claimable for eligible Malaysian employers.
Can I run this privately for my BI team?
Yes. GemRain offers corporate delivery (onsite or virtual) tailored to your use cases.
Do I get a certificate of completion?
Yes. GemRain issues a certificate upon completing the full 5-day workshop.