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: