Course: MS2796 Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services

The purpose of this three day course is to teach business intelligence (BI) professionals working in enterprise environments how to design a multidimensional solution architecture that supports their BI solution. Delegates will go through the entire process-from capturing business and technical requirements, to deploying a multidimensional solution, to production.

Delegates will also be taught to develop custom functionality and optimize a multidimensional solution.

The course focuses on the planning and design aspects of an analysis solution and does not teach delegates how to create Analysis Services database objects or how to use the development tools provided with SQL Server 2005.

The course consists of 9 Modules:

Module 1: Capturing Business and Technical Requirements
Module 2: Designing and Implementing a Logical OLAP Solution Architecture
Module 3: Designing Physical Storage for a Multidimensional Solution
Module 4: Creating Calculations
Module 5: Extending Cube Functionality
Module 6: Designing an Analysis Services Infrastructure
Module 7: Deploying a Multidimensional Solution into Production
Module 8: Optimizing an OLAP Solution
Module 9: Implementing Data Mining

By the end of the course, delegates will be able to:

• Capture the business and technical requirements for an analysis solution.
• Design and implement a logical Online Analytical Processing (OLAP) solution architecture.
• Design physical storage for a multidimensional solution.
• Create calculated members and named sets.
• Implement Key Performance Indicators (KPIs), actions, and stored procedures.
• Design the infrastructure for an OLAP solution.
• Deploy and secure an Analysis Services solution in a production environment.
• Monitor and optimize an Analysis Services solution.
• Implement a data mining solution.