Staging Layer − The staging layer is used to store the data extracted from different source data systems.
Data Integration Layer − The integration layer transforms the data from the staging layer and moves the data to a database, where the data is arranged into hierarchical groups, often called dimensions, and into facts and aggregate facts. The combination of facts and dimensions tables in a DW system is called a schema.
Access Layer − The access layer is used by end-users to retrieve the data for analytical reporting.
Data warehouse
A Data Warehousing (DW) is process for collecting and managing data from varied sources to provide meaningful business insights. So that analysts can use the data to drive some value. Data mining — extracting value from data and interpret for future predictions.
