Optimización del Proceso de Gestión de Información en la Cámara de la Industria Cosmética y Aseo – ANDI Bogotá

Abstract

This paper presents an improvement plan to optimize the management of foreign trade data analysis reports within the cosmetics and toiletries industry chamber of the ANDI (National Association of Entrepreneurs). Based on an understanding of the previous workflow (based on manual processes and using only Excel), a solution was designed and implemented that automates the cleaning, categorization, and visualization of information. The analytical basis considers key variables such as tariff chapters, code, tariff item description, weight, FOB and CIF value, and countries of arrival or origin. The proposal integrates programs such as Python, where a custom script was created for the chamber, standardizing data processing and replicable categorizations of tariff items by sector. This code was entered manually, taking into account classification rules to ensure accuracy and consistency. In addition, an interactive dashboard was designed in Power BI, connected to Excel files in SharePoint that the entire team can easily access, which in turn enables automatic updating by simply adding new months. As a result, the report delivery process was reduced by fifteen days and can now be completed in a single day. Additionally, the number of operational errors was reduced, traceability was improved, processes were standardized, and on-site training and explanatory documents were provided to plant personnel and the next intern in charge, allowing for the establishment of a scalable and replicable model for continuous foreign trade analysis and decision-making support.