Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000

Code: 2074
Course duration: 5 days

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


Duration: 5 Days.


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


  • 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

Guaranteed to Run

2020-03-18 09:00 to 2020-03-20 17:00
Newark, New Jersey (Virtual Instructor-Led)
2020-03-18 09:00 to 2020-03-20 17:00
Attend Online
2020-03-09 09:00 to 2020-03-13 17:00
Attend Online
2020-03-04 09:00 to 2020-03-06 17:00
NYC-23rd Street (Virtual Instructor-Led)
2020-03-02 09:00 to 2020-03-06 17:00
Fort Lauderdale, Florida (Virtual Instructor-Led)
09:00 to 17:00
Secaucus, New Jersey (Instructor-Led)

Course Reviews

No reviews found for this course.

Be the first to write a review