Data Warehouse Basic Definition

Data Warehouse is a just like a database which stores large amount of data usually the data stored in the data warehouse are old data not current data. Organizations use these data stored over years in the data warehouse to analyze the trend and to forecast the future. This analysis is very helpful to find some unknown patterns in the Business which might turn the profits higher.

Data warehouse mainly has 3 functional layers: Staging Layer, Integration Layer and Access Layer

In Staging Layer, the raw data is stored.

In Integration Layer, some data are integrated together as per the requirement and are stored in this layer.

In Access Layer, data are ready to be accessed in the format which will be helpful for generating the reports.