Title
Data governance reference model to streamline the supply chain process in SMEs
Date Issued
01 August 2019
Access level
metadata only access
Resource Type
conference paper
Publisher(s)
Institute of Electrical and Electronics Engineers Inc.
Abstract
In this paper, we propose a Data Governance reference model to streamline supply chain processes in SMEs through Data Integration and Business Analytics techniques, using the DAMADMBOK reference framework which involves a set of processes and areas of knowledge that are accepted as good practices. We defined a data governance model, measuring the quality of data, the Purchasing, Sales and Inventory processes can make decisions based on more reliable and accurate data, that management time and costs are reduced customer service is improved and staff performance is measurable. In this way, the expected results can be achieved through a Data Warehouse of Key Performance Indicators (KPIs) and Dashboards implemented in the Pentaho Open Source platform. The proposed model is defined in 5 stages: 1. Data Management, 2. Data Architecture, 3. Data Integration, 4. Data Warehousing & Business Intelligence, 5. Data Quality. A real scenario was defined in a textile company located in Lima, Perú to validate the proposal; the supply chain processes were chosen as they are critical for the business. The monthly results showed that, for the Sales process, the issuance time for sales quotations was reduced by 50% equivalent to a total of 60 man hours which means that it takes less time to produce the sales quotations. The delivery cycle for sold products was reduced by 25% equivalent to a total of 30 man hours, for the inventory process the compliance cycle of satisfactory purchase orders was reduced by 37.5% equivalent to a total of 90 man hours, which means that it takes less time to manage purchase orders; finally, for the Purchasing process the withdrawal of complaints about purchased products was reduced by 25% equivalent to a total of 30 man-hours, and the delivery time of the supplier per order of purchase was reduced in a 41.67% equivalent to a total of 150 man hours.
Language
English
OCDE Knowledge area
Ciencias de la información Negocios, Administración Ingeniería de sistemas y comunicaciones
Scopus EID
2-s2.0-85073556958
ISBN of the container
978-172813646-2
Conference
Proceedings of the 2019 IEEE 26th International Conference on Electronics, Electrical Engineering and Computing, INTERCON 2019
Sources of information: Directorio de Producción Científica Scopus