Module 1: Introduction to Microsoft SQL Server Analysis Services
Lessons:
- Overview of Data Analysis Solutions
- Overview of SQL Server Analysis Services
- Installing SQL Server Analysis Services
Lab: Using SQL Server Analysis Services
- (Level 200) Installing SQL Server Analysis Services
- (Level 200) Verifying Installation
Module 2: Creating Multidimensional Analysis Solutions
Lessons:
- Developing Analysis Services Solutions
- Creating Data Sources and Data Source Views
- Creating a Cube
Lab: Creating Multidimensional Analysis Solutions
- (Level 200) Creating a Data Source
- (Level 200) Creating and Modifying a Data Source View
- (Level 200) Creating and Modifying a Cube
Module 3: Working with Cubes and Dimensions
Lessons:
- Configuring Dimensions
- Defining Attribute Hierarchies
- Sorting and Grouping Attributes
Lab: Working with Cubes and Dimensions
- (Level 200) Configuring Dimensions
- (Level 200) Defining Relationships and Hierarchies
- (Level 200) Sorting and Grouping Dimension Attributes
Module 4: Working with Measures and Measure Groups
Lessons:
- Working with Measures
- Working with Measure Groups
Lab: Working with Measures and Measure Groups
- (Level 200) Configuring Measures
- (Level 200) Defining Dimension Usage and Relationships
- (Level 200) Configuring Measure Group Storage
Module 5: Querying Multidimensional Analysis Solutions
Lessons:
- MDX Fundamentals
- Adding Calculations to a Cube
Lab: Querying Multidimensional Analysis Solutions
- (Level 200) Querying a Cube by Using MDX
- (Level 200) Creating a Calculated Member
- (Level 200) Defining a Named Set
Module 6: Customizing Cube Functionality
Lessons:
- Implementing Key Performance Indicators
- Implementing Actions
- Implementing Perspectives
- Implementing Translations
Lab: Customizing Cube Functionality
- (Level 200) Implementing a KPI
- (Level 200) Implementing an Action
- (Level 200) Implementing a Perspective
- (Level 200) Implementing a Translation
Module 7: Deploying and Securing an Analysis Services Database
Lessons:
- Deploying an Analysis Services Database
- Securing an Analysis Services Database
Lab: Deploying and Securing an Analysis Services Database
- (Level 200) Deploying an Analysis Services Database
- (Level 200) Securing an Analysis Services Database
Module 8: Maintaining a Multidimensional Solution
Lessons:
- Configuring Processing
- Logging, Monitoring, and Optimizing an Analysis Services Solution
- Backing Up and Restoring an Analysis Services Database
Lab: Maintaining a Multidimensional Solution
- (Level 200) Configuring Processing
- (Level 200) Implementing Logging and Monitoring
- (Level 200) Backing Up and Restoring an Analysis Services Database
Module 9: Introduction to Data Mining
Lessons:
- Overview of Data Mining
- Creating a Data Mining Solution
- Validating Data Mining Models
Lab: Introduction to Data Mining
- (Level 200) Creating a Data Mining Structure
- (Level 200) Adding a Data Mining Model
- (Level 200) Exploring Data Mining Models
- (Level 200) Validating Data Mining Models
|
