DAX Training

Since 2012, we have been operating in the training industry, and our team consists of people who have been involved in teaching and creating modern solutions in the field of IT for many years. We spend over 600 hours a month in training rooms. This time is dedicated to training our clients but also to enriching our experiences, listening skills, and responding to your needs. We specialize in training and consulting in the field of IT. We create ready-made solutions that facilitate everyday work. Our offer includes a wide range of training for both beginners and advanced users and IT specialists. The client is the most important to us! Our work makes sense when the client returns to us again and recommends us to others.

The training "DAX – Data Analysis Language in Power BI and Excel Power Pivot" is a specialized course for those who want to create advanced calculations and analyses in Power BI or Power Pivot. DAX (Data Analysis Expressions) is a formula language that allows building dynamic measures, calculated columns, and KPI indicators. The training focuses on understanding the logic of DAX, filtering context, and row context, as well as the practical application of functions such as CALCULATE, FILTER, ALL, and TIME INTELLIGENCE.

The training is intended for data analysts, BI specialists, financial controllers, and anyone working with data models who wants to create more advanced reports and analyses.

The goal of the training is to acquire the skills to independently write and optimize DAX formulas to achieve precise and flexible analytical results.

• Understanding the logic of the DAX language
• Creating dynamic measures and calculated columns
• Handling filtering context and row context
• Applying time functions (YTD, YOY, MTD)
• Building KPI indicators and analytical scenarios
• Optimizing the performance of formulas and data models

• Introduction to DAX – what it is and where it is used
• Types of columns and measures – differences and applications
• Row context and filtering context – how they work
• Logical and conditional functions (IF, SWITCH, AND, OR)
• Aggregating and statistical functions (SUMX, AVERAGEX, COUNTROWS)
• Data filtering functions (FILTER, CALCULATE, ALL, VALUES)
• Time functions – comparative analysis of periods (YTD, YOY, SAMEPERIODLASTYEAR)
• Creating dynamic measures and KPIs
• Solving common DAX problems
• Practical exercises – data analysis using DAX

8 hours

• Practical classes with a trainer
• Training script
• Files with tasks and exercises
• Certificate
• Email consultations