Implementación de una Herramienta para Gestión de Información de caudales de captación y producción en la (EPMAPS) aplicando Inteligencia de Negocios

Abstract

This integration project is a report for the Quito Public Metropolitan Water and Sanitation Company, a company that is made up of several departments in charge, day after day, of making important decisions regarding the water capture and production processes. This information is handled in a semi-automated way, since it is extracted and processed in spreadsheets before being manually archived, which generates problems in the search for historical information.

To solve these problems, in this project was designed and implemented a Business Intelligence solution applying the CRISP - DM methodology, adapting it to the needs of the project. The perspectives and indicators that will be used to analyze the data were taken based on the information obtained in the needs specification process.

The resulting solution allows the company to generate comparative statistical data of the processes of capture and production of water volume. This data is sent to the end user by means of graphs and tables through reports that allow better analysis of the information obtained on the volume of the capture and production processes, in order to make an optimal decision-making.