What is Data Warehouse?
Data warehouses store current and historical data - from marketing, sales and other departments - in one central repository so that it can be analyzed for market research, analytical reports and decision support.
Storing data in a data warehouse is the end point for your data’s journey through ETL. While traditional databases are updated in real-time to maintain accurate, up-to-the-minute data, data warehouses are updated less frequently and designed to give a long-range view of data. The analytics that are run in a data warehouse, then, are usually more of a comprehensive view of your company’s history rather than a snapshot of the current state of your business.
Further, since the data in a data warehouse is already integrated and transformed, it allows you to easily compare older, historical data and track marketing and sales trends. These historical comparisons can be used to predict how to best proceed with your business ventures in order to increase profit and long-term ROI.