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...

Deskribapen osoa

Gorde:
Xehetasun bibliografikoak
Egile nagusia: Quiroz Quiroz, Jorge David (author)
Beste egile batzuk: Reyes Zúñiga, Javier Andrés (author)
Formatua: bachelorThesis
Hizkuntza:spa
Argitaratua: 2017
Gaiak:
Sarrera elektronikoa:http://dspace.ups.edu.ec/handle/123456789/14465
Etiketak: Etiketa erantsi
Etiketarik gabe, Izan zaitez lehena erregistro honi etiketa jartzen!
Deskribapena
Gaia: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.