Building Tabular Models in SSAS

Overview

Import data from different sources, build relationships, and enhance a model's usability to ensure it finds widespread adoption in your organization. At the end of this course, you'll know how to build a semantic tabular model.

Analysis Services is an analytical database engine that lets you build business intelligence data models so your users can connect to them 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 need to use SSAS in your project even when you already have a data warehouse. Next, you will discover how to import data from different sources, define relationships between tables, create 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 finish this course, you will possess the knowledge and advanced data modeling skills needed to build enterprise-grade tabular models.

University: Provider: Pluralsight

Categories: SQL Courses, DAX (Data Analysis Expressions) Courses, SSAS (SQL Server Analysis Services) Courses, KPIs (Key Performance Indicators) Courses

Syllabus

Taught by

Ravikiran Srinivasulu

Tags