Why having a Data Warehouse

Besides the obvious reasons of a shop explained above, a data warehouse gives you big advantages:

• In theory: Integration and transformation of raw data of an organisation from multiple sources (mostly very structured like SAP, CRM, Excel, etc.) into meaningful and useful information, historical stored.
• In practice: Similar a cockpit in an aeroplane - All Measures and KPIs are at one place in order to steer the plane and take the right decisions
• It allows businesses to make better decisions by accessing the data well structured
  • It helps to make informed decisions based on facts
  • It improves the efficiency of business operations
  • It enhances the quality of customer service
• The visual products from business intelligence based on top of a data warehouses are largely:
  • Ad hoc Reporting
  • Standard Reporting
  • Dashboards / Cockpits

Origin: Data Engineering, the future of Data Warehousing?
References: What is a Data Warehouse