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.
Author Name: Ravikiran Srinivasulu
Author Description:
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

Table of Contents

• Course Overview
  1min
• Getting Started with Tabular Models
  23mins
• Importing Data into Tables
  23mins
• Building Tabular Relationships and Measures
  23mins
• Improving the Usability of the Model
  23mins
• Deploying the Tabular Model
  18mins
• Selecting the Right Processing Operations for Your Model
  26mins
• Connecting to Data Sources with DirectQuery
  12mins