I nternational Journal of Application or I nnovation in Engineering & Management (I JAI EM) Web Site: www.ijaiem.org Email: editor@ijaiem.org Volume 3, Issue 10, October 2014 ISSN 2319 - 4847 Volume 3, Issue 10, October 2014 Page 23 ABSTRACT As we all know that developing a data warehouse is a costly affair in terms of resources and investment. This cost can be recurring as well as non recurring depending on the requirements of the organization as a whole. The warehouse is supposed to give benefits to the business as a fixed cost is associated with it. This paper discusses the need of a warehouse and its potential benefits by studying the data warehouse process since each data warehouse process changes as the organizational need changes. We have identified success factors of warehouse and calculated it to define ROI. Keywords:- Data warehouse, recurring, ROI, success factors. 1. INTRODUCTION Data warehouse is a large repository of data collected from various sources. It has memory in terms of TB. Procuring it costs a huge amount of money. But its implementations are never monitored for its performance and success. It is only monitored for technical parameters like speed, memory size, as opposed to the business facets. Business people generally treat success of data warehouse as success of any operational system. Inexperienced IT specialists don’t care about measuring the success of data warehouse. We must understand that data warehouse process is mainly business. Our Work: We have studied various types of success factors that will determine the success of a warehouse. The success of a data warehouse depends upon the following: 1. Vision: It is not possible to get success of a data warehouse without knowing its vision. Unless you know what to achieve, how to find the success? 2. Dynamic nature: The success of a data warehouse is very dynamic since business goals are changing very fast. 3. Internal influence: It is the entity that determines how well the data warehouse is performing with its current expectations. That is, it determines how easily users can get the data stored in the warehouse. The success of warehouse can be measured in terms of internal influences. The internal success factor is given by the formula: 4. External Influence: It is the entity that is based on what is not included in the data warehouse. It is a measure of the ratio between what DW is doing vs what it should be doing. Such a measurement is possible only when the vision is completely clear. The external success factor is defined as follows: 5. Overall success factors: The overall aim of the DW should be to have the users performing analysis 100% for every single defined enterprise need to be addressed. Calculation of Various Success Factors: We have calculated the different success factors by assuming a hypothetical situation. Let a company has the following needs: 1. Monitoring the sale of software by zone to give a view of its use. (5) 2. Improving the inventory process on sales. (5) 3. Analyzing return merchandize to determine any key patterns with an aim to reduce the amount returned. (4) 4. Analyzing the maintenance needed and the total AMC registered. (4) 5. Analyzing the online and offline sale. (3) The figures in parenthesis indicates the importance of each enterprise needs with (5) being most important. A Study of Success Factors of Data Warehouse to estimate ROI Bikramjit Pal 1 , Mallika De 2 1 Asst. Prof. and Head, Department of Computer Application, JIS College of Engineering, Kalyani, W. B. India 2 Ex Professor, Department of Engineering and Technological Sciences, University of Kalyani, Kalyani