Explore the key differences between Multidimensional and Tabular models in Microsoft Analysis Services through this informative 36-minute video. Learn about the fundamentals of Analysis Services, its importance, and gain insights into the Kimble Method and General Ledger concepts. Discover pre-aggregation techniques, understand the structure of cubes and star schemas, and delve into dimension modeling. Compare the strengths and limitations of Tabular models, and receive guidance on choosing the most suitable model for your needs. Additionally, gain knowledge about Azure Analysis Services and Query Replicas to enhance your understanding of modern data analysis solutions.
Analysis Services - What Is the Difference Between Tabular and Multidimensional Models
Overview
Syllabus
Introduction
What is Analysis Services
Why do we need Analysis Services
Book Recommendation
Kimble Method
General Ledger
PreAggregation
Cube
Multidimensional Cube
Star Schema
Dimension Model
Tabular Model
Tabular Model Limitations
Which Model Should You Choose
Azure Analysis Services
Azure Query Replicas
Wrap Up
Taught by
Bryan Cafferky
