INTRODUCTION TO DATA WAREHOUSING– GTDW1
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.
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.
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.
Please contact us for further details.
1. INTRODUCTION TO DATA WAREHOUSING
Basic Concepts and Definitions
Definition of the data warehouse (DW)
Overall architecture of a DW
Categories of DW technology
DW project and initiative types
Project Management Deliverables
DW project scope
DW project plan
Managing a DW project
The iterative release model
Introduction to the Dimensional Model
2. IMPLEMENTATION, OPERATION AND EXPANSION
Outcomes from analysis
Outcomes from design
Outcomes from construction
Outcomes from deployment
Service level agreements
Outcomes of usage
Maintaining the DW
Incremental DW releases
Follow-up to DW
Post mortem and lessons learned
Managing the vendor
Getting started with data warehousing