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