The aim of the DAX training is to familiarize participants with the functions and complex expressions of DAX (Data Analysis Expressions), which can be used for data analysis in Power BI, SQL Server Analysis Services and in the PowerPivot add-in for MS Excel.
During the DAX online course, participants will learn to use tables functions, construct messages, prepare rankings and use DAX language for time analysis in a more complex way, that gives the expected results. They will learn how to create tree hierarchies, as well as learn how to handle relationships using functions.
Thanks to the DAX training, the participant will be able to:
The DAX course participants are required to have knowledge of the Windows environment, basic knowledge of Power BI or the Excel Power Pivot add-in (importing data, creating relationships, hierarchies and creating basic measures and calculated columns). Earlier participation in the trainings Power BI - data analysis and visualization or Microsoft Excel - data analysis using Power Pivot, Power View, Power Query add-ons may be useful.
The DAX (Data Analysis Expressions) training is carried out in the form of alternating lectures and practical exercises, performed individually or together.
2 days, 8 teaching hours each
