Main | Non-Additive Measures in OLAP »
March 31, 2008
Data Warehouse is not only for strategic or analytics
Data Warehouse as a term has been often used as an integral component of high-end decision support and back-room analytics. The fact is that Data warehouses can be a universal source for any information requirement.
Data Warehouse is a repository of data, whereby the application of that data is ‘limited only’ by the detail and the way data is stored. Query and analysis, business modeling , data mining are the buzzword use of data warehouses. However, there are more fundamental and bigger usage possible for Data Warehouse. For example enterprise reporting , which can provide you capability to report on Summary level as well as transaction level data, one can drive operational management benefits. You not only can use data warehouse to find the sales trends, but also to generate the list of all 5000 sales officers, along with the list of every sales order which they have booked in last six months.
It all depends on the granularity of the data which is stored in the data warehouse.
Essentially, Data Warehouse is a repository of data, which can be used for unlimited number of applications, as long as you have right tools sitting on top of it, and detailed enough information sitting inside it. To understand more on the possible applications of Data Warehouse, refer Why is Data Warehouse needed
Posted by Rajan Gupta at March 31, 2008 8:45 PM
