Improving Business Intelligence Traceability and Accountability: An Integrated Framework of BI Product and Metacontent Map

A Business Intelligence (BI) system provides users with multi-dimensional information (a so-called 'BI product') to support decision-making. However, existing BI systems overlook the lineage metadata which supports individual data quality dimensions such as data believability and ease of understanding. Using a design science research paradigm, this paper proposes and develops an integrated framework (known as BI Product and Metacontent Map-'BIP-Map') to facilitate the traceability and accountability of BI products. Specifically, the business workflow layer of the integrated framework is modelled using business process modelling notation, and an information product map is used to model the second layer's information manufacturing process, whilst the third layer represents the metacontent detail of the data validation stage, from source system through to ETL, to the data warehousing stage. Also, the authors develop a BIP-Map informed prototype in collaboration with an online job advertising firm, the framework then being validated by key BI stakeholders of the firm. The integrated framework addresses individual-related data quality issues and builds user confidence by enhancing the traceability and accountability of a BI product.

[1]  Carol V. Brown,et al.  Designing data governance , 2010, CACM.

[2]  R. Tibshirani,et al.  An introduction to the bootstrap , 1993 .

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

[4]  Evert Gummesson,et al.  Qualitative research in marketing , 2005 .

[5]  R. M. Bogza,et al.  Business intelligence as a competitive differentiator , 2008, 2008 IEEE International Conference on Automation, Quality and Testing, Robotics.

[6]  WenAn Tan,et al.  A Business Process Intelligence System for Enterprise Process Performance Management , 2008, IEEE Transactions on Systems, Man, and Cybernetics, Part C (Applications and Reviews).

[7]  Antonio Badia,et al.  Semistructured Data and its Conceptual Models , 2005, Encyclopedia of Database Technologies and Applications.

[8]  Arun Sen,et al.  Metadata management: past, present and future , 2004, Decis. Support Syst..

[9]  Peter J. H. King,et al.  A Database Interface for Link Analysis , 2005, J. Database Manag..

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

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

[12]  Amit Gupta,et al.  Dimensional Modeling: In a Business Intelligence Environment , 2006 .

[13]  Ganesan Shankaranarayanan,et al.  Supporting data quality management in decision-making , 2006 .

[14]  Lorcan Dempsey,et al.  Metadata: a current view of practice and issues , 1998, J. Documentation.

[15]  Klaus R. Dittrich,et al.  Metadata management for data warehousing: between vision and reality , 2001, Proceedings 2001 International Database Engineering and Applications Symposium.

[16]  Alan R. Hevner,et al.  Design Research in Information Systems , 2010 .

[17]  Mark L. Gillenson,et al.  Data Management and Data Administration: Assessing 25 Years of Practice , 2011, J. Database Manag..

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

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

[20]  John S. Erickson Database Technologies: Concepts, Methodologies, Tools, and Applications (4 Volumes) , 2009, Database Technologies: Concepts, Methodologies, Tools, and Applications.

[21]  Michael J. Davern,et al.  Measuring the effects of business intelligence systems: The relationship between business process and organizational performance , 2008, Int. J. Account. Inf. Syst..

[22]  Yan Shi,et al.  The Role of Business Intelligence in Business Performance Management , 2010, 2010 3rd International Conference on Information Management, Innovation Management and Industrial Engineering.

[23]  Dursun Delen,et al.  An integrated and intelligent DSS for manufacturing systems , 2006, Expert Syst. Appl..

[24]  Angelo Brayner,et al.  Integrating Heterogeneous Data Sources in the Web , 2009, Database Technologies: Concepts, Methodologies, Tools, and Applications.

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

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

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

[28]  Hongwei Ding,et al.  A Comparison of Business Process Modeling Methods , 2006, 2006 IEEE International Conference on Service Operations and Logistics, and Informatics.

[29]  Paulraj Ponniah,et al.  Data Warehousing Fundamentals , 2001 .

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

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

[32]  Richard Y. Wang,et al.  Manage Your Information as a Product , 1998 .

[33]  Hongwei Zhu,et al.  Information Quality Framework for Verifiable Intelligence Products , 2009 .

[34]  Paul P. Tallon Corporate Governance of Big Data: Perspectives on Value, Risk, and Cost , 2013, Computer.

[35]  Robert Winter,et al.  The Value of Business Metadata: Structuring the Benefits in a Business Intelligence Context , 2011 .

[36]  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).

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

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

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

[40]  Alan R. Hevner,et al.  Design Research in Information Systems: Theory and Practice , 2010 .