• Back to Microsoft Courses

Overview

This course provides delegates with the knowledge and skills necessary to design, implement, and deploy OLAP solutions by using Microsoft SQL Server 2000 Analysis Services.

Prerequisites

Delegates should have a basic understanding of database design, administration, and implementation concepts and a satisfactory level of comfort within the Microsoft Windows 2000 environment.

Delegates will learn how to

• Design multidimensional data marts by using star and snowflake schemas
• Define the term OLAP and its role within data warehousing
• Design OLAP dimensions based on underlying source data
• Design cube storage and aggregations
• Use Microsoft Excel 2000 as an OLAP front-end application
• Create cubes and virtual cubes based on end-user requirements

Outline

Module 1: Introduction to Data Warehousing and OLAP

Module 2: Introducing Analysis Manager Wizards

Module 3: Understanding Analysis Services Architecture

Module 4: Building Dimensions Using the Dimension Editor

Module 5: Using Advanced Dimension Settings

Module 6: Working with Cubes and Measures

Module 7: Case Study – Creating the Store Expense Cube

Module 8: Managing Storage and Optimization

Module 9: Processing Dimensions and Cubes

Module 10: Managing Partitions

Module 11: Implementing Calculations Using MDX

Module 12: Working with Virtual Cubes

Module 13: Using Excel as an OLAP Client

Module 14: Using Actions, Drillthrough, and Writeback

Module 15: Implementing Security

Module 16: Deploying an OLAP Solution

Module 17: Introduction to Data Mining

Module 18: Case Study – Working with the Foodmart Database

• Back to Top
• Back to Microsoft Courses