Master DAX to build high-performance models and advanced analytics
Now that you can connect many sources to extract data, DAX will help you see more clearly. This formula and function based language is a bit reminiscent of Excel. DAX allows you to output information from the data in your model. Although Power BI allows you to build reports and dashboards from the start, DAX gives you the means to go further by creating formulas that will help you get the most out of your data
Is it for you ?
Professionals who use Power Pivot and/or Power BI Desktop to analyze data and wish to create dynamic, high-performance dashboards.
Prerequisites
Experience with Power BI.
What You'll Walk Away With
- ✓ Create measures and calculated columns to enhance data models
- ✓ Master filter context and key functions such as CALCULATE
- ✓ Leverage time intelligence for advanced time-based analysis
- ✓ Use advanced functions and variables to improve performance
- ✓ Implement data security and handle errors in data models
Training content
1 DAX Fundamentals and Data Modeling
- DAX - What You Need to Get Started
- Introduction to DAX
- Data Modeling Basics
- What Is DAX?
2 Calculated Columns, Measures and Core DAX Functions
- Creating Calculated Columns
- Navigation Functions
- Conditional and Logical Functions
- Creating Calculated Measures
3 Time Intelligence with DAX
- Time Intelligence
- Time Intelligence Functions
4 Intermediate Functions, Table Functions and DAX as a Query Language
- Using X-Functions and A-Functions
- Table Functions
- DAX as a Query Language
- Using Variables
5 Filter Context, CALCULATE, Iterators and Context Transition
- What Is Filter Context?
- Using Filter Context (CALCULATE, Filter Context Substitution, FILTER, ALL, ALLEXCEPT)
- CALCULATE and Time Intelligence (YTD, MTD, Rolling 12-Month Total, Rolling 3-Month Average)
- Semi-Additive Measures
- Introduction to Row Context and Context Transition
- Using Iterator Functions
- Nested Row Context
6 Error Handling, Data Security and Advanced DAX Functions
- Error Handling
- Implementing Basic Security
- Dynamic Security
- Role-Playing Dimensions (Importing Multiple Tables and USERELATIONSHIP)
- Advanced DAX Functions (CONTAINS, FIND, SEARCH, SUBSTITUTE, ALLSELECTED, RANKX)
📌 Practical information
Our training sessions are offered in Montreal or Quebec City, in person or in a virtual classroom. Dates and locations are specified when you select your session below. If you have any questions, check out our FAQ.
