top of page
PMIMCM Class.webp

GRC-102FT

Conquering DAX 2019 [Fastrack]

This intensive DAX Fastrack course equips Power BI and data model users with the skills to master DAX 2019, enabling them to write accurate, efficient formulas for advanced analytics, performance optimisation, and complex business reporting.

Conquering DAX 2019 [Fastrack] is a comprehensive, instructor-led program designed for professionals who want to master the Data Analysis Expressions (DAX) language used in Microsoft Power BI, Power Pivot for Excel, and SQL Server Analysis Services (SSAS) Tabular models. This course focuses on building deep, practical understanding of DAX so learners can confidently handle complex analytical scenarios.


DAX is the foundation of advanced analytics in Power BI. While many users can create basic measures, challenges often arise when dealing with evaluation contexts, filters, time intelligence, hierarchies, and many-to-many relationships. This course addresses those challenges by explaining not just how DAX works, but why it behaves the way it does.


Over three intensive days, participants move from fundamental DAX concepts to advanced modeling and calculation techniques. The course combines structured explanations with extensive lab exercises, ensuring learners can immediately apply concepts to real-world reporting and analytical problems.


What learners will gain from this course:

  • A complete understanding of DAX syntax, functions, and behavior

  • The ability to write accurate measures and calculated columns

  • Confidence in handling evaluation contexts and filter logic

  • Skills to implement time intelligence calculations correctly

  • Techniques to manage complex data models, including hierarchies and many-to-many relationships

  • Practical experience solving real analytical scenarios using DAX

Key learning areas include:

DAX Fundamentals

  • Data types, calculated columns, measures, variables, and error handling

  • Core aggregation, mathematical, and relational functions


Table Functions and Filtering

  • Filtering tables, ignoring filters, mixing filters, and using table variables

  • Understanding DISTINCT, ALLSELECTED, RELATEDTABLE, and relationship behavior


Evaluation Contexts

  • Filter context versus row context

  • Common context-related errors and how to avoid them

  • How relationships affect calculations


CALCULATE and Iterators

  • Using CALCULATE to modify filter context

  • Applying iterators such as MINX, MAXX, and RANKX

  • Understanding scope and context transitions


Time Intelligence

  • Running totals, year-over-year comparisons, and moving averages

  • Semi-additive measures and period-based calculations


Advanced Modeling Scenarios

  • Hierarchies and parent-child relationships

  • Static and dynamic segmentation

  • Handling many-to-many relationships effectively


The course is reinforced through multiple hands-on lab exercises that mirror real business problems, such as ranking customers, calculating performance trends, segmenting data, and correcting model inaccuracies.


This course is suitable for Power BI users, Excel Power Pivot users, and BI developers who already understand basic data modeling and want to significantly improve their analytical capabilities. By the end of the program, learners will be able to design reliable, scalable, and high-performance DAX calculations that support advanced business intelligence solutions.

Class Details

13-15 May

3 days

CLASS PENDING

Physical (ILT)

RM 2,100

Quote

Frequently Asked Questions

What is DAX used for in Power BI?

DAX is used to create calculated columns, measures, and advanced analytics logic in Power BI, enabling dynamic calculations based on filters and context.

Who should attend an advanced DAX course?

This course is suitable for Power BI users, Excel Power Pivot users, and BI developers who want to deepen their understanding of DAX and build complex analytical models.

Is DAX difficult to learn?

DAX can be challenging due to its evaluation context concepts, but with structured training and practice, it becomes manageable and highly powerful.

What are evaluation contexts in DAX?

Evaluation contexts define how DAX formulas are calculated, mainly through row context and filter context, which determine how data is filtered during calculations.

Will this course cover time intelligence in Power BI?

Yes. The course covers time intelligence functions such as running totals, year-over-year comparisons, moving averages, and semi-additive calculations.

Is this course HRDC Claimable?

Yes. This course is HRDC claimable, subject to HRDC approval and company eligibility requirements.

Can this course be customized for our organization?

Yes. The course content can be customized based on your data model, reporting requirements, and business scenarios.

What prerequisites are required for this DAX course?

Participants should have basic knowledge of data modeling in Power BI, Power Pivot for Excel, or Analysis Services Tabular models.


Unlock Your PMI Member Training Benefits

Tell us what you're looking for, and our team will recommend the most suitable training options for you or your organization. Whether you're joining a public class or planning private in-house training, we’ll help you get started with the right solution — along with your exclusive PMI member benefits.

Enquiring as
Self Funded
Company Funded

Please select the date you attended a PMI community event held at GemRain.

Terms & Conditions

Eligibility

  • This promotion is available to individuals who are current members of PMI. Proof of membership may be required during registration or prior to course commencement.

Discount Application

  • The up to 40% discount applies only to selected instructor-led public training courses offered by GemRain Consulting.

  • The discount:

    • Is applicable to course fees only

    • Does not apply to certification exam fees, official materials, or third-party charges

    • Cannot be combined with other promotions, discounts, or corporate agreements unless stated otherwise

Course Registration

  • All registrations are subject to availability and will be confirmed upon receipt of full payment.

  • GemRain Consulting reserves the right to:

    • Accept or reject any registration

    • Reschedule or cancel classes due to unforeseen circumstances

Community Contribution

  • For eligible registrations:

    • A contribution (e.g., RM50 for public classes or RM500 for private training) will be allocated to support PMI-related community initiatives hosted at GemRain Consulting venue.

  • This contribution is managed independently by GemRain Consulting and does not imply endorsement, partnership, or official affiliation with PMI.

Private In-House Training

  • The RM500 community support applies only when:

    • A PMI member introduces their organization

    • The organization confirms and proceeds with a private in-house training engagement

  • Additional terms may apply based on the training scope and agreement.

Changes to Promotion

  • GemRain Consulting reserves the right to modify, revise, or withdraw this promotion at any time without prior notice.

Liability

  • GemRain Consulting shall not be held liable for any indirect or consequential loss arising from participation in this promotion or training programs.

Governing Terms

  • All training services are subject to GemRain Consulting’s standard terms and conditions.

bottom of page