Project 1 - COVID-19 Vaccinations Trend Analysis

hello, here is my power bi project 1 , below im attaching ppt and bi file.

AIM

The aim of this project is to analyze the dataset to know the vaccinations trends with different countries in 2021-2022.

INTRODUCTOPN

COVID-19 pandemic was the difficult time for the mankind, it has affected millions of people around the world and the vaccination drive has been initiated globally to combat the virus. The vaccination rate varies for different countries, the main objective of this project is to analyze the data and state the factors influencing it.

PROBLEM STATEMENT

• We have to find people who have fully vaccinated among vaccinations done.
• Total vaccinations per country, per year.
• Country with the highest and lowest vaccinations.

METHODOLOGY

• Data cleaning: the dataset had some missing values by using transform data I have replaced it with 0.
• Data interpretation: after replacing null with zero, the dataset contains 15 columns and 86512 rows.
• Data has been cleaned and ready for visualization, to create visuals I have used power bi desktop software.

ANALYSIS

• The dataset available is from 2nd December 2020 to 29th March 2021
• Total Daily vaccinations by Year and Month.
• sum of people fully vaccinated by month.
• Daily vaccinations by year and month.
• Top 10 countries with total vaccinations.
• Top 10 countries with daily vaccinations.

INSIGHTS

• The month march has highest fully vaccination rate.
• Daily highest vaccination was July 2021,1.2bn.
• China is the 1st country to have total highest vaccinations and daily vaccinations.

RECOMENDATIONS

• Based on the insights gathered from the analysis, the following recommendations are made:
• Countries with lower vaccination rates should focus on improving their vaccine distribution strategies to ensure that vaccines are reaching all parts of their population.
• Governments and international organizations should work to address the underlying economic and social factors that are contributing to vaccine hesitancy in certain populations.
• Governments should prioritize the use of Pfizer and Moderna vaccines to maximize the effectiveness of their vaccination programs.

CONCLUSION

• In conclusion, we analyzed the trend of COVID-19 vaccinations across different countries and identified the factors that influence the pace of vaccinations. Our analysis showed that population density and access to healthcare were significant factors that influenced the pace of vaccinations. Based on our findings, we made recommendations for countries to increase their vaccination drive and improve their healthcare infrastructure to combat the virus.