Thanks to the DAX training, the participant will be able to:

• define measures, columns, and calculated tables
• create simple and complex DAX formulas
• take care of code optimization
• use information functions, as well as dates and ranking functions
• use functions to manipulate tables
• handle relationships using functions
• create tree hierarchies

The DAX course participants are required to have knowledge of the Windows environment, basic knowledge of Power BI or the Excel Power Pivot add-in (importing data, creating relationships, hierarchies and creating basic measures and calculated columns). Earlier participation in the trainings Power BI - data analysis and visualization or Microsoft Excel - data analysis using Power Pivot, Power View, Power Query add-ons may be useful.

The DAX (Data Analysis Expressions) training is carried out in the form of alternating lectures and practical exercises, performed individually or together.

2 days, 16 training hours

1. The essence of the data model
2. Contexts of performance
3. Calculated column vs measure
4. Data types
5. Operators
6. Selected functions review:

• aggregators and iterators
• VALUES and DISTINCT
• RELATED and RELATEDTABLE
• CALCULATE and CALCULATETABLE
• filters and modifiers

1. Displaying messages - use of information functions
2. Selected  time analysis functions
3. Rankings

• using the RANKX function
• preparation of the "top N" analysis

• syntax
• code optimization
• use in calculations and analyzes

• defining calculated tables
• grouping of data

• using inactive relationships
• virtual relationships
• multi-column relationships

• Power BI - Data analysis and visualization

Current dates of this training:

• 20 -21 Feb 2025  (400,00 €)

Sign up for training!