Join our Training Mailing List

To receive notifications of upcoming class schedules via e-mail, please sign-up below (all fields required).

Note: Please use the Contact Us page to send specific inquiries regarding our training courses.

Data Warehousing Training

What’s Different About this Training Course?

This training course teaches a vendor-independent approach and methodology for data warehousing. 

Course Objectives

The course introduces participants to all phases of a data warehousing initiative:

• Planning
• Schema Design
• Extract, Transform, Load (ETL) Design and Development
• Metadata Management
• Front-end Development
• Data Quality Management
• Administration and Support of a Production Warehouse

Prerequisites

• Understanding of SQL
• Understanding of relational database concepts

Intended Audience

Anyone who is assigned to a data warehousing project, including:

• Warehouse Project Manager
• Source System DBAs
• Warehouse Architects / Designers
• Warehouse Developers

For Inquiries or Reservations

Call: (63-2) 637-2400, Training Group
E-mail: training@intranetsys.com, or
Fax: (63-2) 637-2399

Please indicate your preferred training dates, the name and contact info of your training coordinator, as well as the full names of all training attendees. 

Volume discounts are available upon request.

Payment must be received before the first day of class to ensure seat reservation. Cancellations must be received three working days before the training date.  Final training schedule is subject to change depending on availability of slots. 

Note: In house training can be arranged for a minimum of 10 participants.

Course Outline

DAY 1

Planning and Managing Data Warehouse Initiatives

• Data Warehousing Goals
• Frequently Asked Questions (and their answers)
• Data Warehousing Project Phases
• Project Management Approach
• Critical Success Factors
• Requirements Analysis
• Source System Audit

Dimensional Warehouse Modeling 101

• Introduction to Dimensional Modeling
• Facts and Dimensions
• Granularity
• Decision Points for DB Design

DAY 2

Dimensional Modeling Exercises

• Exercise Development
• Exercise Presentation

Advanced Dimensional Modeling

Warehouse Optimization

DAY 3

Source to Target Field Mapping

Data Warehouse Extraction, Transformation and Load

• Extraction Process Overview
• Extraction Tools and Mechanisms
• Extraction Techniques

Warehouse Metadata

• Introduction to Metadata 
• Purpose of Metadata in Warehousing
• Types of Warehouse Metadata
• Metadata Repositories
• Metadata Standards

ETL and Metadata Exercises

DAY 4

Warehouse Front-end Considerations

• Types of Warehouse Front-ends
• Types of End-User Requirements
• Front-end Metadata

Report Design Considerations

Walkthrough: Sample Front-End

DAY 5

Launching and Managing Data Quality Initiatives

• Data Quality Assessment
• Data Quality Objectives and Requirements
• Data Quality Stewardship (Roles and Responsibilities)

Managing Warehouse Data Quality

• Using Referential Data in Data Warehousing
• Data Enrichment and Enhancement
• Data Cleansing and Deduplication

Managing a Production Warehouse

• Supporting users
• Regular warehouse loads
• Refining a deployed warehouse
• Monitoring warehouse operations
• Manage warehouse operations
• Extend warehouse scope