Expanded

Tuning SSAS Models

This course explains the tools and techniques that you need to diagnose why multidimensional and tabular queries might be performing slowly and demonstrates the actions you can take to improve query performance.
Course info
Level
Advanced
Updated
Mar 10, 2020
Duration
3h 3m
Table of contents
Course Overview
Monitoring Multidimensional Query Performance
Improving Multidimensional Query Performance
Improving Multidimensional Model Design for Performance
Monitoring Tabular Query Performance
Improving Tabular Query Performance
Managing Tabular Memory
Description
Course info
Level
Advanced
Updated
Mar 10, 2020
Duration
3h 3m
Description

When you have users complaining about slow multidimensional and tabular queries, you need to know how to determine where the cause of the problem lies. In this course, Tuning SSAS Models, you will gain the ability to diagnose the source of query performance problems and apply the appropriate techniques to resolve those problems. First, you will discover how to determine whether the query bottleneck is in the formula engine or the storage engine. Next, you will learn whether you need to rewrite queries or modify the multidimensional or tabular model to resolve the query bottleneck. Finally, you will explore how to optimize tabular models for better memory management for query performance - and as a side benefit, this optimization will also benefit processing performance. When you are finished with this course, you will have the skills and knowledge of tuning Analysis Services needed to get the best query performance possible.

About the author
About the author

Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.

More from the author
Getting Started with Power BI
Beginner
4h 56m
Sep 3, 2021
Modeling Data in Power BI
Beginner
4h 56m
May 12, 2021
Building Your First Power BI Report
Beginner
1h 31m
Mar 1, 2021
More courses by Stacia Misner Varga
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is SSHD Azure Varga, and welcome to my course tuning. SSH, CSS. I'm a consultant and author at data Inspirations. Helping people like you learn how to use, build and maintain multidimensional are tabular models. Now we build models in SQL Server analysis services SSH s for short, whether we're building multi dimensional models or tabular models or both. And our goal is to enable people to analyze data quickly. But sometimes that experience could be a real drag. Queries run slowly. Oh, no. What's going on in this course? We're going to explore the reasons why your models might not behave the way that you intend and what you could do about it. Some of the major topics that we're going to cover include what's happening behind the scenes on the server during query execution, and that's going to help you know whether the slowdown is caused in the query itself or in the model, and you'll see what steps you could take to fix bottlenecks and how to measure the effect of the changes that you make. By the end of this course, you'll have a tool kit ready to use that will help you diagnose slow queries, and you'll have an action plan to implement once you know where the source of the problem lies. Before beginning this course, you should be familiar with developing analysis services either multidimensional, more tabular models or both. And you should have a basic understanding of the respective query languages MDX for multi dimensional models and DAX for tabular models. And you can certainly find courses here A to Pluralsight to help you learn more on these topics. I hope you'll join me on this journey to learn how to conquer your slow query blues with the tuning SSH s course here a Pluralsight.