Rotimi Omolabake Awoyemi

COVID-19 ANALYSIS REPORT Power BI Desktop Region and Date  All  Total Tests Total Population Total Cases Total Deaths Total Recovered 6bn 268M 19M 713K 12M Confirmed and Recovered cases by Month % Population by Continent South America 6,81% Active Cases North America 9,32% 6M 362,90M Africa 21,24% 246,53M 199,59M Europe 11,82% 144,99M Australia/O… 0,65% 63,39M Mortality Rate (%) 1,66M January February March 15,94M April 52,88M May June Month Asia 50,17% 6,12 0,04M 9,00M 116,98M Sum of confirmed Death cases by Month Sum of recovered WHO-Region by Continent South America 6,52% 15,71M 13,31M North America 13,04% Africa 29,35% 9,61M Cases per Capita 0,66 4,31M Europe 23,91% 0,00M 0,05M 0,40M January February March April Month May June July Australia/Oceania 2,17% Asia 25% July COVID-19 ANALYSIS REPORT Power BI Desktop Region and Date  All  Total Tests Total Population Total Cases Total Deaths Total Recovered 6bn 268M 19M 713K 12M Top 5 Regions by Active cases Active Cases Confirmed Cases by Top 5 Region 156,98M US 6M 31,09M Brazil 22,62M United Kingdom 19,67M Russia © ©- Microsoft Microsoft Corporation Corporation Mortality Rate (%) 15,99M India Recovered cases by WHO-Region 6,12 Americas Sum of recovered 4,5M who_region Europe Cases per Capita 0,66 New cases by Top 5 Region Sum of recovered 2,0M Eastern Mediterra… Sum of recovered 1,2M South-East Asia Sum of recovered 1,2M Africa Sum of recovered 0,4M Western Pacific Sum of recovered 0,2M 0M 2M Sum of recovered 4M © ©- Microsoft Microsoft Corporation Corporation Insights: Power BI Desktop • Our analysis revealed critical trends, such as regions with the highest mortality rates, daily case growth patterns, and the relationship between population density and infection rates. Challenges: • Key challenges included handling missing data, ensuring consistency across datasets, and optimizing dashboard performance. We addressed these through data cleaning, DAX measures, and efficient data modeling. Recommendations • Based on the insights, we recommend targeted resource allocation, enhanced testing in high-density areas, and prioritizing vaccination campaigns in regions with rising active cases.