Supporting Business Intelligence Usage: An Integrated Framework with Automatic Weighting

ABSTRACT This paper presents an integrated framework that comprises an automatic weighting method for assessing data quality (DQ) of the framework so as to better support the business intelligence (BI) usage. Specifically, we utilize business process modeling (BPM) notation and information product map and frame them into a hierarchical mapping structure. Furthermore, we develop and demonstrate an automatic weight-assignment method for evaluating critical dimensions (i.e., completeness and accuracy) of DQ of the integrated framework. Through a design science paradigm, the effectiveness of the framework and the associated DQ weighting method has been rigorously validated by faculty management users of a university. The framework together with the DQ weighting method builds user confidence by enhancing the traceability of a BI product. The automatic DQ weight assignment also provides better time efficiency because the weight of each data attribute is determined automatically based on its usage on the BI dashboard.

[1]  S. T. Buckland,et al.  An Introduction to the Bootstrap. , 1994 .

[2]  Mathias Weske,et al.  Business Process Management: Concepts, Languages, Architectures , 2007 .

[3]  Tobias Bucher,et al.  Process-centric business intelligence , 2009, Bus. Process. Manag. J..

[4]  Richard Y. Wang,et al.  A product perspective on total data quality management , 1998, CACM.

[5]  Thomas Redman,et al.  Data quality for the information age , 1996 .

[6]  Richard Y. Wang,et al.  Modeling Information Manufacturing Systems to Determine Information Product Quality Management Scien , 1998 .

[7]  Alan R. Hevner,et al.  Design Science in Information Systems Research , 2004, MIS Q..

[8]  Barbara Wixom,et al.  The BI-Based Organization , 2010, Int. J. Bus. Intell. Res..

[9]  Activité ad‐hoc Types de tâches.  Introduction to BPMN , 2004 .

[10]  Hafedh Mili,et al.  Business process modeling languages: Sorting through the alphabet soup , 2010, CSUR.

[11]  Ruth Sara Aguilar-Savén,et al.  Business process modelling: Review and framework , 2004 .

[12]  Diane M. Strong,et al.  Beyond Accuracy: What Data Quality Means to Data Consumers , 1996, J. Manag. Inf. Syst..

[13]  Michael Rosemann,et al.  What are the secrets of successful process modelling? Insights from an Australian case study , 2005 .

[14]  Adir Even,et al.  The metadata enigma , 2006, CACM.

[15]  William Yeoh,et al.  Benefits and Barriers to Corporate Performance Management Systems , 2014, J. Comput. Inf. Syst..

[16]  Hong Peng,et al.  Knowledge and Process Based Decision Support in Business Intelligence System , 2006, First International Multi-Symposiums on Computer and Computational Sciences (IMSCCS'06).

[17]  Craig W. Fisher,et al.  Introduction to Information Quality , 2006 .

[18]  Neil Foshay,et al.  Does data warehouse end-user metadata add value? , 2007, CACM.

[19]  Carlo Batini,et al.  Methodologies for data quality assessment and improvement , 2009, CSUR.

[20]  Yu Cai,et al.  Supporting data quality management in decision-making , 2006, Decis. Support Syst..

[21]  Efraim Turban,et al.  Business Intelligence: Second European Summer School, eBISS 2012, Brussels, Belgium, July 15-21, 2012, Tutorial Lectures , 2013 .

[22]  Sergio de Cesare,et al.  A Comparative Analysis Of Business Process Modelling Techniques , 2009 .

[23]  G. Shankaranarayan,et al.  Managing Data Quality in Dynamic Decision Environments: An Information Product Approach , 2003, J. Database Manag..

[24]  Markus Grünwald,et al.  Business Intelligence , 2009, Informatik-Spektrum.

[25]  William Yeoh,et al.  Enhancing Business Intelligence Traceability through an Integrated Metadata Framework , 2011 .

[26]  G. Shankaranarayanan,et al.  TOWARDS IMPLEMENTING TOTAL DATA QUALITY MANAGEMENT IN A DATA WAREHOUSE , 2005 .

[27]  B. Wangler,et al.  Horizontal and Vertical Integration of Organizational IT Systems , 2000 .

[28]  Richard Y. Wang,et al.  IP-MAP: Representing the Manufacture of an Information Product , 2000, IQ.

[29]  Thomas H. Davenport,et al.  Business Intelligence and Organizational Decisions , 2010, Int. J. Bus. Intell. Res..

[30]  Juan Enrique Ramos,et al.  Using TF-IDF to Determine Word Relevance in Document Queries , 2003 .

[31]  Ali Sunyaev,et al.  Process-Driven Data Quality Management Through Integration of Data Quality into Existing Process Models , 2013, Bus. Inf. Syst. Eng..