Implementing and Maintaining Microsoft SQL Server2008 Analysis Services

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

After completing this module, students will be able to:

• Describe data analysis solutions.
• Describe the key features of SQL Server Analysis Services.
• Install SQL Server Analysis Services.

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

After completing this module, students will be able to:

• Develop Analysis Services solutions.
• Create a data source and a data source view.
• Create 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

After completing this module, students will be able to:

• Configure dimensions.
• Define hierarchies.
• Sort and group 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

After completing this module, students will be able to:

• Work with measures.
• Work with measure groups.

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

After completing this module, students will be able to:

• Describe Multidimensional Expression (MDX) fundamentals.
• Add calculations to a cube.

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

After completing this module, students will be able to:

• Implement Key Performance Indicators (KPIs).
• Implement actions.
• Implement perspectives.
• Implement translations.

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

After completing this module, students will be able to:

• Deploy an Analysis Services database.
• Secure 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

After completing this module, students will be able to:

• Configure processing settings.
• Log, monitor, and optimize an Analysis Services solution.
• Back up and restore 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

After completing this module, students will be able to:

• Describe data mining.
• Create a data mining solution.
• Validate data mining models.