Modeling & Designing the Data Warehouse

Course Outline

Introduction

• The Need for proper understanding of Data Warehousing
• The Key Issues
• The Definition of a Data Warehouse
• The Lifecycle of a Data Warehouse
• The Goals of a Data Warehouse
• Why Data Warehousing is different from OLTP

Managing The Data Warehouse

• Fundamental considerations
• Staffing
• Project Planning
• Project Monitoring

E/R Modeling Vs Dimension Tables

• Data Hub Design

Designing a Product-Oriented Data Warehouse

• Terms & Definitions
• A Grocery Store Example

Assignment 1

Assignment 1 completed

On Line Analytic Processing

Mechanics of the Design

• Interviewing End-Users and DBAs
• Assembling the team
• Choosing Hardware/Software platforms
• Server-Side activities
• Client-Side activities

Handling Aggregates

Designing a Customer-Oriented Data Warehouse

Assignment 2

Advanced Data Hub Design

• The Value Chain
• The Product Dimension
• Snowflaking
• The Customer Dimension
• Slowly Changing Dimensions
• Demographic Minidimensions
• Junk Minidimensions
• Factless Facts

Assignment 3

Review of materials covered through write ups

At Large Topics

• Data Quality
• Data Transformation
• Metadata Development and Administration
• Data Mining

At Large Topics continued

• Query and Reporting Tools
• The Distributed Data Warehouse
• Executive Information Systems and the Data Warehouse
• External Unstructured Data and the Data Warehouse
• Data Warehousing and Standardized Benchmarks
• The Data Warehouse and Technology
• Migration to the Architectured Environment

Conclusions

Back to Course Description  Onsite Training   Class Schedule  Registration