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.
Course info
Rating
(13)
Level
Intermediate
Updated
Apr 2, 2020
Duration
2h 31m
Table of contents
Course Overview
Getting Started with Tabular Models
Importing Data into Tables
Building Tabular Relationships and Measures
Improving the Usability of the Model
Deploying the Tabular Model
Selecting the Right Processing Operations for Your Model
Connecting to Data Sources with DirectQuery
Description
Course info
Rating
(13)
Level
Intermediate
Updated
Apr 2, 2020
Duration
2h 31m
Description

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.

About the author
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 works at the intersection of education and technology.

More from the author
Migrating SSIS Packages to Azure Data Factory
Intermediate
2h 6m
Mar 26, 2019
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. I'm rather get in on this is my building. Tabler models in essays Course analysis Service is is an analytical date of his engine. Rich lets you build business intelligent data models so your users can collect to it from client applications like Excel and Power. Being with the more recent traveler models, you can build applications that quickly answer the user queries and which can scale with the help off Azure Cloud. In this course, waving build essays, tabular data models from scratch and deployed them both in Asia and on on premises sewers. Some of the major topics that reveal cover includes understanding. The need for aces airs. And, as they say, it's Stabler's moderns, importing data into the modern building, tabular relationships, a discussion on improving a model's usability, mortal deployment and processing. And finally, a discussion on voted back engine on Dad Cory models. By the end of this course, you will have a working knowledge to build enterprise great semantic, be a model's writ essays tabler that's ready to be deployed to production environments. But before you begin, make sure you have at least a little familiarity with relational database concepts and secrets. Ever