Data Warehouse Architecture

Summary

The foundation for an effective enterprise Performance Analytics program is establishing a single source of accurate enterprise information – an enterprise data warehouse (EDW). Analyzing product penetration, customer value or any other business process or outcome from a single application data source is an incomplete and inaccurate process that wastes valuable resource time and expense. Integrated enterprise information is required.

The Data Warehouse Architecture course provides an overview of the components and considerations for planning, designing, developing and implementing an EDW. Models will be provided that can be customized to reflect each participant’s organization EDW needs and wants.

Intended Audience

CIOs, DW Manager, DW Team, Business Analysts and Subject Matter Experts

Course Outline

Introduction

Business Requirements

Enterprise Data Warehouse (EDW) Model

  • Source Systems
  • Data Integration
  • EDW Architecture
  • Data Modeling

Implementation Model

Summary

Results

Participants will complete the program with an understanding of EDW components’ functions, and how they work together.

Duration

2, 4 hour sessions

Prerequisites

None