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 info
Rating
(15)
Level
Beginner
Updated
Mar 29, 2019
Duration
1h 9m
Table of contents
Description
Course info
Rating
(15)
Level
Beginner
Updated
Mar 29, 2019
Duration
1h 9m
Description

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.

About the author
About the author

Patrick Pichler is a professional freelancer with deep knowledge in the areas of Business Intelligence and Big Data. He holds a MSc degree from the University of Liverpool and several data development certifications

Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
(Music playing) Hi everyone, my name is Patrick, and welcome to my course Choosing Between Multidimensional and Tabular Models in SSAS. I'm an independent data and analytics specialist, and I've been working on different business intelligence and big data projects for many years. In November 2018, the Microsoft Analysis Services celebrated their 20-year anniversary, ranked as 1 of the top OLAP technologies ever since. This course compares to nowadays two existing model types, multidimensional and tabular. Some of the major topics that we will include, analyzing conceptual design differences, examining supported data sources and storage modes, exploring data modeling and analytical features, and comparing the interaction with client applications. By the end of this course, you will be able to evaluate which model type better meets the given requirements of your individual use case. Before beginning the course, you should be familiar with data and analytics literacy, basic SQL data modeling, and basic OLAP modeling. I hope you will join me on this journey to ensure to use the right model type with the Choosing Between Multidimensional and Tabular models in SSAS course at Pluralsight.