SQL Server’s in-memory engine, or Analysis Services Tabular Model, provides an alternative to the multidimensional OLAP engine for many implementation scenarios. The course provides students with both the basic concepts and the advanced concepts of Tabular modelling and DAX language.
- Introduction to SSAS Tabular
- How to create a model: data sources, relations, calculated columns, calculated measures, hierarchies
- Introduction to DAX: complex measures and how to use them to solve business problems
- It is suggested to attend the course: Business Intelligence: all you need to know about methods, processes and tools
Participants will be able to exploit all the functionalities offered by this tool, and use it at a PRO level by learning the DAX language.This permits to exploit the most advanced capabilities offered by Power BI.
This course can be paired with the course on reporting tools: Power BI: beginner to advanced
For a deeper understanding of the technical data modelling tools, we suggest the courses: SSAS Tabular Modeling and Building an ETL system with SSIS