This course takes you through managing an Analysis Services database, both multidimensional and tabular, in the areas of adding an attribute to a dimension, partitioning the fact data, and updating the processing of the model with automation.
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.
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.