In this project, we intend to develop a data warehousing system, as well as a business ingelligence system to support clinical decisions (Technical report).
Analysis, planning and implementation work was carried out based on the dataset provided. Subsequently, an initial settlement system was develop, as well as the necessary structures to update it in an incremental and differential way. Finally, the business intelligence system was developed on the Tableau Desktop Platform.
- Urgency_Episodes: Urgency episodes data
- Urgency_Prescriptions: Prescriptions made for each emergency episode
- Urgency_Exams: Exams performed during an emergency episode
- ICD-9_Hierarchy: Diagnostic codes and their descriptions, according to the ICD-9 nomenclature system
New schema for import -> dados
| File | Info |
|---|---|
| change.py | Correction of birth dates |
| noNullID.py | Correction of null values in csv files |
| Povoamento.sql | Initial population of the data warehouse |
| retencao.sql | Schema creation for the retention area and its relationships |
| queries_retencao.sql | Data processing and insertion in the retention area |
| toCSV.sql | Data migration from retention area to csv files |
| retencaoToDW.sql | Updating the data warehouse with data from the retention area |
| updateDW.sql | Script for updating the data warehouse and deleting data from the retention area |
| Name |
|---|
| Carolina Cunha |
| Hugo Faria |
| João Diogo Mota |
| Rodolfo Silva |
University of Minho, Software Engineering (4th Year).
