Diseño e implementación de un modelo gerencial en power bi para la evaluación del desempeño y pérdida de valor en casas de cobro de entidades financieras

Díaz Hibla, Andrés Mauricio; Ramírez Torres, Hernan Dario

Diseño e implementación de un modelo gerencial en power bi para la evaluación del desempeño y pérdida de valor en casas de cobro de entidades financieras

dc.contributor.advisor	Guerrero Pirateque, David Alejandro
dc.contributor.author	Díaz Hibla, Andrés Mauricio
dc.contributor.author	Ramírez Torres, Hernan Dario
dc.contributor.corporatename	Universidad Santo Tomás
dc.contributor.cvlac	https://scienti.minciencias.gov.co/cvlac/visualizador/generarCurriculoCv.do?cod_rh=0000012753
dc.contributor.googlescholar	https://scholar.google.com/citations?user=q1guEmEAAAAJ&hl=es&oi=ao
dc.contributor.orcid	https://orcid.org/0000-0002-0032-6970
dc.date.accessioned	2026-11-03T12:17:30Z
dc.date.available	2026-11-03T12:17:30Z
dc.date.issued	2026-09-25
dc.description	Este trabajo presenta el diseño e implementación de un modelo gerencial soportado en un dashboard en Power BI para evaluar el desempeño de casas de cobro en entidades financieras. La solución integra información operativa y financiera con el fin de identificar desviaciones en la gestión, pérdida de valor y eficiencia en la relación costo-beneficio derivada del proceso de recuperación de cartera tercerizada. El modelo fue desarrollado utilizando procesos de extracción, transformación y carga (ETL) que garantizan consistencia y trazabilidad de la información, permitiendo comparar el rendimiento individual y relativo de cada casa de cobro frente a las demás y frente a su propia evolución histórica. Adicionalmente, el trabajo incorpora un documento ruta que establece los datos mínimos requeridos para la implementación del modelo y orienta la interpretación gerencial de los indicadores en Power BI. La propuesta constituye una herramienta replicable para cualquier entidad financiera en Colombia que administre cartera tercerizada y requiera fortalecer la toma de decisiones estratégicas desde la gerencia general.
dc.description.abstract	This research presents the design and implementation of a managerial model supported by a dashboard developed in Power BI for evaluating the performance and value loss generated by outsourced collection agencies in financial institutions. The solution integrates operational and financial information through ETL processes, allowing the organization to analyze recovery efficiency, collection costs, and cost-benefit relationships associated with debt recovery management. The model enables comparative and historical analysis of collection agencies based on key performance indicators such as recovery percentage, collection efficiency, and billing-to-recovery ratio. Additionally, a managerial simulator was developed to estimate the impact of portfolio reassignment strategies on expected recovery levels. The results demonstrated the existence of collection agencies with high operational costs and moderate recovery performance, materializing value loss scenarios for the organization. The proposed solution strengthens strategic decision-making, improves financial control, and provides a scalable and replicable business intelligence model for Colombian financial institutions managing outsourced debt collection processes.
dc.description.degreelevel	Especialización	spa
dc.description.degreename	Especialista en Gestión Digital Empresarial	spa
dc.format.mimetype	application/pdf
dc.identifier.citation	Díaz Hibla, A. M. y Ramirez Torres, D. H, (2026). Diseño e Implementación de un Modelo Gerencial en Power BI para la Evaluación del Desempeño y Pérdida de Valor en Casas de Cobro de Entidades Financieras. [Especialización en Gestión Digital Empresarial, Universidad Santo Tomás]. Repositorio Institucional.
dc.identifier.instname	instname:Universidad Santo Tomás	spa
dc.identifier.reponame	reponame:Repositorio Institucional Universidad Santo Tomás	spa
dc.identifier.repourl	repourl:https://repository.usta.edu.co	spa
dc.identifier.uri	http://hdl.handle.net/11634/74684
dc.language.iso	spa
dc.publisher	Universidad Santo Tomás	spa
dc.publisher.branch	CRAI-USTA Bogotá
dc.publisher.faculty	Facultad de Ingeniería Industrial	spa
dc.publisher.program	Especialización en Gestión Digital Empresarial	spa
dc.relation.references	F. Bravo-Marquez, J. Pérez, D. Parra, and J. Velásquez, “Improving debt collection via contact center information: A predictive analytics framework,” Decision Support Systems, vol. 159, 2022.
dc.relation.references	Kumar, P. (2023). Debt Management KPI Dashboard in Power BI. PK: An Excel Expert.
dc.relation.references	Torres, A., Barrios, J., & Calderón, L. (2022). Designing effective dashboards for debt management. International Journal of Business Intelligence, 12(2).
dc.relation.references	Sharma, R., Mithas, S., & Kankanhalli, A. (2014). Transforming decision-making processes. European Journal of Information Systems, 23(4), 433–441.
dc.relation.references	AccountingInsights Team. (2024). Analyzing Receivables in Power BI. Accounting Insights.
dc.relation.references	A. Sancarlos et al., "Towards a data-driven debt collection strategy based on an advanced machine learning framework," arXiv preprint arXiv:2311.06292, 2023.
dc.relation.references	F. Bravo-Marquez et al., "Improving debt collection via contact center information: A predictive analytics framework," Decision Support Systems, vol. 159, 2022.
dc.relation.references	M. Ghaffari et al., "Personalized Communication Strategies: Towards A New Debtor Typology Framework," arXiv preprint arXiv:2106.01952, 2021.
dc.relation.references	AccountingInsights Team, "Analyzing Receivables in Power BI," Accounting Insights, 2024.
dc.relation.references	P. Kumar, "Debt Management KPI Dashboard in Power BI," PK: An Excel Expert, 2023.
dc.relation.references	J. García et al., "Predictive modeling for credit collection in European fintechs," Journal of Financial Analytics, vol. 6, no. 3, 2021.
dc.relation.references	L. Martínez y V. Ríos, "The impact of emotional messaging in debt recovery communications," Behavioral Economics Review, vol. 4, 2020.
dc.relation.references	A. Torres et al., "Designing effective dashboards for debt management," International Journal of Business Intelligence, vol. 12, no. 2, 2022.
dc.relation.references	F. Ortiz y D. Salazar, "Interoperability and data governance in financial analytics," Journal of Digital Transformation, vol. 5, 2022.
dc.relation.references	J. Barrios y L. Calderón, "Power BI implementation in microfinance institutions," Latin American Journal of Business Technology, vol. 7, 2021.
dc.relation.references	M. Martínez-Soto et al., "Recurrent Neural Networks for Seasonal Debt Prediction in Rural Microfinance," Journal of Applied AI in Finance, vol. 2, no. 3, 2023.
dc.relation.references	D. Cruz et al., "Psychological Profiling for Personalized Debt Collection," Behavioral Analytics and Finance, vol. 4, no. 1, 2023.
dc.relation.references	S. Negash, "Business Intelligence," Communications of the Association for Information Systems, vol. 13, no. 1, pp. 177–195, 2004.
dc.relation.references	T. Thalhammer, C. Mayr, and H. Niederreiter, "Data-Driven Decision Making in Non Banking Financial Institutions," International Journal of Financial Technology, vol. 6, no. 2, pp. 95–110, 2022.
dc.relation.references	R. Chen, M. Liu, and J. Zhang, "Adoption of Power BI in Financial Data Analysis," Journal of Business Intelligence and Analytics, vol. 8, no. 3, pp. 42–59, 2021.
dc.relation.references	J. Fernández and P. Gómez, "Visualization Tools and KPI Tracking in Collections Management," Latin American Review of Financial Technology, vol. 5, no. 4, pp. 55–71, 2022.
dc.relation.references	G. Gómez and D. Salcedo, "Cost Efficiency in Outsourced Collection Models," Journal of Applied Financial Strategies, vol. 9, no. 1, pp. 33–48, 2020.
dc.relation.references	A. Latorre and M. Castaño, "Performance Dashboards for Monitoring Debt Collection Agencies," Revista Colombiana de Ingeniería Empresarial, vol. 13, no. 2, pp. 19 34, 2023.
dc.relation.references	H. Ríos and S. Vargas, "Segmentación efectiva de carteras por franja de mora en entidades financieras no bancarias," Revista de Estudios Financieros Latinoamericanos, vol. 11, no. 1, pp. 76–90, 2021.
dc.relation.references	R. Ortega, A. León, and C. Méndez, "KPIs estratégicos para gestión de cobranzas tercerizadas," Cuadernos de Administración Financiera, vol. 15, no. 3, pp. 122 139, 2022.
dc.relation.references	M. Tapia and E. Duarte, "Transformación digital en control gerencial: más allá de los reportes tradicionales," Revista Iberoamericana de Gestión y Tecnología, vol. 6, no. 2, pp. 81–98, 2023.
dc.rights	Attribution-NonCommercial-NoDerivs 2.5 Colombia	en
dc.rights.accessrights	info:eu-repo/semantics/openAccess	spa
dc.rights.coar	http://purl.org/coar/access_right/c_abf2
dc.rights.local	Abierto (Texto Completo)	spa
dc.rights.uri	http://creativecommons.org/licenses/by-nc-nd/2.5/co/
dc.subject.keyword	Business Intelligence
dc.subject.keyword	Power BI
dc.subject.keyword	Debt recovery
dc.subject.keyword	Value loss
dc.subject.keyword	Financial institutions
dc.subject.lemb	Gestión Digital Empresarial
dc.subject.lemb	Cartera de crédito -- Recuperación
dc.subject.lemb	Toma de decisiones
dc.subject.proposal	Inteligencia de negocios
dc.subject.proposal	Power BI
dc.subject.proposal	Recuperación de cartera
dc.subject.proposal	Pérdida de valor
dc.subject.proposal	Entidades financieras
dc.title	Diseño e implementación de un modelo gerencial en power bi para la evaluación del desempeño y pérdida de valor en casas de cobro de entidades financieras
dc.type	bachelor thesis
dc.type.coar	http://purl.org/coar/resource_type/c_7a1f
dc.type.coarversion	http://purl.org/coar/version/c_ab4af688f83e57aa	spa
dc.type.drive	info:eu-repo/semantics/bachelorThesis	spa
dc.type.local	Trabajo de grado	spa
dc.type.version	info:eu-repo/semantics/acceptedVersion	spa