SSAS Tabular Model with Power BI - A comprehensive training

Build tabular models step by step

4.15 (180 reviews)

Udemy

platform

English

language

Data & Analytics

What you will learn

Step by step learning SSAS Tabular modeling

How to deploy SSAS Tabular database

How to connect Power BI with Tabular model

Star schema vs Snowflake schema

Role playing dimensions

Tabular model deployment

How to create hierarchy in SSAS Tabular Model

Perspectives in Tabular model

DAX & Calculated columns in Tabular model

KPIs & Partitions in SSAS Tabular

Role level security

Processing options in SSAS Tabular model

Automated deployment

Why take this course?

Microsoft Analysis Services abbreviated as SSAS consist of two modes.

1- SSAS Tabular Mode

2- SSAS Multidimensional mode

This course is purely based on SSAS Tabular model. Tabular model in analysis services runs in memory or in the direct query mode. There are different data sources available that can be used to feed data to a tabular model.

When we use the direct query in the Power BI desktop, all the time we fight with the performance issue. Power BI desktop fires SQL queries during refreshing dashboards or doing some interactions. SQL Server needs to run these queries and send the result back to the Power BI which causes performance issue. But with the help SSAS Tabular model, we can design and develop the data model according to the business process requirement, add KPIs, DAX measures, calculated columns, and finally, this model is deployed on the SSAS analysis server.

We can connect the Power BI desktop or SSRS to the SSAS tabular model and fetch the data to show on reports & dashboards. SSAS tabular model provides great flexibility in terms of performance and security.

In this course, you will learn the following topics

- How to install SSAS Tabular instance

- How to import AdventureWorks database

- Start schema vs snowflake schema

- Different features in SSAS Tabular models

- Role-playing dimensions

- How to deploy SSAS Tabular model

- How to create hierarchies

- Perspectives in SSAS tabular model

- DAX and calculated columns in SSAS tabular model

- How to create KPIs

- Partitions in SSAS tabular model

- Tabular model processing options

- Row-level security in SSAS tabular model

- Tabular model deployment via script

Whenever new features in the Tabular model will come, I will keep this course up to date.

I wish you all the best to learn how to create and deploy SSAS tabular models.

Screenshots

SSAS Tabular Model with Power BI - A comprehensive training - Screenshot_01

SSAS Tabular Model with Power BI - A comprehensive training - Screenshot_02

SSAS Tabular Model with Power BI - A comprehensive training - Screenshot_03

SSAS Tabular Model with Power BI - A comprehensive training - Screenshot_04

Reviews

Muhammad

November 2, 2023

Very Basic , I was search for cube and mdx and their differences also some complex scenarios in ssas for RLS, data modeling. Don't mind but this type of content even more informative content is available on youtube for free

Greg

October 8, 2023

The course provides good introduction to SSAS Tabular Model, but is suited more to people with some prior experience and understanding of related data modelling concepts and products rather than total beginners. Concepts such as role-playing dimensions are shown but not really explained. At 2.5 total hours it can hardly be described as "comprehensive training". The course could be improved by additional real-world examples and perhaps updated to include related cloud-based (Azure) features.

Steven

September 20, 2023

I expected more for the price paid. Was simple. And is not updated to the latest Visual Studio tools

Fuping

May 19, 2023

It is a good course, which is easy and clear. the issue is that the resolution is too low, and I hope the resolution should be at least 1028, rather than 720.

Vas

December 30, 2022

This is very helpful for refreshing your skills. Good effort by the trainer Only missing part is advance level concepts (at least some extend should be added to this course)

Gergő

January 9, 2022

Very good course, shows how to use a very comprehensive toolset of tabular SSAS. The only reason why I'm not giving five stas is the minimal explanation of what happens in the background and exactly how is it beneficial to use tabular. Still, definitely worth comleteing the course.

Smruti

August 10, 2021

This what exactly what I was looking for , Awesome Content! . However few suggestion would be to improve the Partition & Row level security parts as i did not find quite engaging , found lost somewhere , maybe some more examples with use cases would have been helpful. Please can you put an End to End project with SSAS Tabular and power BI. Thanks a lot for putting this course , Loved it!

Tessa

March 14, 2021

Lecturer is clearly knowledgeable and explained "how" to do things very well, though I would have liked more of the "why" to pick a certain method. I would have liked a quiz or two to test myself.

Charts

Price

Rating

Enrollment distribution

SSAS Tabular Model with Power BI - A comprehensive training - Distribution chart