An SQL Server Data Warehouse is a kind of central repository used for storing heterogeneous data related to the purposes of analysis and reporting. It consolidates, standardizes and organizes the data for better decision making.