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
Objectives
To provide the knowledge and skills required to use DAX (Data Analysis Expressions) expressions to resolve a wide range of analytical and data modeling issues.
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.
Prerequisite
Experience with Power BI.
Your benefits
Content
DAX Fundamentals and Data Modeling
- DAX - What You Need to Get Started
- Introduction to DAX
- Data Modeling Basics
- What Is DAX?
See more + / -
Calculated Columns, Measures and Core DAX Functions
- Creating Calculated Columns
- Navigation Functions
- Conditional and Logical Functions
- Creating Calculated Measures
Time Intelligence with DAX
- Time Intelligence
- Time Intelligence Functions
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
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
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)
💡 Useful information
Our training sessions are offered in Montreal or Quebec City, in person or in virtual format. Dates and locations are provided when you select your session below. If you have any questions regarding registration, schedules, the language of instruction, or cancellation policies, please consult our FAQ .
Trainers
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote