Calculations and queries with DAX (conducted in English) kursus

You will learn

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

You get

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.

Get the best benefit from the course

Get an optimal result from the course

This 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.

Course Details