Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Advanced Analysis Services

via Pluralsight

Overview

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

Syllabus

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

Taught by

Stacia Misner Varga

Reviews

4.6 rating at Pluralsight based on 189 ratings

Start your review of Advanced Analysis Services

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.