Data Warehouse Fundamentals      
Factors for Successful Development

Code:

 IS130-060

Series:

 Information Management

Duration:

 1 day

Introduction to Data Warehouse
Access to information
Data Warehouses and operational systems
Data Marts, Operational Data Stores and the Data Warehouse.
The application portfolio
More terms: OLAP, ROLAP, MOLAP … …

Why are Data Warehouses useful?
Business plans and measurement
Business benefits
Technical benefits

What does a Data Warehouse consist of?
Data Warehouse Architecture
Decision making activities
Information provision
Functional Requirements
Non-Functional Requirements
Data requirements
Technology platforms and software

Who uses a Data Warehouse?
The information worker
Executive information
Operational users

How are Data Warehouses built and kept?
The Data Warehouse lifecycle.
Planning the project
Gathering requirements
Designing the data foundation
Dimensional Modelling
Meta Data
Data staging
Building end user applications
Constructing the technical capability
Deployment
Operational activities

Who is involved in construction?
The project team
The sponsor and business driver
Business analysts
Data analysts and the DBA
Application developers
Technology support

Data Warehouse Issues

Data Warehouse Fundamentals


After completing this course, students will be able to:

  • Demonstrate a clear understanding of the business and technical benefits of a data warehouse and be aware of surrounding issues.
  • Compare the characteristics of decision support systems with business process applications.
  • Describe the major components of a data warehouse and their functions.
  • Comprehend the complexity of data integration involved in developing a data warehouse.
  • Understand the major phases of a data warehouse project.

Prerequisites:


Familiarity with business information systems.