Featured resource
2025 Tech Upskilling Playbook
Tech Upskilling Playbook

Build future-ready tech teams and hit key business milestones with seven proven plays from industry leaders.

Check it out
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

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.

Patrick Pichler - Pluralsight course - Choosing between Multidimensional and Tabular Models in SSAS
Patrick Pichler
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.

Table of contents

About the author
Patrick Pichler - Pluralsight course - Choosing between Multidimensional and Tabular Models in SSAS
Patrick Pichler

Patrick is a passionate data and analytics engineer. He has been designing and implementing scalable data architectures and analytical solutions for almost a decade by utilizing latest Microsoft technologies including Azure as well as open source frameworks.

Get access now

Sign up to get immediate access to this course plus thousands more you can watch anytime, anywhere.

Get started with Pluralsight