   |
| 2074 - Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 |
| Vendor Course Code: | 2074 |
| Course Length: | 5 days |
| Course Price: | $3,100.00 |
| Availability: | Please call DDLS on 1800 U LEARN (1800 853 276) or  click here to register your interest. |
| Overview: | 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. |
| Skills Gained: | 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.
|
| Key Topics: | Module 1: Introduction to Data Warehousing and OLAP
Module 2: Introducing Analysis Manager Wizards
Module 3: Understanding Analysis Services Architecture
Module 4: Building Dimensions Using the Dimension Editor
Module 5: Using Advanced Dimension Settings
Module 6: Working with Cubes and Measures
Module 7: Case Study - Creating the Store Expense Cube
Module 8: Managing Storage and Optimization
Module 9: Processing Dimensions and Cubes
Module 10: Managing Partitions
Module 11: Implementing Calculations Using MDX
Module 12: Working with Virtual Cubes
Module 13: Using Excel as an OLAP Client
Module 14: Using Actions, Drillthrough, and Writeback
Module 15: Implementing Security
Module 16: Deploying an OLAP Solution
Module 17: Introduction to Data Mining
Module 18: Case Study - Working with the Foodmart Database |
| Target Audience: | Systems Administrators, Database Administrators |
| 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. |
