SSAS 2014, Part 04 of 10: Cube Advanced Features

In this course, you will learn how to use Microsoft SQL Server 2014 Analysis Services (SSAS). This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server developer information on Advanced dimensions, Many-to-Many relationships, Performance and Security.

Lesson 1:

• Advanced Dimensions
• Degenerate Dimension
• Create Degenerate Dimension
• Demo: Degenerate Dimension
• Parent-Child Dimension
• Demo: Parent-Child Dimension
• Role Playing Dimension
• Demo: Role Playing Dimension
• Referenced Dimension.

Lesson 2:

• Many to Many Relationship
• Many To Many - Bridge Data
• Many to Many - New Dimension
• Many to Many - Measure Group
• Many to Many - Dimension Usage
• Demo: Many to Many
• Demo: Many to Many in Excel
• Advanced Calculations
• Ratio to Parent
• Ratio to Root
• Scope
• Demo: Advanced Calculations.

Lesson 3:

• Cube Performance
• Aggregations
• Usage Optimizer
• Demo: Aggregations
• Partitions
• Partition Storage
• Demo: Partitions.

Lesson 4:

• Security
• Dimension Data.