The COVID-19 pandemic has affected millions of people worldwide, and Africa is no exception. As the pandemic continues, there is a growing need for accurate and up-to-date information about the spread of the virus. In this project, we analyze and visualize COVID-19 data for Nigeria and other African countries, which was scraped from the website https://ourworldindata.org/.
The data used in this case study was sourced from https://ourworldindata.org/ between 1st-Jan-2020 and 30th-Apr-2021. The website provides daily updates on COVID-19 cases, deaths, and recoveries from around the world.
We carried out exploratory data analysis using SQL to clean, analyze, and visualize the COVID-19 data. We used PowerBI to extract data for Nigeria and other African countries from a SQL database. The data cleaning process involved removing missing values, correcting inconsistencies, and aggregating the data by country and date.
After cleaning the data, we performed exploratory data analysis to understand the patterns and trends in the data. We created visualizations such as line charts, bar charts, and maps to summarize the data and identify insights.
Here are some of the insights derived from our analysis;
-
South Africa has one of the highest numbers of confirmed cases and deaths in Africa, with Morocco and Tunisia also being heavily affected.
-
The infection rate in Africa is 0.36%
-
Countries with the highest number of reported cases ( South Africa, Morocco, Tunisia, Egypt, Libya, Nigeria)
-
Countries with the highest number of deaths recorded ( South Africa, Morocco, Tunisia, Egypt, Libya, Nigeria)
-
Top 2 countries with the most vaccination ( Morocco and Egypt)
We also created several interactive visualizations using Power Bi visuals to allow users to explore the data further. These visualizations include:
A map showing the number of deaths by country in Africa. A line chart showing the trend in the number of confirmed cases over time for Nigeria in Africa. A bar chart showing the top 10 African countries with the highest number of confirmed cases. A dynamic slicer to filter Total Cases by country.
In conclusion, our analysis and visualization of the COVID-19 data for Nigeria and other African countries provided valuable insights into the impact of the pandemic in Africa. We hope this project helps increase awareness of the pandemic and provides valuable information for researchers and the general public in Nigeria and Africa.
Here is a link to my report: https://tinyurl.com/56swpzkp