This three-day instructor-led course (Microsoft SQL Server 2008 Analysis Services: Implementing and Maintaining) teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.
Course Outline
Introduction to Microsoft SQL Server Analysis Services
- Describe data analysis solutions.
- Describe the key features of SQL Server Analysis Services.
- Install SQL Server Analysis Services.
Creating Multidimensional Analysis Solutions
- Develop Analysis Services solutions.
- Create a data source and a data source view.
- Create a cube.
Working with Cubes and Dimensions
- Configure dimensions.
- Define hierarchies.
- Sort and group attributes.
Working with Measures and Measure Groups
- Work with measures.
- Work with measure groups.
Querying Multidimensional Analysis Solutions
- Describe Multidimensional Expression (MDX) fundamentals.
- Add calculations to a cube.
Customizing Cube Functionality
- Implement Key Performance Indicators (KPIs).
- Implement actions.
- Implement perspectives.
- Implement translations.
Deploying and Securing an Analysis Services Database
- Deploy an Analysis Services database.
- Secure an Analysis Services database.
Maintaining a Multidimensional Solution
- Configure processing settings.
- Log, monitor, and optimize an Analysis Services solution.
- Back up and restore an Analysis Services database.
Introduction to Data Mining
- Describe data mining.
- Create a data mining solution.
- Validate data mining models.