Introduction to Data Warehousing

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.
There are no prerequisites for this course.
1-2 Days/Lecture & Lab
This course is ideal for:Anyone new to data warehousingThose who want to review the fundamentals of data warehousing from a best practices standpointBusiness and systems managers who are evaluating data warehousing
  • Basic Concepts and Definitions
  • Project Management Deliverables
  • The Dimensional Model
  • Architectural Deliverables
  • Data Warehouse Technology
  • Implementation Deliverables
  • Maintaining the DW

Related Scheduled Courses