Data Analysis Expressions (DAX)
DAX (Data Analysis Expressions) is a programming language created by Microsoft.
Ideal for teams that…
Hands-on AI and data analytics workshops — built around your team's real cases.
This DAX training aims to teach participants the various aspects of the language, enabling them to work effectively with Microsoft Power BI, Excel Power Pivot, and Analysis Services.
What we actually do
- · Understanding contexts in DAX – row context, filter context, evaluation context, context transition
- · Time intelligence functions in complex scenarios Analysis “to date” Working with weeks Custom time ranges
- · Advanced calculations with DAX Advanced filtering in CALCULATE Using virtual relationships (TREATAS) Building rankings with DAX Using variables in DAX calculations
- · Calculated tables in DAX Concept of “Filter as a table” Creating calculated tables in DAX Creating virtual tables for specific calculations
- · Calculated groups in DAX
- · Using calculations at the visualization level Creating visualization-level calculations When is it worth applying them?
- · Creating queries in DAX
- · Correct use of DAX Query performance analysis Best practices in DAX
From brief to retro in 30 days.
Brief & diagnosis
A call with the team lead + a short survey for participants. We define goals, gap and context.
Program customization
We adapt modules, case studies and code examples to your stack. Approval in 5 days.
Workshop
Trainer-led sessions, hands-on, code review. Mentor available between sessions too.
Retro + report
Outcome report for the team and lead. 30 days of consulting included.
Send a brief. We'll reply within 1 day.
After a short brief we'll prepare a program and a quote. No obligations — it's just a starting point.
Thank you!
We'll get back to you within 1 business day.
Other programs for teams
See all →Active Directory
Hands-on AI and data analytics workshops — built around your team's real cases.
AI SQL Developer
Hands-on AI and data analytics workshops — built around your team's real cases.
Amazon Redshift - Introductory Training
Hands-on AI and data analytics workshops — built around your team's real cases.