Object and Data Labs
  Certificates   Free Newsletter   What's New   Contact
              Sitemap
Main Areas
Onsite Training
Courses
Class Schedule
Registration
Tuition Discounts
Technology Library
Our Instructors
Our Customers
Why Object & Data Labs?

Hot New Courses:
XML: A Comprehensive Introduction
Disaster Recovery Planning

How students rate us

Free Newsletter
Visit our technology library and sign up to receive the latest word in technology from industry specialist.

Certification Available
Visit our certification page to see how you can be on the fast track to certification in advanced technologies.
  Home > Courses > Course Descriptions > Course Details Print Page
Course Description

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

 

  Home | Courses | Class Schedule | Registration | About Us | Contact Call us TOLL FREE at 1-888-230-9052
Copyright 2003-2013, Object & Data Labs All Object & Data Labs Courses are certified courses with UC Berkeley & UCSC extension 

Website by Howard Pugh Web Design
Website maintained by Ann T. Comey