16 hours / 2 days
DAX language was created specifically for the handling of data models, through the use of formulas and expressions. DAX is used in several Microsoft Products such as Microsoft Power BI, Microsoft Analysis Services and Microsoft Power Pivot for Excel. These products all share the same internal engine, called Tabular/Vertipaq (xVelocity before).
With DAX we have the ability to include business logic in calculations in order to enrich our business intelligence models.
Before attending this course, it is recommended that students have a desire to learn more about DAX and prior exposure to the DAX calculations.
Understanding of dimensional modelling and knowledge about any functional programming language is recommended too, but not necessary.
By the end of this course, you will be able to understand the key functions in DAX, the different elements that can be created with DAX and the different context involve in it. You could perform a variety of query´s using DAX, debugging and optimizing it.