The Effect of Implementation Factors on Data Warehousing Success: An Exploratory Study

Data warehousing is an important area of practice and research, yet few studies have assessed its practices in general and critical success factors in particular. Although plenty of guidelines for implementation exist, few have been subjected to empirical testing. In order to better understand implementation factors and their effect on data warehousing success, perceptions of data warehousing professionals are examined in a cross sectional survey. Best subsets regression is used to identify the specific factors that are important to each success variable. Since different companies may have different objectives or emphases in their data warehousing endeavors, the results are useful in identifying the exact factors that need attention and in providing a basis for prioritizing those factors. The results also suggest several promising directions for continued research on data warehousing success.

[1]  Sean Kelly.  Data Warehousing in Action , 1997 .

[2]  Lei-da Chen,et al.  Measuring user satisfaction with data warehouses: an exploratory study , 2000, Inf. Manag..

[3]  Lauren Keller Johnson.  Strategies for Data Warehousing , 2004 .

[4]  Ephraim R. McLean,et al.  The DeLone and McLean Model of Information Systems Success: A Ten-Year Update , 2003, J. Manag. Inf. Syst..

[5]  Barbara Wixom,et al.  Current Practices in Data Warehousing , 2001, Inf. Syst. Manag..

[6]  Bongsik Shin,et al.  An Exploratory Investigation of System Success Factors in Data Warehousing , 2003, J. Assoc. Inf. Syst..

[7]  Robert Winter,et al.  Organization of Data Warehousing in Large Service Companies - A Matrix Approach Based on Data Ownership and Competence Centers , 2001 .

[8]  Narasimhaiah Gorla,et al.  Features to consider in a data warehousing system , 2003, CACM.

[9]  Ephraim R. McLean,et al.  Information Systems Success: The Quest for the Independent Variables , 1992, J. Manag. Inf. Syst..

[10]  C. D. Beaumont,et al.  Regression Diagnostics — Identifying Influential Data and Sources of Collinearity , 1981 .

[11]  N. Draper,et al.  Applied Regression Analysis , 1966 .

[12]  Barbara J. Haley,et al.  Managerial considerations , 1998, CACM.

[13]  Barbara Wixom,et al.  An Empirical Investigation of the Factors Affecting Data Warehousing Success , 2001, MIS Q..

[14]  Christer Carlsson,et al.  Past, present, and future of decision support technology , 2002, Decis. Support Syst..

[15]  Neil F. Doherty,et al.  An analysis of the anticipated cultural impacts of the implementation of data warehouses , 2003, IEEE Trans. Engineering Management.

[16]  Sunny Baker,et al.  THE BEST LITTLE WAREHOUSE IN BUSINESS , 1999 .

[17]  David Sammon,et al.  The ten commandments of data warehousing , 2000, DATB.

[18]  James J. Cappel,et al.  Data Warehouse Development and Management: Practices of Some Large Companies , 2002, J. Comput. Inf. Syst..

[19]  W. Hays.  Applied Regression Analysis. 2nd ed. , 1981 .

[20]  SammonDavid,et al.  The ten commandments of data warehousing , 2000 .

[21]  A. Desai,et al.  For pharmaceutical companies, a data warehouse can be just what the doctor ordered. , 1999, Health management technology.

[22]  Michael D. Myers,et al.  Executive information system failure: a New Zealand case study , 1997, PACIS.

[23]  Debasish Mukherjee,et al.  Think Phased Implementation for Successful Data Warehousing , 2003, Inf. Syst. Manag..

[24]  Ann Blair,et al.  Too much information , 2007, Nature.

[25]  Stephen R. Gardner.  Building the data warehouse , 1998, CACM.

[26]  W. W. Muir,et al.  Regression Diagnostics: Identifying Influential Data and Sources of Collinearity , 1980 .

[27]  Mark I. Hwang,et al.  The effect of user engagement on system success: A meta-analytical integration of research findings , 1999, Inf. Manag..

[28]  R. R. Hocking.  The analysis and selection of variables in linear regression , 1976 .

[29]  Michael Sigal.  A common sense development strategy , 1998, CACM.

[30]  Z. Rubin,et al.  Slices of Lives. , 1978 .

[31]  Joe Nandhakumar,et al.  Design for success?: critical success factors in executive information systems development , 1996 .

[32]  Barbara Wixom,et al.  Data Warehousing Supports Corporate Strategy At First American Corporation , 2000, MIS Q..

[33]  Hugh J. Watson,et al.  Critical Success Factors for Information Center Managers , 1988, MIS Q..

[34]  Thilini Ariyachandra,et al.  Data warehouse governance: best practices at Blue Cross and Blue Shield of North Carolina , 2004, Decis. Support Syst..