Plan de mejora para fortalecer el análisis de información logística en la gerencia de logística, transporte e infraestructura de la asociación nacional de empresarios de Colombia (ANDI) mediante la implementación de tableros de business intelligence en power bi.

Abstract

The purpose of this professional internship report is to design an improvement plan aimed at strengthening logistics information analysis within the Logistics, Transportation and Infrastructure Management Department of the National Association of Colombian Entrepreneurs (ANDI), with the objective of optimizing the processing, analysis, and visualization of strategic information through the implementation of Business Intelligence tools and the monitoring of logistics indicators to support decision-making (Microsoft, 2025).

The National Association of Colombian Entrepreneurs (ANDI) is one of the country’s most representative business associations, committed to strengthening competitiveness, business development, and the analysis of strategic issues related to logistics, transportation, and infrastructure. During the professional internship, it was identified that the department has information from various official entities to monitor land, rail, and maritime-river freight transportation. However, this information was distributed across multiple independent databases and spreadsheets, which made its integration, analysis, and timely visualization difficult for supporting report generation and decision-making.

In response to this situation, this project proposes an improvement plan focused on three strategic areas: the standardization and automation of data processing through ETL processes developed in Power Query; the design and implementation of interactive dashboards in Microsoft Power BI to monitor land, rail, and maritime-river freight transportation through key performance indicators (KPIs); and the strengthening of information analysis through the consolidation of data models and visualization tools that facilitate the interpretation of trends, optimize report preparation, and support decision-making within the Logistics, Transportation and Infrastructure Management Department.

To develop the proposal, a methodology based on direct observation, SWOT analysis, the assessment of information management processes, and the examination of the data sources used during the professional internship was employed. As a result, automation processes, data models, Business Intelligence dashboards, and strategic indicators were developed to strengthen the department’s analytical capabilities, improve information availability, and contribute to monitoring freight transportation trends in Colombia.