Design and development of a data warehouse for COVID-19 case analysis

The present bachelor's thesis concerns the design and development of a Data Warehouse for the analysis of epidemiological data from the COVID-19 pandemic.The objective is the organized collection and processing of large volumes of data to produce reliable reports and visualizations that aid in understanding the spread of the virus.For the implementation, data from international organizations are utilized, and Extraction, Transformation, and Loading (ETL) processes are applied for their cleaning and homogenization.At the same time, interactive dashboards are developed, offering the visualization of critical indicators, such as cases and hospitalizations, facilitating the identification of trends.Overall, this work highlights the importance of Data Warehouses and Business Intelligence systems as decision support tools in the field of public health.