Data warehouses are designed to help analyze the data. Data Warehouse normally contains historical data derived from transactional data. It can also include data from other sources. It puts data from disparate sources into a consistent format.

It helps end-user access to a wide variety of enterprise data. It empowers end-users to perform any level of ad-hoc queries or reports without impacting the performance of the operational systems. It potentially lowers computing costs and increases productivity.