DAX
Duration
10-20 hours
The DAX data modeling language developed by Microsoft is probably the biggest differentiator between Power BI and its competitors in the Business Intelligence industry. DAX is a library of functions and operators that can be combined for data modeling in Power BI, Azure Analysis Services, SQL Server Analysis Services (SSAS), and Power Pivot for Excel.
In this introductory course, we will start by justifying the need for such a tool for creating calculated columns and modeling measures, review some of the more complex concepts related to the use of DAX – mainly the data model and the so-called «context» – and review some of the most frequently used DAX functions while applying them to real scenarios of incremental complexity.
Course content:
- Introduction
- Data model
- Creating measures
- Filter context
- Row context
- Context transition
- Aggregation functions
- Time intelligence functions
- Calendar tables
- Iterators
- Iteration functions
- Variables
- Logic functions
- Other functions
Facultad de Ciencias Económicas, Empresariales y Turismo.
Pza. de la Victoria, 2
28802 Alcalá de Henares (Madrid)
Telf. 91 8854201/02
BAII offers data-driven business solutions that enable companies to make informed decisions. BAII also provide statistical consulting for researchers who wish to carry out their projects with greater assurance. In addition, we implement training programs in data science, machine learning, and business analytics.