Introduction
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.
At Course Completion
At the end of the course,
students will be able to:
- 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.
Microsoft Certified Professional Exams
This course will help the
student prepare for the following Microsoft Certified Professional exam:
There is no MCP exam
associated with this course
Prerequisites
Before attending this course,
students must have:
- A basic understanding of database design,
administration, and implementation concepts.
- A satisfactory level of comfort within the
Microsoft Windows® 2000 environment.