Desarrollo de un sistema de reservas en Power Apps, con integración de Power BI, para la gestión eficiente de aulas en la matriz de Quito y el edificio Tenerife de la UTPL, optimizando los procesos administrativos

Abstract

Abstract: This project describes the development of a classroom reservation system for the Universidad Técnica Particular de Loja (UTPL), at its headquarters in Quito and the Escuela de Desarrollo Empresarial y Social de la UTPL (EDES). It addresses the problems of classroom management, which are performed manually in a shared Excel file, which leads to different conflicts: accidental deletion of reservations, lack of real-time information, lack of notifications, conflicts of schedules, which generates inconveniences in the administrative management. To obtain the functional and non-functional requirements, surveys will be made to the different administrative staff of the UTPL and EDES, once the results are analyzed, they will be developed with the agile methodology (scrum), giving rise to user stories, where the software function is described in general terms with the user's perspective, the different tasks are also obtained, all this is summarized in a product backlog and the sprints necessary to make the system. The system is developed using n-layer architecture, with Power Apps as the user interface, integrated with Power BI and Power Automate, to significantly improve classroom allocation, obtaining automatic flows with real-time information on available classrooms and generating reports to facilitate better decision-making, reducing administrative time and effort. Talend Data Quality is used to check the accuracy, integrity, consistency, and completeness of the data, achieving an 87% confidence score and 100% valid values in data quality.