Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000

Code: 2074
Course duration: 5 days
Price:

2074: Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000

 

Duration: 5 Days.

Prerequisites:

Before attending this course, students must have:

  • A basic understanding of database design, administration, and implementation concepts
  • satisfactory level of comfort within the Microsoft Windows 2000 environment

Course Description:

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

Objectives:

  • Define the term OLAP and its role within data warehousing
  • Design multidimensional data marts by using star and snowflake schemas
  • Recognize the fundamental components of a cube
  • Understand the architecture of Analysis Services
  • Create dimensions from relational dimension tables
  • Understand the many types of dimensions
  • Utilize various dimension properties and settings
  • Design OLAP dimensions based on underlying source data
  • Create cubes by using the Cube Wizard and Cube Editor
  • Create and manipulate measures
  • Develop and understand virtual cubes
  • Design cube storage and aggregations
  • Update dimensions and cubes when source data changes
  • Optimize the processing of dimensions and cubes
  • Create partitions within cubes
  • Implement simple calculations by using multidimensional expressions (MDX) and calculated members
  • Use Microsoft Excel 2000 as an OLAP front-end application
  • Understand how data mining fits within OLAP and the Microsoft data warehousing framework
  • Employ actions, drillthrough, and writeback for data analysis
  • Design and implement cube and dimension security
  • Automate the processing of dimensions and cubes through Data Transformation Services (DTS)
  • Create cubes and virtual cubes based on end-user requirements

Lesson 1: Introduction to Data Warehousing and OLAP

Introducing Data Warehousing

Defining OLAP Solutions

Understanding Data Warehouse Design

Understanding OLAP Models

Course Reviews

No reviews found for this course.

Be the first to write a review