Introduction to Data Warehouse Concepts

Course:  DWCONI
Duration:  1 Day
Level:  I
Course Summary

Students will be exposed to the expanding role of Data Warehouses, the strategies behind their development, and the utilization of their information to answer fundamental business questions. This one-day course presents all topics in a nontechnical format as the instructor combines these basics; defining a warehouse, links to legacy systems, warehouse design and implementation, migration strategies, automation techniques, tool integration and metadata, and end user reporting and utilization.

All aspects of this class will incorporate the specific architecture and tools of the client to illustrate the implementation of these techniques.

« Hide The Details
Topics Covered In This Course

Overview

Project Life Cycles

Metadata

End User Considerations

Design Considerations

Cubes

What You Can Expect

At the end of this course, delegates will be able to:

  • Define the basic building blocks for a Data Warehouse.
  • Illustrate the differences between Enterprise and Data Mart warehouses and advantages of both models.
  • Discuss the three-tiered architecture for optimal warehouse creation including data staging, data presentation are and data access tools.
  • Explain the migration from legacy systems operational data to warehouse information in ETL (Extract, Transform, Load).
  • Understand the process of data transformation and its importance in warehouse development.
  • Define the role of metadata and its central role in data warehousing.
  • Define the role of the end user community and their usage of warehouse information. (Both their utilization of the data and how they participate in the development process.)
  • Understand the differences between relational and multidimensional warehouse structures and the advantages and disadvantages of each.
  • Discuss the role of the star schema in warehouse design and development.
  • Illustrate the principle obstacles to implementation for warehouse projects.
  • Discuss business intelligence data delivery tool categories (reports, ad hoc reporting, OLAP solutions, dashboards, scorecards, etc.)
Who Should Take This Course

This course is designed for business analysts, application managers, project leaders, application developers, end users and other individuals who will be involved in the development, maintenance or utilization of a Data Warehouse.

Recommended Prerequisites

An understanding of business applications and a high level exposure to database technology.

Training Style

Instructor led with 100% lecture.

« Hide The Details
Related Courses
Code Course Title Duration Level
DWHTCA
Data Warehousing Terms, Concepts and Architecture
1 Day
I
Details
DMC
Data Analysis & Modeling Workshop
2 Days
I
Details
DWHFUN
Data Warehousing Fundamentals
3 Days
I
Details
DWTEST
Fundamentals of Data Warehouse Testing
3 Days
II
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com