Project 1 - COVID-19 Vaccinations Trend Analysis

Project 1 - COVID-19 Vaccinations Trend Analysis




Aim:

Aim of the project is to analyse the data on vaccinated people and fully vaccinated people by country

Introduction:

The main objective of this project is to analyse the data on, COVID-19 Vaccinations. Through the Analysis of data, we can find out some important insights.

Problem statement:

From this project, we find out in different countries how many people are vaccinated or fully vaccinated in 2020 – 2022

Methodology:

• In the Country, Vaccination data set the first column is that Country in country column presents different countries.
• In the iso code column containing the iso code for the country. And in the data set contain a date for Vaccination.
• Another column is total Vaccination, People Vaccination, People fully Vaccination, Daily Vaccinated raw, Daily Vaccinations, Total Vaccinations per hundred, people Vaccination per hundred, People fully Vaccinated per Hundred, and Daily Vaccination per million in all columns Show how many people are Vaccinated in different criteria.
• The first step is cleaning the data.
• In data cleaning I cleaned the data with the transform data option present in Power BI because the dataset was not cleaned and included some missing values, so with the help of the duplicates function in Power BI, I cleaned the data and replace the null values with 0 and then started working on it.
• The data set was almost clean and completed.
• Replace the Null values with 0
• There is a total of 8513 rows and 15 columns is present.

Visualization:

In visualization, I took the help of Power BI Desktop software to make graphs and charts here some relevant graphs and charts are attached.

Analysis (Data sheets pertaining to it):

• India is top in people fully vaccinated by country level.
• China is top in total vaccinations by country level.
• In the given dataset is only available for 2021-2022
• Total Highest Daily vaccination is 9223133948 in 2021.
• Total Highest Daily vaccination is 9223133948 in 2021.
• Total Highest vaccination is 704952663700 in China.
• Top 10 countries with fully vaccinated.
• Top 10 Daily vaccination in the countries.
• Top 10 countries with the top 10 vaccine
• In 2021 Total Vaccination is 60.79% completed.
• In 2022 Total Vaccination is 39.2% is completed.
• China, India, the United States, Brazil, Indonesia, Germany, United States, Turkey, France, and England There are the top 10 countries is completed the full Vaccinations.

Insights:

• In conclusion, we can take a look at the final Report for further analysis.
• We can see the top 10 sources.
• Countries by fully vaccination etc.

Recommendations:

• We can analyse the data of the overall world.
• Like this dataset, we can perform operations with various categories, city-wise, or Region wise.
• We can analyse the data with the proper format
• We can collect good datasets for more effective analysis by using charts.

Conclusions:

In conclusion, we can take a look at the final Report for further analysis.

• China, India, the United States, Brazil, Indonesia, Germany, the United States, Turkey, France, and England There are the top 10 countries is completed the full Vaccinations.
• As we can see in the Report the top countries vaccination-wise, Top Country by the vaccination in daily and best top 10 countries with our vaccines. The Top 2 vaccine sources are India, and China.
• In Conclusion, we can take look at the Dashboard for further Analysis.