|
|
|
Module 1: Introduction to Microsoft SQL Server 2005 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.
- Overview of Data Analysis Solutions
- Overview of SQL Server 2005 Analysis Services
- Installing SQL Server 2005 Analysis Services
Skills
- Describe data analysis solutions.
- Describe the key features of Microsoft SQL Server 2005 Analysis Services.
- Install SQL Server 2005 Analysis Services.
Top |
|
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.
- Developing Analysis Services Solutions
- Data Sources and Data Source Views
- Creating a Cube
- Lab: Creating a Multidimensional Analysis Solution
Skills
- Develop Analysis Services solutions.
- Create a data source and a data source view.
- Create a cube.
Top |
|
|
Module 3: Working with Dimensions
- This module describes how to edit dimensions and to configure dimensions, attributes, and hierarchies.
- Configuring Dimensions
- Defining Hierarchies
- Sorting and Grouping Attributes
- Lab: Defining Dimensions
Skills
- Configure dimensions.
- Define hierarchies.
- Sort and group attributes.
Top |
|
Module 4: Working with Measures and Measure Groups
- This module explains how to edit and configure measures and measure groups.
- Working with Measures
- Working with Measure Groups
- Lab: Configuring Measures and Measure Groups
Skills
- Work with measures.
- Work with measure groups.
Top |
|
|
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.
- MDX Fundamentals
- Adding Calculations to a Cube
- Lab: Querying a Cube
Skills
- Describe Multidimensional Expression (MDX) fundamentals.
- Add calculations to a cube.
Top |
|
Module 6: Customizing Cube Functionality
- This module explains how to customize a cube by implementing key performance indicators (KPIs), actions, perspectives, and translations.
- Implementing Key Performance Indicators
- Implementing Actions
- Implementing Perspectives
- Implementing Translations
- Lab: Customizing a Cube
Skills
- Implement Key Performance Indicators (KPIs).
- Implement actions.
- Implement perspectives.
- Implement translations.
Top |
|
|
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.
- Deploying an Analysis Services Database
- Securing an Analysis Services Database
- Lab: Deploying and Securing an Analysis Services Database
Skills
- Deploy an Analysis Services database.
- Secure an Analysis Services database.
Top |
|
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.
- Configuring Processing Settings
- Logging, Monitoring, and Optimizing an Analysis Services Solution
- Backing Up and Restoring an Analysis Services Database
- Lab: Maintaining an Analysis Services Database
Skills
- Configure processing settings.
- Log, monitor, and optimize an Analysis Services solution.
- Back up and restore an Analysis Services database.
Top |
|
|
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.
- Overview of Data Mining
- Creating a Data Mining Solution
- Validating Data Mining Models
- Lab: Implementing Data Mining
Skills
- Describe data mining.
- Create a data mining solution.
- Validate data mining models.
Top |
|
|
|
|
Exams:
-
There are no exams directly associated with this course
|
|
Price Options ex VAT:
Classroom Training
? |
Distance Learning
? |
eLearning Options
? |
Book Learning
? |
£
1050
(€1513)
|
£
674.00
(€971)
|
- |
No Books Supported for Course at present
|
|
|
Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 12 June 2008
|
|
