Implementing and Maintaining Microsoft® SQL Server® 2008 Analysis Services Training Course
Microsoft Official Curriculum Course Number: 6234
| Module 1 Introduction to Microsoft SQL Server Analysis Services |
| This module introduces common analysis scenarios and describes how Analysis Services provides a powerful platform for multidimensional OLAP solutions and data mining solutions. The module then describes the main considerations for installing Analysis Services. |
| Lessons |
| Overview of Data Analysis Solutions |
| Overview of SQL Server Analysis Services |
| Installing SQL Server Analysis Services |
Labs
- Lab : Using SQL Server Analysis Services
-
- Installing SQL Server Analysis Services
- Verifying Installation
After Completing This Goal, 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 |
| This module introduces the development tools you can use to create an Analysis Services multidimensional analysis solution, and describes how to create data sources, data source views, and cubes. |
| Lessons |
| Developing Analysis Services Solutions |
| Creating Data Sources and Data Source Views |
| Creating a Cube |
Labs
- Lab : Creating Multidimensional Analysis Solutions
-
- Creating a Data Source
- Creating and Modifying a Data Source View
- Creating and Modifying a Cube
After Completing This Goal, 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 |
| This module describes how to edit dimensions and to configure dimensions, attributes, and hierarchies. |
| Lessons |
| Configuring Dimensions |
| Defining Attribute Hierarchies |
| Sorting and Grouping Attributes |
Labs
- Lab : Working with Cubes and Dimensions
-
- Configuring Dimensions
- Defining Relationships and Hierarchies
- Sorting and Grouping Dimension Attributes
After Completing This Goal, Students will be Able To
- Configure dimensions.
- Define hierarchies.
- Sort and group attributes.
|
| Module 4 Working with Measures and Measure Groups |
| This module explains how to edit and configure measures and measure groups. |
| Lessons |
| Working With Measures |
| Working with Measure Groups |
Labs
- Lab : Working with Measures and Measure Groups
-
- Configuring Measures
- Defining Dimension Usage and Relationships
- Configuring Measure Group Storage
After Completing This Goal, Students will be Able To
- Work with measures.
- Work with measure groups.
|
| Module 5 Querying Multidimensional Analysis Solutions |
| This module introduces multidimensional expressions (MDX) and describes how to implement calculated members and named sets in an Analysis Services cube. |
| Lessons |
| MDX Fundamentals |
| Adding Calculations to a Cube |
Labs
- Lab : Querying Multidimensional Analysis Solutions
-
- Querying a Cube by Using MDX
- Creating a Calculated Member
- Defining a Named Set
After Completing This Goal, Students will be Able To
- Describe Multidimensional Expression (MDX) fundamentals.
- Add calculations to a cube.
|
| Module 6 Customizing Cube Functionality |
| This module explains how to customize a cube by implementing key performance indicators (KPIs), actions, perspectives, and translations. |
| Lessons |
| Implementing Key Performance Indicators (KPI) |
| Implementing Actions |
| Working with Perspectives |
| Working with Translations |
Labs
- Lab : Customizing Cube Functionality
-
- Implementing a KPI
- Implementing an Action
- Implementing a Perspective
- Implementing a Translation
After Completing This Goal, 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 |
| This module describes how to deploy an Analysis Services database to a production server, and how to implement security in an Analysis Services multidimensional solution. |
| Lessons |
| Deploying an Analysis Services Database |
| Securing an Analysis Services Database |
Labs
- Lab : Deploying and Securing an Analysis Services Database
-
- Deploying an Analysis Services Database
- Securing an Analysis Services Database
After Completing This Goal, Students will be Able To
- Deploy an Analysis Services database.
- Secure an Analysis Services database.
|
| Module 8 Maintaining a Multidimensional Solution |
| This module discusses the maintenance tasks associated with an Analysis Services solution, and describes how administrators can use the Analysis Services management tools to perform them. |
| Lessons |
| Configuring Processing |
| Logging, Monitoring, and Optimizing an Analysis Services Solution |
| Backing Up and Restoring an Analysis Services Database |
Labs
- Lab : Maintaining a Multidimensional Solution
-
- Configuring Processing
- Implementing Logging and Monitoring
- Backing Up and Restoring an Analysis Services Database
After Completing This Goal, 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 |
| This module introduces data mining, and describes how to implement data mining structures and models. It then explains how to validate data model accuracy. |
| Lessons |
| Overview of Data Mining |
| Creating a Data Mining Solution |
| Validating Data Mining Models |
Labs
- Lab : Introduction to Data Mining
-
- Creating a Data Mining Structure
- Adding a Data Mining Model
- Exploring Data Mining Models
- Validating Data Mining Models
After Completing This Goal, Students will be Able To
- Describe data mining.
- Create a data mining solution.
- Validate data mining models.
|
Current User's Login:
Fill out the information as a first time user:
|
|
Live Instructor-led Implementing and Maintaining Microsoft® SQL Server® 2008 Analysis Services Training Dates
|
Filter By...
| Providers: |
|
Location: |
|
| Date Range: |
|
| Provider |
Location |
Date |
Type |
Duration |
Price |
0 course(s) |
|
Online Self-Paced Implementing and Maintaining Microsoft® SQL Server® 2008 Analysis Services Training Options
|
No online results
|