DAX In A Day (DAXIAD)

OVERVIEW

Prerequisites—DIAD training and Advanced Data Modeling and Shaping training or equivalent working experience

This course has been designed specifically for experienced model developers and gives a more advanced treatment of DAX formulas than either DIAD or the PL-300 course. We recommend that attendees have prior experience working with Power BI Desktop to create data models.

During this course you will review:

• Writing DAX formulas.
• Defining calculated tables and columns.
• Defining measures.
• Using DAX iterator functions.
• Modifying filter context.
• Using DAX time intelligence functions.

After completing this training, the attendees should be able to work with Data Analysis Expressions (DAX), perform calculations and define common business calculations for use in reports, address performance and functionality concerns.

COURSE BENEFITS:

• Understand Analytic queries in Power BI
• Create calculated tables, calculated columns and measures
• Use DAX functions and operators to build DAX formulas
• Use DAX iterator functions
• Create formulas that manipulate the filter context
• Use DAX time intelligence functions

WHO IS THE COURSE FOR?

• Analysts with experience of Power BI wishing to develop more advanced formulas in DAX
• Power BI developers who wish to deepen their understanding of the process of calculating formulas so as to make development faster and more reliable

LAB OUTLINE