Microsoft SQL Server Analysis Services Tabular

• You will get familiar with SQL Server Analysis Services
• You will learn in which products the tabular engine is used
• You will learn how to create your own tabular model, understand the difference between dimension and fact tables, create relationships between them, and define hierarchies
• You will learn the basics of the DAX language
• You will master the creation of measures, calculated tables, and get introduced to time intelligence calculations
• You will learn how to deploy the created model to a production environment, secure it properly, and automate essential maintenance tasks

• Basic understanding of data warehouse concepts at the level of course GOC645
• Basic knowledge of relational databases and T-SQL at the level of course GOC277

1. Introduction to Analysis Services and the Tabular Engine
• Overview of SQL Server Analysis Services
• Key concepts and use cases
• Learn which products use the tabular engine (SSAS, Power BI, Power Pivot)
2. Creating a Tabular Model in Analysis Services
• Dimension and fact tables
• Relationships between tables
• Hierarchies
3. DAX Language
• Calculated columns
• Measures
• Calculated tables
4. Expanding Business Logic with Examples
• Manipulating calculation context
• Time intelligence calculations
• Iterators
• Calculation Groups
5. Performance Optimization
• VertiPaq storage
• Partitioning
• Factors negatively affecting performance
6. Basics of Querying in DAX
• Introduction to DAX queries
• Application in SQL Server Reporting Services (optional)
7. Deployment to On-Premises or Cloud
• Deployment to on-premises server
• Deployment to Microsoft Azure Analysis Services
• Deployment to Microsoft Fabric workspaces
8. Roles and Security
• Designing a security model
• Row-level security in roles
9. Automation of Management and Maintenance
• Key steps in management and maintenance (processing, backup, partitioning)
• Demonstration of automation on a physical or virtual server
• Demonstration of automation in the cloud

Previous courses

Implementation of a data warehouse and ETL processes using Microsoft SQL Server Integration Services. [GOC645]

Next courses

DAX language and data model creation for Power BI and SQL Server Analysis Services [GOC644]

Related courses

Data Analysis in Microsoft Fabric [GOC682]