Diseño de un sistema de información para la evaluación y control de rendimientos financieros de los contratos interadministrativos entre el Departamento Nacional de Planeación y ENTerritorio N°877-2021/ENT221009

Abstract

This work presents the design and implementation of an information system to optimize the evaluation and control of the financial performance of the inter-administrative contract No. 877-2021/ENT221009 between the National Planning Department (DNP) and ENTerritorio. The initiative responds to the need to overcome data dispersion and reliance on manual processes through the development of an interactive dashboard in Microsoft Power BI. Applying principles of continuous improvement (Kaizen), the solution integrates a robust process for cleaning and standardizing data from 196 contracts, enabling dynamic analysis and strategic portfolio segmentation. The system enables the identification of critical contracts—revealing that 17% of the contracts account for 80% of the financial returns—and facilitates a precise performance evaluation through custom-built indicators. The result is a strategic tool that significantly improves operational efficiency, strengthens evidence-based decision-making, and increases transparency in the management of public resources.