Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Analysis Services - What Is the Difference Between Tabular and Multidimensional Models

Bryan Cafferky via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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.

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

Reviews

Start your review of Analysis Services - What Is the Difference Between Tabular and Multidimensional Models

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.