7952  Reviews star_rate star_rate star_rate star_rate star_half

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...

Read More
$1,650 USD
Course Code WA1816
Duration 2 days
Available Formats Classroom

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.

Skills Gained

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

Who Can Benefit

  • 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

Prerequisites

There are no prerequisites.

Course Details

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

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