The purpose of a data warehouse is to consolidate and store large volumes of data from multiple sources, facilitating data analysis and reporting. It supports business intelligence by enabling organizations to derive insights and make informed decisions based on historical data. Data warehouses are optimized for query performance, allowing for complex querying and analysis without disrupting the operational database, promoting effective strategic planning.