Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft SQL Server Analysis Services Demystified
SQL Server Analysis Prerequisites
Analysis Services Architecture (3:12)
Dimensional Modeling Concepts (3:10)
Business needs That Are Best Served by Analysis Services (3:13)
SQL Server Management Studio (3:20)
Understanding SQL Server Data Tools (3:20)
Tabular Modeling
What Is a Tabular Model? (4:27)
Key Glossary of Terms for Tabular Models (4:22)
Relationships within a Tabular Model (3:12)
Introduction to DAX (3:10)
Calculated Columns versus Calculated Measures (3:04)
Tabular Modeling for Analysis
Creating Calculated Columns (3:13)
Creating a Calculated Measure (3:15)
Creating KPIs (3:05)
Creating Partitions (5:29)
Creating Hierarchies (4:33)
Tabular Modeling Management
Create Tabular Model Partitions and Hierarchies (3:08)
Most Commonly Used DAX Expressions (3:03)
Tabular Model Deployment – Cached Mode (3:10)
Tabular Model Deployment – Production Mode (4:01)
Tabular Model Backups (3:28)
Multidimensional Modeling
Multidimensional Models and Their Best Uses (3:08)
Multidimensional Model Types (2:53)
Introduction to MDX (3:07)
Advanced Use Cases of MDX (3:34)
MDX versus DAX (3:26)
Multidimensional Modeling for Analysis
Creating Multidimensional Model Dimensions (3:55)
Creating Multidimensional Model Calculations (3:19)
Creating Multidimensional Model Key Performance Indicators (3:11)
Creating Multidimensional Attributes (3:32)
Creating Multidimensional Model Partitions (3:40)
Multidimensional Model Management
Multidimensional Measure Groups (3:31)
Most Commonly Used MDX Expressions (3:15)
Multidimensional Aggregation Designs (3:40)
Multidimensional Model Process Options (3:55)
Multidimensional Model Deployment Options (3:21)
Visualizing Your Analysis Services Data
Visualizing Tabular Model Data with Power View (3:09)
Visualizing Multidimensional Model Data with SSRS (3:04)
Using Excel to Expose Your Tabular Data (3:50)
Using Excel to Expose Your Multidimensional Data (3:34)
Data Visualization Principles (2:59)
Creating Calculated Columns
Create a calculated column to store data that can be sliced inside the tabular model.
Complete and Continue