|
|
|
| Business Performance and Information Excellence Practice
|
|
|
|
|
|
|
BiPM ENCYCLOPEDIA →
Intelligent Enterprise →
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 is repository of Data picked from Transaction systems, and filtered and transformed to make it available for data analysis reporting.
|
| |
|
|
Data Warehouse is designed to meet some business needs, which is transaction system cannot do (and vice versa).
|
| |
|
|
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 initiative is more challenging as compared to a transactional system. You better read it to understand what you are in for..
|
| |
|
|
|
|
|
|
All Chapters in "Data-Warehouse/Mart." Section
|
|
|
|
| |
| |
| Back |
|
|
|
|
|
