A Framework to Support Quality Data Mart Solutions: an approach developed based on practical cases
A Framework to Support Quality Data Mart Solutions: an approach developed based on practical cases
Índice
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 well- known 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.
See paper
Aalst, W. M. P. van der (2013) ‘Business Process Management: A Comprehensive Survey’, ISRN Software Engineering. Hindawi Publishing Corporation, 2013, p. 37. doi: 10.1155/2013/507984.
ASQ (2020) DMAIC Process: Define, Measure, Analyze, Improve, Control | ASQ. Available at: https://asq.org/quality-resources/dmaic (Accessed: 26 May 2020).
Chinosi, M. and Trombetta, A. (2012) ‘BPMN: An introduction to the standard’, Computer Standards and Interfaces. North-Holland, 34(1), pp. 124–134. doi: 10.1016/j.csi.2011.06.002.
Cockburn, A. (1999) Writing effective use cases. doi: 10.1145/505894.505918.
Council for Six Sigma Certification (2018) Six Sigma A Complete Step-by-Step Guide. Available at: https://www.sixsigmacouncil.org/wp-content/uploads/2018/08/Six-Sigma-A-Complete-Step-by- Step-Guide.pdf.
Dumas, M. et al. (2018) Fundamentals of Business Process Management. 2nd Editio. Springer- Verlag GmbH, DE part of Springer Nature. doi: 10.1007/978-3-662-56509-4.
Geiger, M. et al. (2018) ‘BPMN 2.0: The state of support and implementation’, Future Generation Computer Systems. Elsevier B.V., 80, pp. 250–262. doi: 10.1016/j.future.2017.01.006.
Hamoud, A. K., Ulkareem, M. A., et al. (2020) ‘Improve HR Decision-Making Based On Data Mart and OLAP’, Journal of Physics: Conference Series PAPER. doi: 10.1088/1742-6596/1530/1/012058.
Hamoud, A. K., Hussien, H. N., et al. (2020) ‘Improving Service Quality Using Consumers’ Complaints Data Mart which Effect on Financial Customer Satisfaction’, Journal of Physics: Conference Series. doi: 10.1088/1742-6596/1530/1/012060.
Inmon, W. H. (2002) Building the Warehouse. Third Edit. Edited by R. Elliott. John Wiley & Sons, Inc.
Jayashree, G. and Priya, C. (2020) ‘Comprehensive Guide to Implementation of Data Warehouse in Education’, in Lecture Notes in Networks and Systems. Springer, pp. 1–8. doi: 10.1007/978-981-15- 3284-9_1.
Jensen, C. S., Pedersen, T. B. and Thomsen, C. (2010) Multidimensional Databases and Data Warehousing, Synthesis Lectures on Data Management.
doi: 10.2200/s00299ed1v01y201009dtm009.
Maimon, O. and Rokach, L. (2010) Data Mining and Knowledge Discovery Handbook (Second Edition). 2nd edn. Springer International Publishing. doi: 10.1007/978-0-387-09823-4.
Montgomery, D. C. (2019) Introduction to Statistical Quality Control. 6th editio. John Wiley & Sons Inc.
Object Management Group, O. (2011) About the Business Process Model And Notation Specification Version 2.0. Available at: https://www.omg.org/spec/BPMN/2.0/ (Accessed: 20 June 2020).
Ouali, S., Mhiri, M. and Bouzguenda, L. (2016) ‘A Multidimensional Knowledge Model for Business Process Modeling’, in Procedia Computer Science. Elsevier B.V., pp. 654–663. doi: 10.1016/j.procs.2016.08.247.
Park, H. et al. (2020) ‘Developing a Production Scheduling System for Modular Factory Using Constraint Programming’, in Advances in Intelligent Systems and Computing. Springer Verlag, pp. 126–133. doi: 10.1007/978-3-030-19648-6_15.
Smith, L. R. and Phadke, M. S. (2005) ‘Some thoughts about problem solving in a DMAIC framework’, Int. J. Six Sigma and Competitive Advantage, 1(2), pp. 151–166.
Quality, Data Mart, DMAIC, BPM lifecycle, BPMN 2.0Quality, Data Mart, DMAIC, BPM lifecycle, BPMN 2.0