Establishing 'Making it Happen' as a 'Formal & Predictable' Discipline

	DW Project Scoping and Planning

Execution-MiH ENCYCLOPEDIA → Enterprise Intelligence → SECTION - Data-Warehouse/Mart →

CHAPTER -

Data Warehouse Overview

This chapter is setting the scene. It provides the end to end high level landscape of Data Warehouse. Much of this chapter talks on how Data Warehouse is different from Transaction systems, and what are we in for. Lets Look at What & why of Data Warehouse, its components & framework and what are the challenges for a typical DW project.

Topics

Data Warehouse definition- What is Data Warehouse?

Data Warehouse is repository of Data picked from Transaction systems, and filtered and transformed to make it available for data analysis reporting.

Data Warehouse Purpose and Objective- Why is Data Warehouse Needed?

Data Warehouse is designed to meet some business needs, which is transaction system cannot do (and vice versa).

Data Warehouse Components and Framework

Data Warehouse framework starts from extracting data from source systems, transforming and cleansing it, before loading into the repository. It ends with the data being accesses, analyzed, mined and dashboarded using end user tools.

Data Warehouse Challenges and Issues

Data Warehouse initiative is more challenging as compared to a transactional system. You better read it to understand what you are in for..