Simple play icon Course
Skills Expanded

Advanced Analysis Services

by Stacia Misner Varga

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.

What you'll learn

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).

Table of contents

About the author

Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.

Ready to upskill? Get started