What is a Data Warehouse, and why should you use one?
A data warehouse is where you store data from multiple data sources to be used for historical and
trend analysis reporting. It acts as a central repository for many subject areas and contains the
“single version of truth”. It is NOT to be used for OLTP applications.
What a Data Warehouse isn't:
It is not a copy of multiple tables (i.e. customer) from various sources systems unioned together in a view.
It is not a dumping ground for tables from various sources with not much design put into it.
Data Maturity Model
Reasons to leverage the power of a Data Warehouse:
Data Warehouse Solutions Options
Appliances – Microsoft has made available SQL Server appliances (SMP and MPP) that allow customers to deploy data warehouse (DW), business intelligence (BI) and database consolidation solutions in a very short time, with all the components pre-configured and pre-optimized. These appliances include all the hardware, software and services for a complete, ready-to-run, out-of-the-box, high performance, energy-efficient solutions