Implementación de un BI para analizar la provisión de servicios de salud en los últimos 8 años, utilizando PostgreSQL y Pentaho

The goal of this Titulation project is the datawarehouse construction with information obtained from the web portal of the INEC, referring to the provision of health services in the last eight years, to analyze the provision of health services according to four analysis criteria: time, specialty, he...

Descripción completa

Autor Principal: Quiroz Quiroz, Jorge David
Otros Autores: Reyes Zúñiga, Javier Andrés
Formato: bachelorThesis
Idioma: spa
Publicado: 2017
Materias:
Acceso en línea: http://dspace.ups.edu.ec/handle/123456789/14465
Etiquetas: Agregar Etiqueta
Sin Etiquetas, Sea el primero en etiquetar este registro!
Sumario: The goal of this Titulation project is the datawarehouse construction with information obtained from the web portal of the INEC, referring to the provision of health services in the last eight years, to analyze the provision of health services according to four analysis criteria: time, specialty, health entity and geographical location, through OpenSource business intelligence tools. For the elaboration of the present project, techniques and processes of data collection like ETL (extraction, transformation and load) were used for the construction of the warehouse using PostgreSQL were used, to carry out own tasks of intelligence of businesses (BI), like the elaboration of reports in Pentaho Report Designer and the application of algorithms of data mining in Weka. The SCRUM methodology allowed to manage the project based on functional partial deliveries, facilitating change management, priorities and time control.