Managing SSAS Models
Offered By: Pluralsight
Course Description
Overview
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.
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.
Taught by
Patrick Neborg
Related Courses
Introduction to DatabasesMeta via Coursera Web Development
Udacity Introduction to Data Science
University of Washington via Coursera Datenmanagement mit SQL
openHPI Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX