Information Impact International Information Quality
Site Search:



High IQ Team Login
Member ID:

Password:


Not Registered?
View Member Benefits

Forgot Password?

 
COURSE Title: MANAGING THE DATA WAREHOUSE
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 quality and consistency of the data within source databases and the data warehouse.  You learn guidelines for how to avoid pitfalls to data warehouse to assure a quality strategic knowledge tool.

 

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 warehousewhy are we doing this?
  • Developing the data warehouse data architecturewhat do we need in it?

  • Data sourceswhere do we get the right data?

  • Data acquisitionhow do we get data with the right quality?

  • Information stewardshipwho's in charge here?

  • Making information politics work"not with my data, you don't!"

  • Exploiting warehouse data for competitive advantageshouldn't what goes in, come out?

  • Metrics for data warehouse successhow 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
Abstract:

ABSTRACT:  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 quality and consistency of the data within source databases and the data warehouse. You learn guidelines for how to avoid pitfalls to data warehouse to assure a quality strategic knowledge tool.

Addressed are the critical success factors of planning, organizing, directing and controlling the data warehouse for maximum value.

back to top
Data Warehouse: Introduction and Strategy
  • Data warehouse defined
  • Data warehouse components
  • Objectives data warehouse must achieve
  • How the data warehouse fits into an information management strategy
  • Relationship of data warehouse and information resource management
  • The real reason data warehouse has come about?mistakes of the past to avoid
Data Warehouse Architecture Design
  • One-tier, two-tier and three-tier data warehouse architectures
  • Relationship of the data warehouse data model and enterprise and operational data models
  • Defining subject areas for the data warehouse
  • Anticipation analysis for the data warehouse
  • Determining what data belongs in the data warehouse
  • Developing the enterprise data warehouse data model
  • Developing the operational data store (ODS) data model
  • Developing multidimensional data mart data models
Managing Information Quality in the Data Warehouse
  • Record of origin, record of reference and target data
  • Identifying and analyzing data sources
  • Assessing source data quality
  • Mapping source data to the target model
  • Developing transformations and enhancement
  • Measuring and managing the source data
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
Implementing the Data Warehouse
  • Loading the data warehouse
  • Determining the refresh schedule
  • Managing consistency of warehouse data
Exploiting the Data Warehouse
  • Identifying decision support and executive information support processes
  • Developing education for the knowledge worker?the data warehouse customer
  • Thinking outside the box: the role of the data warehouse
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
Beyond the Warehouse
  • Leveraging the data warehouse to requirements for operational databases
  • From data to knowledge management

back to top

 

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

Code of Ethics - Privacy Statement - Copyright Information - go to top of page


What's New- About Info Impact- Services & Products- Conferences & Seminars- News & Information- Tools & Resources 

 

site by ICG Link, Inc.