| View
attendee comments |
MANAGING THE DATA WAREHOUSE:
Maximizing Data Value While Minimizing
Data Costs
|
Why this Course? |
The
data warehouse can be a competitive advantage dream or a costly nightmare.
This seminar addresses how to plan and design the data warehouse to support
competitive advantage uses–even for potential uses not thought of today.
You learn how to increase value of operational data resources coupled
with data from external resources. A key focus is how to manage the integrity
and consistency of the data within source databases and the data warehouse.
You learn guidelines for how to avoid pitfalls to data warehouse.
Addressed
are the critical success factors of planning, organizing, directing and
controlling the data warehouse for maximum value.
|
Learning Outcomes: |
Upon completion of this
seminar, you will be able to:
- Defining objectives
for the data warehouse–why are we doing this?
- Developing the
data warehouse data architecture–what do we need in it?
- Data sources–where
do we get the right data?
- Data acquisition–how
do we get data with the right quality?
- Information stewardship–who’s
in charge here?
- Making information
politics work–"not with my data, you don’t!"
- Exploiting warehouse
data for competitive advantage–shouldn’t what goes in, come out?
- Metrics for data
warehouse success–how do we know we have succeeded?
|
| Audience: |
Data
warehouse managers and staff, DRM managers and staff, and IT management
and staff involved in planning, implementing and managing a data warehouse
|
| Format: |
Lecture
with discussion |
|
Duration:
|
1-2
Days |
| Pre-requisites: |
Basic
understanding of data management principles |
|
Course
Outline:
|
|
1. Data Warehouse:
Introduction and Strategy
- Data warehouse
defined
- Data warehouse
components
- Data warehouse
characteristics
- Objectives
data warehouse must achieve
- How the
data warehouse fits into an information management strategy
- Relationship
of data warehouse and data resource management
- The real
reason data warehouse has come about–how to avoid the mistakes of
the past
2. Data Warehouse
Architecture Design
- Relationship
of the data warehouse data model and enterprise and operational data
models
- Defining
subject areas for the data warehouse
- Determining
what data belongs in the data warehouse
- Developing
the data warehouse data model
- Anticipate
analysis and data warehouse design
3. Source
to Target Management
- Record of
origin, record of reference and target data
- Identifying
data sources
- Mapping
source data to the target warehouse model
- How to design
the transformations and extensions for the data warehouse
- Measuring
and managing the source data
4. The Information
Directory
- Objectives
and purpose of the information directory
- The role
of repository in data warehouse
- Defining
technical metadata requirements
- Defining
business metadata requirements
|
5. Implementing
the Data Warehouse
- Loading
the data warehouse
- Determining
the refresh schedule
- Documenting
currency of warehouse data
6. Exploiting
the Data Warehouse
- Identifying
decision support and executive information support processes
- Developing
education for the knowledge worker
- Thinking
outside the box: the role of the data warehouse
7. Managing
the Data Warehouse for Success
- Critical
Success factors
- What management
must know
- The role
of information stewardship in the data warehouse
- Handling
information politics
- Establishing
metrics for success
- Measuring
data warehouse performance and value
8. Beyond
the Warehouse
- Leveraging
the data warehouse experience for operational data improvement
- From data
to knowledge management
|
INFORMATION
IMPACT International, Inc.
871 Nialta Lane, Suite 100, Brentwood, TN 37027
Phone: +1 615-837-1211 - Fax: +1 615-837-8804
Email:
Larry.English@infoimpact.com
TQdM®
is a registered trademark of INFORMATION IMPACT International, Inc.
© Copyright 1996, 1997, 1998, 1999, 2000, 2001 - INFORMATION IMPACT International
Inc.
All materials on this site are protected by international copyright laws.
Reproduction in any form is prohibited without permission.
ALL RIGHTS RESERVED - Code of Ethics
- Privacy Statement