A Model of Data Warehousing Process Maturity

A Model of Data Warehousing Process Maturity

1. DATA warehousing (DW) has experienced tremendous growthinthelastdecade.Ithasbecomesopopularin industrythatitwascitedasthehighestprioritypostmillen- niumprojectofmorethanhalfofITexecutives[64].Adata warehouse is a subject-oriented, integrated, time-variant, andnonvolatile collection ofdatathat supportsmanagerial decision making . The data in a data warehouse are typicallyextractedandloadedfrommultipleonlinetransac- tionprocessing(OLTP)systemsandotherdatasourcesusing anextract,transform,andload(ETL)process.

2. MOTIVATION FOR A DWP MATURITY MODEL

   • A data warehousing process is a set of activities that begins with the identification of a need and concludes with delivering a product that satisfies the need.

3. EXTANT LITERATURE ON MATURITY MODELS

4. DESIGNING A DWP MATURITY MODEL

   • Design-Science Research
   • Initial Model
   • Knowledge Acquisition
   • Evolution of the DWP-M Model
   • Design Evaluation

5. DISCUSSION

   • In this paper, we have described the development of a design artifact—the DWP-M model. A data warehousing process revolves around data. The DWP-M model reflects this emphasis by focusing on activities geared toward data extraction, data transformation, data loading, data analysis, data change management, metadata management, data quality assurance, data warehouse governance, etc.

6. CONCLUSION AND FUTURE DIRECTIONS

   • CONCLUSION AND FUTURE DIRECTIONSThemaincontributionofthisstudyisinthedevelopmentof an innovative artifact—the DWP-M model—which ad- dresses the pressing issues associated with a DWP

7. D ATA warehousing (DW) has experienced tremendous growthinthelastdecade.Ithasbecomesopopularin industrythatitwascitedasthehighestprioritypostmillen- niumprojectofmorethanhalfofITexecutives .Adata warehouse is a subject-oriented, integrated, time-variant, andnonvolatile collection ofdatathat supportsmanagerial decision making.

8. MOTIVATIONFORA DWP MATURITY MODEL

   • A data warehousing process is a set of activities that begins with the identification of a need and concludes with delivering a product that satisfies the need .

9. EXTANT LITERATUREON MATURITY MODELS

   • Maturity models have their roots in the field of quality management . The concept of maturity implies progress from some initial state to a more advanced state. The notion of evolution is implicit in the stages of growth, suggesting that the progress transitions through a number ofintermediate statesonthewaytohighermaturitylevels.

10. DESIGNINGA DWP MATURITY MODEL

    • Even though the concept of data warehousing process maturity has been mooted in the literature workinthisareahasbeenlimitedtoasimple specification of the levels and mapping of some of the activities from CMM, without much serious theory-based development.Inthissection,wedevelopaconceptualmodel of DWP maturity by grounding our work in design-science research and in the literature on quality, maturitymodels,andITservices.
    • Design-Science Research
    • Initial Model
    • Knowledge Acquisition
    • Evolution of the DWP-M Model
    • Design Evaluation

11. DISCUSSION

    • In this paper, we have described the development of a design artifact—the DWP-M model. A data warehousing process revolves around data.

12. CONCLUSIONAND FUTURE DIRECTIONS

    • Themaincontributionofthisstudyisinthedevelopmentof an innovative artifact—the DWP-M model—which ad- dresses the pressing issues associated with a DWP. The model defines several KPAs and activities, which would enable a firm to examine its DWP, identify the problems, andhelpittoattainahigherlevelofmaturitybyaddressing those problems. These KPAs and activities are also design artifacts,morespecifically theconstructsorrepresentations of interest in the DWP maturity domain. The DWP-M modelalso capturestherelationshipsamongprocessareas, depicting the interactions among the KPAs in terms of information flow and prerequisite KPAs.