Modelo analítico y prescriptivo de madurez digital para MYPE de Bogotá mediante inteligencia de negocios y Power BI

Abstract

This research developed an analytical and prescriptive model of digital maturity, designed to evaluate the level of technological adoption among micro and small enterprises (MSEs) in Bogotá, categorized by sector (commerce, industry, and services). The model was built by integrating various official sources and open data, using business intelligence and analytics tools in Power BI. The Digital Maturity Index (DMI) consolidated strategic dimensions such as technological infrastructure, use of digital tools, electronic payments, and e-commerce. The results show that MSEs have reached an intermediate level of digital maturity, with notable progress in connectivity and access to technology, although gaps persist in e-commerce, automation, and the adoption of advanced digital solutions. The sectoral analysis revealed significant differences: while the more technologically advanced sectors made greater progress, traditional activities continue to face limitations. The use of Power BI allowed for the integration, modeling, and visualization of strategic information through interactive dashboards, facilitating comparisons and the generation of useful knowledge for decision-making. Finally, the prescriptive model complemented the quantitative diagnosis with differentiated strategic recommendations, turning the tool into a support mechanism for digital transformation processes and the strengthening of business competitiveness in Bogotá.