SQL Server Analysis Services for beginners -SSAS

Course level: All Levels

Categories Data Science
Total Enrolled 1
Last Update February 6, 2022

About Course

Create and deploy a Tabular Data Model

Description

Analysis Services is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data model capabilities for business intelligence (BI), data analysis, and reporting applications such as Power BI, Excel, Reporting Services, and other data visualization tools. Analysis Services is available in different platforms

Tabular models in Analysis Services are databases that run in-memory or in DirectQuery mode, connecting to data from back-end relational data sources. By using state-of-the-art compression algorithms and multi-threaded query processor, the Analysis Services VertiPaq analytics engine delivers fast access to tabular model objects and data by reporting client applications like Power BI and Excel.

What Will I Learn?

Setup Analysis Services Environment
Create a Tabular Model
Connect to data source
Create Table Relationships
Create Calculated Columns
Create Measures
Create Key Performance Indicators

Topics for this course

34 Lessons

01 – Installations

001 Introduction00:00:00

002 What is SQL Server00:00:00

003 SQL Server Editions00:00:00

004 Download SQL Server00:00:00

005 Install SQL Server00:00:00

006 Install SSMS00:00:00

007 Connect SSMS to SQL Server00:00:00

008 Install Sample Database00:00:00

010 Installing SSAS00:00:00

011 Connecting to SSAS00:00:00

012 What is Visual Studio00:00:00

013 Installing Visual Studio00:00:00

014 Installing SSDT00:00:00

015 Installing SSDT Designers00:00:00

02 – Creating a Tabular Model

001 Create a tabular model project00:00:00

002 Explore tabular model authoring00:00:00

003 Create a connection to data source00:00:00

004 Transform and import data00:00:00

005 Mark as date Table00:00:00

006 Create Table Relationships00:00:00

007 Creating Calculated Columns Part 100:00:00

008 Creating Calculated Columns Part 200:00:00

009 Creating Measures Part 100:00:00

010 Creating Measures Part 200:00:00

011 Creating Measures Part 300:00:00

012 Creating key performance indictators00:00:00

013 Creating Perspectives00:00:00

014 Creating Hierarchies Part 100:00:00

015 Creating Hierarchies Part 200:00:00

016 What are Partitions00:00:00

017 Creating Partitions00:00:00

018 Creating Roles00:00:00

019 Analyze in Excel00:00:00

020 Deploying your Model00:00:00