Business Intelligence for Cardiovascular Disease Assessment

The healthcare industry has historically generated large amounts of data for various reasons, from simple record keeping to improving patient care with foreknowledge of the subject's own medical history, not to mention the in-formation required for the organizations day-to-day operations in order to follow its' own compliance and regulatory requirements. This project primarily consists in the development of a Data Warehouse in order to transform the abundant and heterogeneous clinical data in a single multidimensional structure capable of responding promptly to the information consulting needs with no redundancy. The data being treated contains information about patients hospitalized in Cardiovascular Accidents' unit in 2016 for having suffered a cardiovascular accident. The final goal of this project is the construction of indicators using interactive data visualization BI tools through Power BI. With these indicators, it was made an analysis of multidimensional data interactively from multiple perspectives and a comparison between that data and statistics obtained from different studies.