Project 1 - COVID-19 Vaccinations Trend Analysis
Project 1- COVID-19 Vaccinations Trend Analysis
Aim:
This project aims to analyze the trends in COVID-19 vaccinations and identify patterns and insights from the data. It also analyzes the data in detail on vaccinated people and fully vaccinated people by country in 2021-2022
Introduction:
The COVID-19 pandemic has affected the world in an unprecedented manner, with millions of people affected and many losing their lives. The development of vaccines has been one of the key strategies to combat this pandemic. With the rollout of vaccines, it has become essential to analyze the vaccination trends to evaluate the progress made and identify areas that need improvement.
The analysis will provide insights into the effectiveness of vaccination campaigns, the coverage of vaccination among different population groups, and the impact of vaccination on controlling the spread of COVID-19.
Methodology:
- Data cleaning:
The data cleaning is done by replacing null values with zero in the transform data of the Power BI desktop.
- Data interpretation:
The data set is cleared and completed. After cleaning, the dataset contains 86512 rows and 15 columns.
- Data visualization:
Visualization of the given data set was performed in Power BI Desktop. Visualizations are done with the help of charts and graphs
Analysis:
Insights
Based on the visual analysis, we can see
- top 10 countries based on total vaccination
- Total number of countries involved in vaccination
- Total number of vaccines
- People vaccinated based on year, etc
Fully_vaccinated_people by date
Sum of people_vaccinated and sum of people_vaccinated_per_hundred by date
Sum of total_vaccination and sum of total_vaccination_per_hudred by country
Top 10 fully_vaccinated_people by Country
Top 10 Total_vaccination by country
Total_vaccination percentage based on year
Total number of countries and vaccines
Daily_vaccination by country
Recommendations:
We can examine the large set of data.
We can improve the dataset by adding disease conditions of people, precautions taken by people, effects after vaccination, etc
Conclusions
In conclusion, we can see that China and India are the top 2 countries for daily vaccination. 60.79% of people were vaccinated in the year 2021 whereas 39.2% of people were vaccinated in 2022. We can see the top 10 countries based on total vaccinations and fully vaccinated people. In that, we can conclude China is the country with total vaccinations and India is the country with fully vaccinated people. There are 223 countries involved in vaccination with a total of 84 vaccines.