Diseño e implementacion de un sistema de bi, para analizar losprocesos mas criticos mediante indicadores estaticos y dinamicos. un caso de estudio.

Abstract

The project was based in the development of a Business Intelligence (BI) system for “Colegio de Médicos de Pichincha (CMP)” with the objective of analyzing the demand of affiliates and the money income of the CMP. HEFESTO methodology was used, which involves the management of tools and techniques such as the selection of software for data analysis, visualization tools and data mining techniques for the creation of a DHW that will help the CMP Directory to take decisions based on the improve of their services. Subsequently, it was maked the analysis of the demand for affiliates, reaffiliates, disaffiliations from 2011 to 2015 and a projection of money income for the year 2023 was carried out using Machine Learning based on the training of the linear regression model with estimated data and historical data obtained of the CMP Data Base. The final result was displayed on the web, using the Power BI tool, defining different components and visual graphics for a better understanding of the data. The validation of usability of the BI system was evaluated by 23 users based on SUS (System Usability Scale), between users of CMP Directory and users with basic knowledge in BI, which concluded that the BI system has well-structured management indicators and aesthetic details it observed to improve.