Dashboard inteligente para la gestión de vacaciones y permisos en el Consejo de la Judicatura

Edward  Vega Enriquez; Freddy  Cedillo Rivera; Joffre  Cartuche Calva; Dixys  Hernández Rojas

doi:10.59169/pentaciencias.v8i3.1842

Authors

Edward Vega Enriquez Universidad Técnica de Machala https://orcid.org/0000-0003-0394-7462
Freddy Cedillo Rivera Universidad Técnica de Machala https://orcid.org/0009-0002-4243-9751
Joffre Cartuche Calva Universidad Técnica de Machala https://orcid.org/0000-0002-1633-2291
Dixys Hernández Rojas Universidad Técnica de Machala https://orcid.org/0000-0002-2116-6531

DOI:

https://doi.org/10.59169/pentaciencias.v8i3.1842

Keywords:

dashboard; leave management; human resources; data analytics; automation

Abstract

This study aims to develop a functional intelligent dashboard prototype oriented toward improving the management of vacations and leave requests at the Council of the Judiciary of El Oro. This proposal seeks to reduce the various problems that arise from carrying out a partially manual process for managing these requests. The objective was to design and develop a functional prototype that centralizes information, automates visualizations, and provides key indicators in real time. The Scrum methodology was employed for iterative development, accompanied by the Big Rocks strategy for better prioritization of deliverables. As a result, a functional prototype was developed using Angular 20 and Spring Boot (Java 21) with Spring Data JPA, structured on a SQL Server database, featuring 17 visual components including KPI cards, distribution charts, temporal analysis, and operational tables. The prototype was evaluated using the ISO/IEC 25010 quality model, validating its compliance with key software quality characteristics. It is concluded that the prototype is technically viable and constitutes a functional proposal that could lay the groundwork for a future implementation in institutional human talent management processes.

Downloads

Download data is not yet available.

References

Ciancarini, P., Giancarlo, R., & Grimaudo, G. (2024). Digital Transformation in the Public Administrations: A Guided Tour for Computer Scientists. IEEE Access, 12, 22841-22865. https://doi.org/10.1109/ACCESS.2024.3363075

Covey, S. R. (2004). The 7 habits of highly effective people: Restoring the character ethic (Rev. ed.). Free Press.

Frempong, D., Akinboboye, O., Okoli, I., Afrihyia, E., Umar, M. O., Umana, A. U., Appoh, M., & Omolayo, O. (2022). Real-Time Analytics Dashboards for Decision-Making Using Tableau in Public Sector and Business Intelligence Applications. Journal of Frontiers in Multidisciplinary Research, 3(2), 65-80. https://doi.org/10.54660/.IJFMR.2022.3.2.65-80

International Organization for Standardization. (2011). ISO/IEC 25010:2011—Systems and software engineering—Systems and software Quality Requirements and Evaluation (SQuaRE)—System and software quality models (ISO/IEC 25010:2011). ISO.

Jiménez-Partearroyo, M., & Medina-López, A. (2024). Leveraging Business Intelligence Systems for Enhanced Corporate Competitiveness: Strategy and Evolution. Systems, 12(3), 94. https://doi.org/10.3390/systems12030094

León Espinoza, L. A. (2024). Inteligencia Artificial en la Gestión de Recursos Humanos: Tendencias y Perspectivas. https://doi.org/10.5281/ZENODO.13308360

Maricahua, J. T. (s. f.). Digital transformation and human talent management: A systematic review of scientific evidence (2020–2024).

Matheus, R., Janssen, M., & Maheshwari, D. (2020). Data science empowering the public: Data-driven dashboards for transparent and accountable decision-making in smart cities. Government Information Quarterly, 37(3), 101284. https://doi.org/10.1016/j.giq.2018.01.006

Outeda, C. C., & Gamarra, Ó. B. (2026). Digital Transformation and Human Resources Planning in Public Administration: Insights from the Spanish Experience. Białostockie Studia Prawnicze, 31(1), 197-215. https://doi.org/10.15290/bsp.2026.31.01.11

Sakib, Md. N., Chowdhury, S. R., Younus, M., Sanju, N. L., Satata, F. F., & Islam, M. (2024). How HR analytics evolved over time: A bibliometric analysis on Scopus database. Future Business Journal, 10(1), 87. https://doi.org/10.1186/s43093-024-00375-9

Sánchez Lunavictoria, J. C., Gaibor Coello, A. S., Leon Muñoz, L. E., & Tenemaza Fernández, D. A. (2023). Inteligencia de negocios para la gestión del talento humano: Mejorando la eficiencia organizacional. Visionario Digital, 7(4), 212-223. https://doi.org/10.33262/visionariodigital.v7i4.2869

The OECD digital government policy framework: Six dimensions of a digital government (OECD Public Governance Policy Papers No. 02; OECD Public Governance Policy Papers, Vol. 02). (2020). https://doi.org/10.1787/f64fed2a-en

Valero Torrijos, J., & Cerdá Meseguer, J. I. (2020). Transparencia, acceso y reutilización de la información ante la transformación digital del sector público: Enseñanzas y desafíos en tiempos del COVID-19. EUNOMÍA. Revista en Cultura de la Legalidad, 103-126. https://doi.org/10.20318/eunomia.2020.5705