What are the advantages of building and using a data warehouse?

by Daniel J. Power

Major advantages include:

1. Developing a data warehouse (DW) forces an organization to better understand the data that it is currently collecting and opportunities to collect additional data.

2. A data warehouse provides a centralized view of data collected in an enterprise.

3. A data warehouse provides a single version of the "truth". A DW provides consistent, reliable data about company facts, such as revenue or the number of employees.

4. With a data warehouse, snapshots of data can be taken over time. A DW can create a historical record of data, which allows for an historical and trend analysis.

5. A data warehouse with business intelligence software provides tools to combine, display and aggregate data. Tools like dashboards provide information and summarize analyses.

Last update: 2016-10-15 09:12
Author: Daniel Power

Print this record Print this record
Show this as PDF file Show this as PDF file

Please rate this entry:

Average rating: 0 from 5 (0 Votes )

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry

DSS Home |  About Us |  Contact Us |  Site Index |  Subscribe | What's New
Please Tell Your Friends about DSSResources.COMCopyright © 1995-2015 by D. J. Power (see his home page).
DSSResources.COMsm is maintained by Daniel J. Power. Please contact him at with questions. See disclaimer and privacy statement.


powered by phpMyFAQ 1.5.3