On this course you will learn how to create calculated columns and measures with Data Analysis Expressions (DAX). DAX is a formula language vital for solutions developed in Tabular Datamodels. It makes you capable of adjusting the Datamodels to support the analysis needed. DAX contains many useful functions for advanced analysis e.g. periodic calculations and comparisons. After the course you’ll be able to handle these tasks:
- Create calculated columns and measures
- Create advanced relations and parent-child hierarchies
- Understand DAX execution context
- Use DAX time intelligent functions
- Create calculated tables
- Use DAX Studio for querying and analysing performance
Get an optimal result from the courseThis DAX course is a part of our Business Intelligence courses and is aimed for those, who works with tabular Datamodels in Excel, Power BI Desktop or in SQL Server Analysis Services in tabular mode.
Before the course
- The option of talking with an instructor, assisting you in finding the right course.
During the course
- Teaching by an experienced instructor team, in our cosy and fully updated classrooms located in the centre of Copenhagen.
- A course that consists of both theory and practical exercises. We believe in the effect of practical exercises, and hands-on is always in focus during the courses.
- A course material you can use as an encyclopaedia after the course. Even you can download the course exercises.
- All meals, which includes breakfast, fresh coffee, tea, fruit, soft drinks, lunch at an Italian restaurant, cake, candy and off cause Wi-Fi to your devices.
- A course certificate as a proof of your new skills.
After the course
- Access to our free hotline service, which means that you, up to a year after the completion of the course can contact us, if you have questions regarding subjects from the course.
- We have a unique satisfaction guarantee in order to ensure, that you get the complete benefit from the course.
Introduction to DAX
You get an introduction to Tabular Datamodels and DAX.
- Introduction to a Tabular Datamodel
- DAX syntax
Calculated columns and measures
You will learn how to create calculated columns and measures with DAX.
- Calculated columns
- Simple measures
DAX Evaluation Context and advanced measures
You’ll get an understanding of the evaluation context in DAX, a crucial prerequisite for implementing advanced measures. Additionally, several useful functions for handling filters are presented. Also, you will learn how to use variables in calculations.
- Row context
- Filter context
- Filter functions
- Information functions
- DAX and variables
The aim of this module is to make you capable of building more advanced Datamodels e.g. containing calculated tables and parent-child hierarchies.
- Role playing dimensions
- DAX and relations
- Advanced filter functions
- Calculated tables
- Parent-Child hierarchies
DAX Time intelligence
You’ll learn how to implement time intelligent analysis in your Datamodel
- Demands in the Time dimension (table)
- Comparing parallel periods
- Accumulated values
- Running totals
- Semi additive measures
An introduction to the free tool DAX Studio
- Queries in DAX Studio
- Tracing performance