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.

Keywords:

• Business intelligence (BI)
• data quality (DQ)
• information manufacturing
• automatic weight assignment
• design science

ACKNOWLEDGMENTS

We would like to thank the two anonymous reviewers for their invaluable feedback. We are also grateful to Dr Sayyen Teoh and Teik-Boon Tan for the helpful discussion.