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.
Author Name: Patrick Neborg
Author Description:
Patrick has over 20 years experience implementing SOA solutions that utilize both web and desktop clients primarily using Microsoft’s development technology stack. Currently, he utilizes C# and JScript along with T-SQL/LINQ and has previously worked extensively with other technologies such as VB.NET and WCF. In addition to implementing client specified solutions, Patrick implements Agile process based solutions utilizing Team Foundation Server (TFS). Over time he has taken on various technical … more

Table of Contents

• Course Overview
  1min
• Multidimensional Models
  36mins
• Multidimensional Models Processing and Partitions
  60mins
• Tabular Models
  51mins
• Tabular Models Processing and Partitions
  48mins
• Summary
  2mins