NEED HELP? TALK TO AN EXPERT (904) 638-5743

Advanced SSAS

WHAT YOU'LL LEARN

  • How to create complex reports that use Analysis Services as a data source and custom code assemblies
  • How to master advanced topics of Reporting Services like scaled-out deployment, .Net integration and monitoring Reporting Services usage
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course Description

This course is designed to take you to the next level in your understanding of SQL Server Analysis Services (SSAS). We use a variety of exclusive lectures on SQL Server internals, as well as hands-on lab exercises to back up the material taught.

 

Click here for a downloadable PDF

Outline

 

Module 00 | Understanding the SSAS Ecosystem
27m 11s total

 

Module 00A | Understanding the SSAS Ecosystem
27m 11s

 

Module 01 | Optimizing Dimension Usability
37m 29s total

 

Module 01A | Optimizing Dimension Usability
37m 29s

 

Module 02 | Advanced Dimension Design
62m 33s total

 

Module 02A | Advanced Dimension Design
62m 33s

 

Module 03 | Advanced Partition Design
51m 31s total

 

Module 03A | Advanced Partition Design
51m 31s

 

Module 04 | Distinct Count Measure Groups
19m 42s total
Module 04A | Distinct Count Measure Groups
19m 42s

 

Module 05 | Advanced Aggregation Design
73m 22s total

 

Module 05A | Advanced Aggregation Design
73m 22s

 

Module 06 | Memory Management
15m 00s total

 

Module 06A | Memory Management
15m 00s

 

Module 07 | MDX Query Performance & Optimization
14m 55s total

 

Module 07A | MDX Query Performance & Optimization
14m 55s

Instructor

DUSTIN RYAN

Training Content Manager
Dustin is a Microsoft Solution Architect and was previously a Business Intelligence Consultant with Pragmatic Works. Dustin has provided business intelligence solutions for clients whose issues revolve around SSRS, SSIS and SSAS.

System Requirements

  • Windows Server or Windows 10
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer or Enterprise Edition 2016/2017/2019
    • SQL Server Database Engine
    • SQL Server Analysis Services Multidimensional
    • SQL Server Data Tools
    • SQL Server Management Studio
    • Follow this installation guide to ensure all items are installed correctly

What to Know Before Class

This class assumes that you have a strong understanding of SSAS fundamentals. For example, you should already know and use a majority of the functions in basic cube development before attending this class. While it is not mandatory, it is ideal to have an instance of Analysis Services to follow some sections of the class.

REVIEWS

That was great and thank you!

Anonymous

Pending reviews - check back later

Pending reviews - check back later

Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required