YoVDO

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

Offered By: Bryan Cafferky via YouTube

Tags

Data Analysis Courses General Ledger Courses Star Schema Courses

Course Description

Overview

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

Related Courses

Social Network Analysis
University of Michigan via Coursera
Intro to Algorithms
Udacity
Data Analysis
Johns Hopkins University via Coursera
Computing for Data Analysis
Johns Hopkins University via Coursera
Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX