Benefits of A Data Warehouse
A data warehouse maintains a copy of information from the source transaction systems. This architectural complexity provides the opportunity to:
- Maintain data history, even if the source transaction systems do not.
- Integrate data from multiple source systems, enabling a central view across the enterprise. This benefit is always valuable, but particularly so when the organization has grown by merger.
- Improve data quality, by providing consistent codes and descriptions, flagging or even fixing bad data.
- Present the organization's information consistently.
- Provide a single common data model for all data of interest regardless of the data's source.
- Restructure the data so that it makes sense to the business users.
- Restructure the data so that it delivers excellent query performance, even for complex analytic queries, without impacting the operational systems.
- Add value to operational business applications, notably customer relationship management (CRM) systems.
Read more about this topic: Data Warehouse
Famous quotes containing the words benefits of a, benefits of, benefits and/or data:
“One of the benefits of a college education is, to show the boy its little avail.”
—Ralph Waldo Emerson (1803–1882)
“One of the benefits of a college education is, to show the boy its little avail.”
—Ralph Waldo Emerson (1803–1882)
“Through all opposition the personal benefits of the reform [dress] [bracketed word in original] have compensated; but had it been mainly sacrifice, the thought of working for the amelioration of women and the elevation of humanity would still have been the beacon-star guiding me on amid all discouragements.”
—Susan Pecker Fowler (1823–1911)
“To write it, it took three months; to conceive it three minutes; to collect the data in it—all my life.”
—F. Scott Fitzgerald (1896–1940)