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.
Author Name: Patrick Pichler
Author Description:
Patrick has over a decade of experience in designing, implementing, and managing data, analytics, and AI applications, from small to large-scale projects, using both proprietary and open-source frameworks. He is CEO of Creative Data, a consultancy enabling sustainable data architectures. Patrick is passionate about sharing his knowledge through online courses, technical articles, and his contributions to various open-source projects. He earned his Bachelor’s degree in Business Informatics and hi… more

Table of Contents

• Course Overview
  1min
• Comparing the Fundamental Data Modeling Experiences
  14mins
• Choosing the Model Type Based on Data Access and Storage Criteria
  25mins
• Comparing the Implementation of Business Logic and Analytical Needs
  15mins
• Considering Front-end Tools and Future Sustainability
  12mins