Advanced Analysis Services

This course is for business intelligence developers and database professionals who understand how to develop and deploy a basic Analysis Services solution and need to learn advanced design, deployment, and security concepts.

This course covers advanced design topics related to dimensions and partitions. It explains how to utilize Analysis Services features for parent-child hierarchies, financial analytics, referenced dimensions and many-to-many relationships. It also demonstrates how to work with write back in Analysis Services for both dimensions and cells. In addition, this course provides guidance for managing Analysis Services performance and storage through the implementation of aggregations and partitions. Furthermore, this course expands topics introduced in the Analysis Services Fundamentals course by explaining how to manage design and data changes following initial implementation and how to implement alternative security scenarios. The features and demonstrations in this course focus on the SQL Server 2008 R2 release, although most topics also apply to all versions of Analysis Services (SQL Server 2005 and later).

• Advanced Design Techniques Part I 59mins
• Advanced Design Techniques Part II 31mins
• Writeback 22mins
• Aggregations 47mins
• Partitions 40mins
• Deployment 39mins
• Advanced Security Topics 31mins