A Framework to Support Quality Data Mart Solutions: an approach developed based on practical cases

Abstract

Purpose – Today, due to the large amount of data available in companies, solutions for extracting information and knowledge to support decision-making processes are needed. To address this issue, data mart implementation with proper dashboard can represent good solutions. However, due to the complexity involved in this kind of projects and its multidisciplinary nature, appropriate methodologies for conducting data mart development are needed. The present study aims to propose a framework to guide the process of development of quality data marts in a Portuguese electronics company. Methodology – The methodology used to conduct this study combined the principles of two wellknown approaches – DMAIC and BPM. The first was useful in addressing and understanding the problem, while the second was used to guide the process. Two practical cases were used, the first as an experimental scenario and the second one as a testing scenario. Findings – The main result of this study is a ready to use framework to guide industrialization teams in development of quality data marts to help users in their decision-making processes. Originality/value – As there are no standard procedures available for companies to implement quality data mart solutions, the proposed framework, which is easy to apply, can be a valuable tool when a company wants to industrialize a new product. It can also be valuable for researchers working at the interface of the Quality and Information Systems areas.