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

Sign In
Start Learning

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
Gain Access
This course includes:
  • 5 hours of training
  • Access on mobile app and browser
  • Certificate of Completion

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

ManuelInstructor

MANUEL QUINTANA

Training Content Manager
As a Training Content Manager with Pragmatic Works, Manuel uses his knowledge with the BI Stack (SSRS, SSIS, SSAS) to deliver exciting and engaging content. He also has experience with T-SQL, DAX and Power Pivot and is always looking to expand his knowledge. A native of Puerto Rico, Manuel graduated from the University of Central Florida and loves being involved in the world of Business Intelligence.

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

Related products

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.

 

Bonus:

• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!

Free Training Plan