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
  • Without a data warehouse, we would have to integrate all of the data from different source systems ourselves