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
Duration
2 days
Schedule
9h to 16h
Regular fee
$1,035
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$930
Objectives of the training
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.Targeted audience
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.Trainers
Course architecture
Training eligible for SCALE AI grants
- Getting started with DAX
- Introduction to DAX
- Basics of data modeling
- What is DAX
- Creating calculated columns
- Navigation functions
- Conditional and logical functions
- Creating calculated measures
- Time Intelligence
- Time intelligence functions
- Using X functions and A functions
- Table functions
- DAX as a query language
- Using variables
- What is filter context?
- Using filter context (CALCULATE, substituting filter contexts, FILTER, ALL, ALLEXCEPT)
- CALCULATE and time intelligence (YTD, MTD,12 month rolling average, 3 month rolling average)
- Semi additive measures
- Overview of row context and transition context
- Using iterator functions
- Nested row context
- Managing errors
- Implementing basic security
- Dynamic security
- Role playing dimensions (importing several tables and USERELATIONSHIP)
- Advanced DAX functions (CONTAINS, FIND, SEARCH, SUBSTITUTE, ALLSELECTED, RANKX)
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 quoteDuration
2 days
Schedule
9h to 16h
Regular fee
$1,035
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$930
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