Description
Course info
Level
Intermediate
Updated
Mar 10, 2021
Duration
3h 21m
Description

SQL Server Analysis Services is one of the most widely used tools to analyze businesses with decades of innovations and features that have kept it as leader for business intelligence solutions. In this course, Managing SSAS Models, you will learn how you can manage and improve performance for your multidimensional and tabular models. First, you will explore using backup and restore to get a non-production database available for modification of its object model. Then, you will see the steps necessary to add a new attribute to an existing dimension. Finally, you will learn how processing will be changed to use partitioning to reduce time needed for nightly processing of the database. When you're finished with this course, you'll have the skills and knowledge of managing SSAS models needed to effectively maintain SQL Server Analysis Service databases.

About the author
About the author

Patrick Neborg is a Solution Architect for Aon. Patrick has been developing software solutions for over 20 years. Today, he focuses on Cloud Solutions.

More from the author
Deploying an Application on AWS
Beginner
2h 32m
Jun 6, 2019
More courses by Patrick Neborg
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi, everyone. My name is Patrick Neborg, and welcome to my course, Managing SSAS Models. I'm a software and data architect at Berkadia. SQL Server Analysis Services is one of the most widely used tools to analyze business data with many decades of innovations and features that has kept it as a leader for business intelligence solutions. In this course, we're going to reveal how you can manage and improve performance for your multidimensional and tabular models. This is an advanced topic where you should have familiarity with Analysis Services and processing models using Visual Studio's SQL Server Data Tools or Analysis Services Deployment Wizard. Some of the major topics that we'll cover include XMLA as an underlying technology used for both multidimensional and tabular models, changing and maintaining your models using XMLA for multidimensional models and TMSL for tabular models, switching your development environment from multidimensional over to tabular, and strategies that you can apply to improve your Analysis Services processing and partitioning. By the end of this course, you'll know how to manage both your multidimensional and tabular models and know how to select the correct Analysis Services model type to meet your data analysts' and business intelligence needs. Before beginning this course, you should be familiar with creating and processing a model in Analysis Services using Visual Studio's SQL Server Data Tools. From here, you should feel comfortable diving into SQL Server Analysis Services with courses on securing Analysis Services models, advanced MDX and DAX queries, and using M power queries. I hope you join me on this journey to learn about how to manage Analysis Services models with the Managing SSAS Models course at Pluralsight.