Data Warehouse
A data warehouse is a technology that is dedicated to the storage of company data from a wide range of sources for reporting and decision-making purposes.
- unify and hold the data from multiple source systems
- Different data from different systems can be queried together without impacting the performance of the separate source systems
- advent of data warehousing model:
- gives us a reporting model that overcomes the gap in reporting
- while still allowing each source system to do what it is defined to do
- provide a single source of truth
- can leverage online analytical processing (OLAP) technology
- making data processing more effective
- e.g. OLAP can summarize thousands of records far faster than traditional tools like Excel
- can be done by OLAP technology through the use of OLAP cubes
- cubes provide data that is already grouped by different dimensions
- when analysts access data, they can further analyze it without having to group and total it first
- cubes provide data that is already grouped by different dimensions
- Without a data warehouse, we would have to integrate all of the data from different source systems ourselves