1. Benefits of data warehouse
- Enhances data quality and consistency - Insights will be gained through improved information access. Managers and executives will be freed from making their decisions based on limited data and their own "gut feelings". Decisions that affect the strategy and operations of organizations will be based upon credible facts and will be backed up with evidence and actual organizational data.
- Saves time - Since business users can quickly access critical data from a number of sources, all in one place, they can rapidly make informed decisions on key initiatives. They won't waste precious time retrieving data from multiple sources.
- Generates a high ROI - Companies that have implemented data warehouses and complementary BI systems have generated more revenue and saved more money than companies that haven't invested in BI systems and data warehouses. According to a 2002 International Data Corporation (IDC) study "The Financial Impact of Business Analytics", analytics projects have been achieving a substantial impact on a business' financial status.
- Increased query and system performance - Data warehouses are purposely designed and constructed with a focus on speed of data retrieval and analysis. Moreover, a data warehouse is designed for storing large volumes of data and being able to rapidly query the data.
