Title: A data analytics approach to improve the international supply of metal inputs in the metal-mechanical sector in Colombia

Authors: Lina M. Lozano-Suarez; Fabian A. Torres-Cardenas; Eduardo Rangel Díaz

Addresses: Faculty of Engineering, University of Research and Development, 48th Street # 14-61, Buenos Aires, Barrancabermeja, 687031, Colombia ' Faculty of Engineering, University of Research and Development, 48th Street # 14-61, Buenos Aires, Barrancabermeja, 687031, Colombia ' Faculty of Engineering, University of Research and Development, 48th Street # 14-61, Buenos Aires, Barrancabermeja, 687031, Colombia

Abstract: The metal-mechanical sector is vital to Colombia's industry, significantly contributing to economic development. To ensure its growth, this sector must enhance competitiveness, particularly in managing metal supplies, often imported. Analysing imports is crucial, but data from DIAN is unprocessed and provided in extensive Excel microdata packages, requiring processing. This study proposes a data analytics approach combining descriptive and predictive analyses. Descriptive analysis using DIAN's 2023 data identifies key import factors: major supplier countries, main customs entries, locations of top importers, and common transport modes. Predictive analysis using regression, decision trees, and k-NN models predicts import quantities based on free on board (FOB) value, with regression showing the highest accuracy. This approach helps companies understand factors affecting imports, such as transportation, customs management, cargo handling, and preparation, facilitating better decision-making and competitiveness.

Keywords: data analytics; supply chain; machine learning; international supply; regression model; decision tree; k-NN; metal-mechanical sector; CRISP-DM; dashboard.

DOI: 10.1504/IJDATS.2025.147519

International Journal of Data Analysis Techniques and Strategies, 2025 Vol.17 No.2, pp.121 - 139

Received: 09 Jul 2024
Accepted: 14 Oct 2024
Published online: 20 Jul 2025 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article