Data Warehouse in Organisation

Data Warehousing in An Organization |

DS2 |

This study is about Data warehouse and Business Intelligence, concerning in the system’s design approach and OLAP tools (Online Analytical Processing) in a specific organization. |

[Pick the date] |

Table of ContentsTable of Contents3

Introduction4

Analyze an existing organization 4

Approach, design and develop Data Warehouse6

Data Warehouse Model/Architecture9

OLAP Tools 9

Impact of Data Warehousing on Ingenix13

Summary14

The future of data warehousing14

References17

IntroductionThe study in this report is talking about the Data Warehouse which has been created to support decision-making by obtaining data from different operational data sources.

To provide comprehensive analysis of the organization, any trends in their business and requirements means corporate decision-makers need to be able to access to all the organization’s data, wherever it is located.

In the past, the operational database holds current, dynamic and stores detailed data which most of the time only supports day-to-day decisions and there are explicit limited access because it’s containing some confidential information. But in order to optimize an organization’s long-term strategies and planning, therefore the idea of data warehousing has been raised. The challenge for an organization is to turn its archives of data into a source of knowledge and then it can be represented to the users whenever they require.

Regarding the active promoted of Bill Inmon, the characteristics of data warehouse are as the following;

Subject-oriented as the warehouse is organized into relevant major subjects such as sales revenue and products rather than object-oriented as in the database like customer invoice and product sales.

Integrated because when the data is gathered from different sources and systems so that make them often inconsistent using. Hence the integrated source data must be made consistent before being...