This class is designed to take you to the next level in your understanding of SQL Server 2008/2008R2/2012/2014/2016 Analysis Services (SSAS). You will learn how to build tier 1 Analysis Services solutions that will scale, while understanding all the internals to help you back up these best practices you will be implementing. This class will focus on the architecture, design, scaling and internals that make Analysis Services the powerful analytics platform of choice.
Overview
COURSE DIFFICULTY
COURSE DURATION
5h 43m
Skills Learned
After completing this online training course, students will be able to:
Develop analytical models with SQL Server Analysis Services
Write MDX queries for multidimensional analysis
Design and manage cube partitions
Write T-SQL queries for data retrieval and manipulation
Database Administrators, Data Analysts
Foundational SQL Server knowledge
01. Understanding the SSAS Ecosystem
02. Optimizing Dimension Usability
03. Advanced Dimension Design
04. Advanced Partition Design
05. Distinct Count Measure Groups
06. Advanced Aggregation Design
07. Memory Management
08. MDX Query Performance & Optimization
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Develop analytical models with SQL Server Analysis Services
Write MDX queries for multidimensional analysis
Design and manage cube partitions
Write T-SQL queries for data retrieval and manipulation
WHO SHOULD ATTEND
Database Administrators, Data Analysts
PREREQUISITES
Foundational SQL Server knowledge
COURSE OUTLINE
01. Understanding the SSAS Ecosystem
02. Optimizing Dimension Usability
03. Advanced Dimension Design
04. Advanced Partition Design
05. Distinct Count Measure Groups
06. Advanced Aggregation Design
07. Memory Management
08. MDX Query Performance & Optimization
