There are many advantages to using a data warehouse, some of them are:
- Enhances end-user access to a wide variety of data
- Business decision makers can obtain various kinds of trend reports e.g. the item with the most sales in a particular area / country for the last two years
- Increased data consistency
- Additional documentation of the data
- Potentially lower computing costs and increased productivity
- Providing a place to combine related data from separate sources
- Creation of a computing infrastructure that can support changes in computer systems and business structures
- Empowering end-users to perform any level of ad-hoc queries or reports without impacting the performance of the operational systems
A data warehouse can be a significant enabler of commercial business applications, most notably customer relationship management (CRM).
|
