dma2.gif (5195 bytes)Data Mining & Analysis, LLC

logo2.gif (5725 bytes)

Home Profile Services Staff Resources News Case Studies Feedback Contents Search

DATA WAREHOUSE EXECUTIVE OVERVIEW

BACKGROUND: Computer usage has shifted from data processing professionals to end users who want to be able to meet their own information needs. IS personnel’s new role is to manage enterprise resources and equip users with more effective decision support tools. In today’s corporate environment, the volume and complexity of information is overwhelming. Companies able to organize and analyze this barrage of data most effectively will find themselves at a tremendous competitive advantage.

DESCRIPTION: This seminar is a combination lecture and workshop, wherein the attendee will learn what a data warehouse is, why companies build them, the critical success factors, the architecture and infrastructure components, the key roles involved, as well as, the return on investment aspects.

Upon completing this seminar the student will understand:

  • What a Data Warehouse Is and What It Does
  • Why Data Warehouses Are Built
  • Return on Investment Issues
  • ROI tools and techniques
  • What Components Make Up the Data Warehouse Architecture including metadata
  • The Key Roles Involved
  • Brief Discussion on Methodology and Rapid Cognos Prototype Service Offer

WHO SHOULD ATTEND: Data warehouse project managers, system developers, system and data architects, database administrators, and those interested in how data can be turned into information and how to compete in the marketplace with information.

INSTRUCTOR: Don Meyer is president of Don Meyer & Associates. He advises clients on all aspects of database administration, Unix/network administration, client/server and data warehouse implementations, including conducting training courses and, conducting database performance audits. Don is Oracle 7 DBA Certified and has published articles on client/server downsizing migrations.

SEMINAR OUTLINE

Introduction to the Data Warehouse

  • Trend in IS toward empowering analytical end user
  • OLTP -vs- OLAP
  • Data warehouse definition

Review Important Terms & Technologies

  • Data Mart
  • Enterprise Data Warehouse
  • Operational Data Store
  • Multidimensional analysis and OLAP vs OLTP
  • Data Mining
  • Metadata
  • EIS, DSS, ROLAP, MOLAP, etc.

Discuss The Goals & Return on Investment (ROI)

  • Why Build a Data Warehouse
  • The Goals of a Data Warehouse
  • Return on Investment – It’s mostly retroactive
  • ROI Case Studies
  • ROI tools and techniques – focusing on the benefits
    •
  • Critical Success Factors

The Data Warehouse Architecture

  • Enterprise level
  • Staging Areas
  • Summary Information Schemes
  • Metadata
  • It’s role
  • Business metadata
  • Technical metadata
  • Metadata tool repositories
  • How each vendors products integrate with existing data warehouse metadata.

The Data Warehouse Infrastructure Components

  • Understand how to gather and store metadata
  • Choose the correct hardware and software
  • Parallel technologies (MPP vs SMP) & Storage Media Options
  • Choose an appropriate network configuration
  • Develop an application methodology and applications appropriate for the data warehouse

Description of Key Roles Involved

  • Project Managers, Business Analysts, Key End Users, Data Modelers, DBA, Extraction Programmers, End User Access Tool Programmers, Support personnel

Duration: 1/2 Day

Prerequisites: None

Special requirements: None

Optional: Knowledge of data base reporting environments, particularly the data warehouse.

What to Expect: This seminar is a combination lecture and workshop, wherein the attendee will learn what a data warehouse is, why companies build them, the critical success factors, the architecture and infrastructure components, as well as, how to build and deploy one using DM&A’s proven methodology.