2074A Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000
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 Certification exams
This course will help the student prepare for the following Microsoft Certified Professional exam:
• There is no MCP exam associated with this course