Introduction to Data Warehouse - DW00 ( 1 Day )
Price: $600.00
Course Outline
Download Course Outline (PDF)
View Course Schedule
Abstract/Overview
This seminar explains the key concepts of Data Warehousing and examines the architectural choices, delivery techniques, and enabling technologies most effective for Data Warehouse delivery.
Audience - Who Should Attend?
Business and systems analysts who will be attending the Data Warehouse Design Workshop; business managers who are responsible for the planning and management of Data Warehouse projects; user managers who want to know how Data Warehousing will help them.
Prerequisite
No systems development experience is assumed, however, a basic understanding of Information Technology would be helpful.
Objective
- Understand the characteristics of Data Warehouses that distinguish them from operational databases.
- Examine the architectural alternatives for implementing Data Warehouses and Data Marts.
- Learn the benefits of using the RAD approach for Data Warehouse development.
- Understand the importance of Metadata in the success of the warehouse initiative.
- Learn the hardware and software architecture options to be considered when implementing the warehouse.
- Be able to make important decisions and resolve issues that affect the implementation and management of the warehouse.
Content
Introduction
- Objectives and Success Factors of Today's Business
- IT Challenges
- Data Warehousing: A Strategic Solution
Data Warehouse Characteristics
- Role of the Data Warehouse
- Data Warehouse vs. Operational Database
- Basic Data Warehouse Characteristics
- Data Mart vs. Data Warehouse
Data Warehouse Architecture
- Effective vs. Ineffective Architectures
- Evaluating Architectural Alternatives
- Understanding Data Warehouse Users
- Selecting the Right Architecture
Methodology Overview
- Rapid Application Development
- Gathering User's Requirements
- Data Warehouse Analysis
- Data Warehouse Design
Metadata
- What is Data Warehouse Metadata?
- Role of Metadata
- Types of Metadata
- Metadata Repository
- Practical Considerations
Warehouse Technology
- Typical Components
- Data Extraction
- Data Transformation
- Data Cleansing
- Date Loading
- Data Storage
- Data Access
- Issues and Alternative Tools for the Components
- Operational Issues
Management and Implementation of the Data Warehouse
- Important Decisions
- Critical Success Factors
- Obstacles to Success
- Team Dynamics and Composition
- Monitoring the Data Warehouse
- Selling the Concept
Course Schedule
| Start Date | Location | Class Code | Duration (days) |
| Wed, Sep 22 2010 | Ottawa | P36172 | 1 |
| Thu, Sep 23 2010 | Toronto | P36166 | 1 |
| | | | |
top