Object and Data Labs
  Certificates   Free Newsletter   What's New   Contact
Main Areas
Onsite Training
Class Schedule
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 Print Page
Course Description

Modeling & Designing the Data Warehouse

Course Objective

In-House Training for as few as 3 Attendees >>

Or Call Toll Free

One of the most dramatic new developments in database design is the data warehouse, a powerful database model that significantly enhances managers' abilities to quickly analyze large multidimensional data sets.

In this course students can learn practical information needed to design, manage, build and use dimensional data warehouses for virtually any type of business application. Employing many real-life case studies of data warehouses, the course provides clear guidelines on how to model data and design data warehouses to support advanced multidimensional decision support systems. Product-Oriented and Customer-Oriented data warehouse examples are explored. Beginning with a simple grocery store data warehouse example the course progresses to complex business applications in retail, manufacturing, banking, insurance, subscriptions, and airline reservations.

What will you learn

  • How to design and build a data warehouse
  • Migration to a data warehouse
  • Life cycle of a data warehouse
  • How the ETL Process works
  • When transactional and when snapshot grains make sense
  • How to build a value chain for the business
  • How to get the most from star joins and standard data models
  • How data marts and OLAP fit with data warehousing schemes
  • What is Metadata
  • What is Data Mining
  • Data Warehousing Benchmarks

How you will apply what you have learned

  • Have a better grasp on Data Warehousing technology
  • Understand how to model star-join schemas for various application domains in Retail, Finance, Insurance and Shipments
  • Understand the technology behind the buzz words associated with Data Warehousing such as metadata, data mining, etc.

Who should attend

This course is for developers, managers, designers, data and database administrators and anyone interested in the field of building decision support applications.

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