Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft SQL Server Analysis Services Demystified
SQL Server Analysis Prerequisites
Analysis Services Architecture
Dimensional Modeling Concepts
Business needs That Are Best Served by Analysis Services
SQL Server Management Studio
Understanding SQL Server Data Tools
Tabular Modeling
What Is a Tabular Model?
Key Glossary of Terms for Tabular Models
Relationships within a Tabular Model
Introduction to DAX
Calculated Columns versus Calculated Measures
Tabular Modeling for Analysis
Creating Calculated Columns
Creating a Calculated Measure
Creating KPIs
Creating Partitions
Creating Hierarchies
Tabular Modeling Management
Create Tabular Model Partitions and Hierarchies
Most Commonly Used DAX Expressions
Tabular Model Deployment – Cached Mode
Tabular Model Deployment – Production Mode
Tabular Model Backups
Multidimensional Modeling
Multidimensional Models and Their Best Uses
Multidimensional Model Types
Introduction to MDX
Advanced Use Cases of MDX
MDX versus DAX
Multidimensional Modeling for Analysis
Creating Multidimensional Model Dimensions
Creating Multidimensional Model Calculations
Creating Multidimensional Model Key Performance Indicators
Creating Multidimensional Attributes
Creating Multidimensional Model Partitions
Multidimensional Model Management
Multidimensional Measure Groups
Most Commonly Used MDX Expressions
Multidimensional Aggregation Designs
Multidimensional Model Process Options
Multidimensional Model Deployment Options
Visualizing Your Analysis Services Data
Visualizing Tabular Model Data with Power View
Visualizing Multidimensional Model Data with SSRS
Using Excel to Expose Your Tabular Data
Using Excel to Expose Your Multidimensional Data
Data Visualization Principles
Creating Multidimensional Model Dimensions
Learn how to create a dimension to describe data.
Complete and Continue