Data Warehousing: An Introduction
 

This 2 day course provides:

the students with practical techniques for designing and implementing a data warehouse in DB2. This overview will give students a foundation for understanding data warehousing technology.

Topics Covered:

The corporate view of the data warehouse, data gathering, data relationships, data design techniques, modeling, populating, transforming, project methodologies, and metadata will be discussed.

Objectives:

• Discussion of the Fundamentals and Terminology of data warehousing
• Learning the Techniques of data gathering
• Understanding Data relationships: Static and Time dependent
• Weighing the Application Requirements
• Using Modeling Tools
• Transforming, Cleansing, Loading the data
• Discussion of Methodologies for project management
• Metadata, defined within the Data Warehouse

Duration: 2 days

Delivery: Class Lecture

Audience: 

This course is for Business Analysts that will participate in the data warehousing environment, Data Base Administrators, data designers who will be building the logical model, programmers that will be using the data warehouse and users that will be using the data warehouse that require more in depth knowledge of the data warehousing environment.

Prerequisites:

The student should have some familiarity with data modeling and data base design fundamentals.

Outline:

1. Fundamentals and Terminology of Data Warehousing

Overall information strategy
Basic concepts and terminology
Legacy systems, OLTP, OLAP, ODS, Data-Mart, Data                         Warehouse, Metadata
Corporate View of the Warehouse
Organization Roles and Responsibilities
Example of a Data Warehouse

2. Building a Data Warehouse:

Methodologies for Project Management
Guidelines for Success
Proposal
Design Team
Design Plan
Requirements Analysts
Design Planning
Business Requirements
Database Design Life Cycle
Using Modeling Tools
Data Gathering
Static and Time dependent data
Data Relationships
Application Requirements
Data Models
Change Control
General System Requirements
Documentation Requirements
Metadata
Transforming, Cleansing, Loading Data

3. Physical Implementation in DB2

 System Requirements
 Security
 Implementing a Physical Design
 Physical Implementation in OS/390
 Physical Implementation in AIX

4. Using the Data Warehouse

Vendor Products
Training the users
Products: Business Objects, Mircostrategies
IBM, BMC