- Course
Choosing between Multidimensional and Tabular Models in SSAS
Microsoft’s SQL Server Analysis Services (SSAS) is considered to be one of the top online analytical processing (OLAP) technologies. This course compares the two major semantic data model types by SSAS and how to assess which one to use in practice.
- Course
Choosing between Multidimensional and Tabular Models in SSAS
Microsoft’s SQL Server Analysis Services (SSAS) is considered to be one of the top online analytical processing (OLAP) technologies. This course compares the two major semantic data model types by SSAS and how to assess which one to use in practice.
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
By implementing an OLAP solution using Microsoft technology, you have been confronted with two different model types for several years now. In this course, Choosing between Multidimensional and Tabular Models in SSAS, you’ll gain the ability to evaluate which model type fits better to your individual use case. First, you’ll explore the conceptional design differences. Next, you’ll discover the supported data sources and storage modes. Finally, you’ll learn how to implement business logic by using the model’s common as well as individual features together with analyzing the interaction with client applications. When you’re finished with this course, you’ll have the skills and knowledge to assess whether the Multidimensional or Tabular model will better perform under your given circumstances.
Choosing between Multidimensional and Tabular Models in SSAS
-
Overview | 58s
-
Timeline of SQL Server Analysis Services | 1m 29s
-
Understanding the High-level Design Concepts | 2m 17s
-
Analyzing the Coexisting Query Languages MDX and DAX | 1m 30s
-
Considering Implementation Time and Learning Curve | 1m 1s
-
Demo: Exploring the Semantic Data Modeling Objects in Visual Studio | 7m
-
Summary | 30s