Advanced Analysis Services

Overview

This course is designed for business intelligence developers and database professionals who are already familiar with developing and deploying basic Analysis Services solutions. It focuses on advanced design, deployment, and security concepts to elevate your skill set.

Key topics covered in this course include:

• Advanced design topics related to dimensions and partitions
• Utilizing Analysis Services features for parent-child hierarchies, financial analytics, referenced dimensions, and many-to-many relationships
• Working with write-back features in Analysis Services for both dimensions and cells
• Managing Analysis Services performance and storage through the implementation of aggregations and partitions
• Managing design and data changes following initial implementation
• Implementing alternative security scenarios

The demonstrations and features discussed in this course are primarily focused on the SQL Server 2008 R2 release, though the majority of the topics also apply to versions of Analysis Services starting from SQL Server 2005.

University:

Pluralsight

Provider:

Pluralsight

Categories:

Business Intelligence Courses

---

Taught by

Stacia Misner Varga

---

Subjects