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.
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
- Introduction 2m
- Financial Parent-Child Hierarchy 2m
- Demo: Creating the Account Dimension 7m
- Account Intelligence 4m
- Demo: Defining Account Intelligence 6m
- Unary Operators 2m
- Demo: Working with Unary Operators 9m
- IsAggregatable Property 1m
- Demo: Configuring the IsAggregatable Property 3m
- Naming Template 1m
- Demo: Working with the Naming Template 3m
- Default Member 3m
- Demo: Defining a Default Member 3m
- Custom Rollup 1m
- Demo: Configuring a Custom Rollup 5m
- Parent-Child Hierarchy Considerations 5m
- Summary 3m
- Introduction 1m
- Aggregation Concepts 6m
- Query Processing 2m
- Aggregation Usage 4m
- Demo: Aggregation Usage 4m
- Aggregation Wizard Optimizations 3m
- Demo: Aggregation Wizard Optimizations 4m
- Aggregation Designer 2m
- Demo: Aggregation Designer 7m
- Usage Based Optimization 3m
- Demo: Usage Based Optimization 8m
- Summary 3m
- Introduction 1m
- Partitioning Strategy 3m
- Partition Storage 4m
- Demo: Configuring Storage Modes and ROLAP Dimensions 8m
- Demo: Adjusting ROLAP Dimension Settings for Deployment 3m
- Demo: Adding Records to a ROLAP Partition and ROLAP Dimension 3m
- Partition Design 2m
- Demo: Using the Partition Wizard 11m
- Merging Partitions 1m
- Demo: Merging Partitions 3m
- Summary 2m
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.