An exploratory investigation of Factors Influencing Data Quality in Data Warehouse

Abstract

Data quality is of paramount importance in any Busine ssInte llige nce (BI) proje ct. In fact, the De cision Support S ystem can be the reference decision unless the data is consistent, update d, comple te d and fit for use for the de cision make rs and the decision tasks. O therwise, the non-quality data may lead policy make rs to make bad de cisions, to miss opportunities or e ven commit ve ry se rious business mistakes. Conside ring this issue, we propose to study in this paper the factors that influence the quality of inte llige nce data, or rathe r the factors mode rating the influence of the quality of source data since this last one is inevitable . We conduct an exploratory research in order to gather information from the literature review that helps us to suggest hypothesis of our research model "Factors Influencing Data Quality in a Data Warehouse". The objective of identifying the critical ones throw a confirmatory re search (that we don't e xpose in this pape r) will be to enable stakeholde rs to be tte r use their scare resources while implementing a BI project by focusing on these key areas that are most likely to have a greater impact.

Data in Data Warehouse and its Qualities Issues

“…Firstly the data is analyzed with respect to the standard of the work we are doing. Analyzing the data at very first stage helps us to examine the basic problem and issues in the data and save time at the time of implementing the work [1], [2], [4].…”

“…After all the steps are performed a final check is made to see any ambiguity left, and the data is put in a way to be easily recognized in specific manner [4].…”

“…Number of attempt is made to measure the quality of data and to identify its dimensions. Extend to data quality basically includes accuracy and precision of data, is data reliable, importance of data, data consistency, understandability, responsiveness, accurateness, utility [4]. Some factors are there for data quality check given below for our research work…”

Empirical study of Data Completeness in Electronic Health Records in China

“…A large body of literature has investigated factors influencing data quality (e.g. Al-Hiyari et al (2013), Tee et al (2007), Xu et al (2002), and Zellal and Zaouia (2015)). Recent developments in that strand of literature (Xiao et al, 2009;Xu, 2013) propose that data management contributes to data quality.…”

Achieving Data Completeness in Electronic Medical Records: A Conceptual Model and Hypotheses Development

“…In other words, the commitment to data quality activities should address both at organizational and individual level. A body of literature indicates that commitment of top management is a key contributor to quality management [4,8,9,11]. Top management team needs to make many decisions on regulations and processes management and resources allocation in order to achieve goals of data quality [5].…”