Development of a data warehouse to support the evaluation of a cervical cancer screening program

Abstract

"[ENG] The aim of this work was to develop a data warehouse (DW) in order to support the management of the cervical cancer screening program in the municipality of Rio de Janeiro/Brazil. As a part of the management process, the program managers of the municipality perform tedious manual work in order to calculate a series of test-based and woman-based performance indicators. The developed DW was implemented using the Pentaho BI Suite business intelligence platform and the MySQL database manager. The indicators to be calculated and visualized in the DW were based on the municipal data of cytopathology and histopathology tests from January 2012 until December 2014, which was obtained from the Cervical Cancer Information System (SISCOLO). The developed DW allowed the visualization of a set of test-based and woman-based indicators from different views and dimensions, which enable managers to monitor all the phases of the screening process and to identify the process’ failures. Compared with the current available environments, this DW is unique in the visualization of the follow-up indicators of group of women, according to their test results and age. Thereby it provides presentation flexibility to suit the program manager's needs."