INTRODUCTION TO DATA WAREHOUSING– GTDW1

Course Description

This 2-day course examines and establishes the fundamental theories, concepts, domains, techniques and terminology that are essential for every business and information technology professional who is involved in data warehousing. Students are introduced to best practice approaches and structures for data warehouse development and implementation. Common definitions and characteristics of data warehouses, data warehouse architectures, readiness issues, incremental data warehouse project planning, data warehouse strategy and mistakes to avoid all receive special emphasis.

This course concentrates on data warehouse deliverables independent of any specific methods, but within the framework of best practices. It focuses on understanding deliverables that may be produced throughout the data warehouse process and issues reasons for producing them. This course closes with exploration for practical next steps the students can take. This includes steps further to develop knowledge and skills, to position oneself for success, and to get started with data warehousing.

^^

Duration

2 days

^^

Target Audience

This course is suitable for anyone new to data warehousing, those who want to review the fundamentals of data warehousing from a best practices standpoint, business and systems managers who are evaluating data warehousing.

^^

Course Prerequisites

There are no prerequisites.

If you have any questions or doubts as to whether you meet the pre-requisites for this course, or indeed are wondering which course best suits you, please consult with us to discuss your suitability for course attendance.

^^

Suggested Follow on Courses

Please contact us for further details.

^^

Course Content

1. INTRODUCTION TO DATA WAREHOUSING

Basic Concepts and Definitions

Definition of the data warehouse (DW)

Overall architecture of a DW

DW processes

Categories of DW technology

DW project and initiative types

Project Management Deliverables

DW strategy

DW project scope

DW project plan

Managing a DW project

The iterative release model

Introduction to the Dimensional Model

Facts

Dimensions

Star schemas

Snowflakes

Architectural deliverables

Requirements

Analysis

Design

Infrastructure

Implementation

2. IMPLEMENTATION, OPERATION AND EXPANSION

Implementation Deliverables

Outcomes from analysis

Outcomes from design

Outcomes from construction

Outcomes from deployment

Operational Deliverables

Service level agreements

Outcomes of usage

DW monitoring

DW governance

Maintaining the DW

Incremental DW releases

Follow-up to DW

On-going assessment

Post mortem and lessons learned

Managing consultants

Managing the vendor

Getting started with data warehousing

^^

See more Other courses