Diseño de un modelo metodológico para el fortalecimiento de la gestión de indicadores institucionales mediante analítica de datos en la Alcaldía de Bucaramanga

Abstract

The Bucaramanga Mayor's Office lacked a consolidated and standardized inventory of its institutional performance indicators, resulting in methodological fragmentation across government departments and non-compliance with the standards established by the National Statistical System (NSS), thereby limiting evidence-based decision-making. This study aimed to design a methodological model to strengthen the management of institutional performance indicators through data analytics by integrating a technical diagnostic assessment, a standardized documentation instrument, and a digital visualization tool. A mixed-methods business internship was conducted over 480 hours and structured into three phases: (1) diagnosis of 46 indicators from eight departments against the 21 mandatory NSS fields using an Extract, Transform, and Load (ETL) process implemented in Python; (2) redesign of the official Indicator Data Sheet and development of an institutional strengthening plan; and (3) development of a Power BI dashboard prototype. The results showed a weighted average completeness of 37.7% across the assessed indicators, a new NSS-aligned Indicator Data Sheet, an institutional strengthening plan comprising nine strategies distributed across three implementation horizons, and a functional dashboard deployed within the institutional environment containing 86 indicators from nine departments. The findings demonstrate that transforming indicator management in public institutions depends not only on the technical quality of management instruments but also on effective organizational change management, particularly during periods of administrative transition.