Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley

locations map


550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2


821A Bloor Street West
Toronto, ON
M6G 1M1


409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA

Other Locations

Dallas, TX
Miami, FL

Home > Training > Data Warehousing > Introduction to Data Warehousing Training

Introduction to Data Warehousing Training

Course#: WA1816

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.



What you will learn
After completing this course, the student should be able to:
  • Understand and apply the concepts, processes and principles of data warehousing
  • Identify the components of a data warehouse architecture
  • Be familiar with data warehouse terminology
  • Identify success and risk factors of data warehousing
  • Place deliverables within the context of a comprehensive data warehousing process
  • Take practical steps to begin a success data warehousing initiative
  • 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

2 days

Outline of WA1816 Introduction to Data Warehousing Training

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
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:


*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.


Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.