Components of Data warehouse

The following 4 distinct components to be considered as DWH Component

• Operational Source system
• Data staging
• Data presentation
• Data access tools

Diagram Source: The Data warehouse Toolkit - 2nd Edition By Ralph Kimball

Purposes of a Data Warehouse

• Explore our past information for current decision making
• Slice & dice our data, in the way we required
• It supports people for more fact based decision making
• Make the data easy for business people to gather information directly
• It supports forecasting
• It makes the information easily accessible
• It is only business user not developer
• Data in DWH must be credible, accurate & reliable
• Adaptive and flexible to change
• It must provide security to our confidential information.
• It must support for improved decision making