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.
Target Audience:
Pre-requisites:
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.
At Course Completion:
After completing this 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.
