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 the tools to build data warehousing and decision support system solutions.
Lesson 1:
- Hierarchies & Attributes
- Dimension Hierarchies
- Demo: Attribute Relationships
- Demo: Key Columns.
Lesson 2:
- Dimension Properties
- Demo: Dimension Properties
- Demo: Visibility
- Demo: Sorting.
Lesson 3:
- Measure Calculations
- Calculations
- Ratio or Percentage
- Demo: Calculations
- Demo: Fixing Calculations
- Demo: Slicing and Dicing.
Lesson 4:
- Key Performance Indicators
- Defining a KPI
- Demo: KPIs
- Demo: Displaying KPIs
- Demo: Components
- Named Sets
- Demo: Named Sets.
Lesson 5:
- Perspectives
- Demo: Perspectives
- Demo: Displaying Perspectives
- Creating Translations
- Demo: Translations.