What is Data Warehouse?
A repository used for storing current and historical data from multiple sources. It serves as a central repository where data is cleansed, transformed, and catalogued to enable efficient querying and analysis. This structure supports business intelligence activities, providing a cohesive and comprehensive view of organisational data to aid decision-making processes. Typically, the data is cleansed, consolidated, and organised before being loaded. As data is already processed, it is easier for professionals unskilled in data or analytics to do high-level analysis. Managers and other stakeholders can use BI tools to access and analyse the data on their own.