Building Tabular Models in SSAS
Import data from different sources, build relationships, and enhance a model's usability so it finds widespread adoption in your organization. At the end of this course, you'll know how to build a semantic tabular model.
What you'll learn
Analysis Services is an analytical database engine which lets you build business intelligence data models so your users can connect to it from client applications like Excel and Power BI. In this course, Building Tabular Models in SSAS, you will gain the ability to build semantic tabular models that can be widely adopted in your organization. First, you will learn why you would need to use SSAS in your project when you already have a data warehouse. Next, you will discover how to import data from different sources, define relationships between tables, creating measures with DAX, and add features to enhance a model's usability, such as Calculation groups, KPIs, Hierarchies, Perspectives, and Translations. Finally, you will explore how to deploy and partition the tables and process the deployed models. When you are finished with this course, you will have the knowledge and advanced data modeling skills needed to build enterprise-grade tabular models.
Table of contents
- Introduction 2m
- Demo - Handling Multiple Relationships Between Tables 5m
- Demo - One-to-one Relationship 2m
- Demo - One-to-many Relationship 1m
- Demo - Dealing with Relationships for Composite Keys 3m
- Demo - Many-to-many Relationship 2m
- Demo - Using Bidirectional Cross-filters 1m
- Demo - A Note of Caution on Using Bidirectional Cross-filters 5m
- Demo - Many-to-many Feature in SSAS 2019 1m
- Summary (Suggestions) 2m
- Introduction 1m
- Demo - Using Calculation Groups to Organize Measures 4m
- Demo - View Detailed Rows 1m
- Demo - Building KPIs 3m
- Demo - Introduction to Hierarchies 2m
- Demo - Create Hierarchies Spanning Multiple Tables 2m
- Demo - Create Parent-child Hierarchies 4m
- Demo - Creating Perspectives 2m
- Demo - Creating Translations 2m
- Summary (Best Practiices) 2m
- Introduction 1m
- Demo - Working with Tabular Partitions 3m
- How SSAS Tabular Processing Works 3m
- Demo - Processing Data in SSDT 2m
- Demo - Processing Data in SSMS 4m
- Demo - Process Full vs. Process Default 3m
- Demo - Processing Related Tables 1m
- Tabular Processing Strategies 4m
- Demo - Incremental Loading 4m
- Summary 2m
About the author
Ravikiran is an independent cloud consultant and author focused on developing solutions in Microsoft Azure. His interests include everything in the cloud space, DevOps and Machine Learning with contributions in domains like Healthcare, Banking and Web Analytics. He is very passionate about the latest and futuristic technologies and constantly updates himself with the current technology trends. He works at the intersection of education and technology. In spare time, he likes going on long road tr... more