Project 1 - COVID-19 Vaccinations Trend Analysis

Aim:-
This project aims to analyze data in detail on vaccinated people and fully vaccinated by year and country.

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

Problem Statement:-

In this project, we find out in Different Countries how many people are Vaccinated or fully Vaccinated in 2021 and 2022 and also find out how many people in different countries have completed Daily Vaccinations, Total Vaccination per hundred, People Vaccination per hundred, and Daily vaccinations per Million

Methodology:-

Step 1: Data cleaning
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.

Step 2: Data interpretation
In this data interpretation step, I found out some important information about the data set.
• The data set was almost clear and completed.
• I replaced the null values with 0.
• There is total of 86512 rows and 15 columns.

Step 3: 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):-
In observation found some interesting points that are mentioned below.
• According to data on people fully vaccinated in the year.
• The dataset available is from 2020 to 2021
• Total vaccination by the country in map visualization.
• Total Highest Daily vaccination is 9223133948 in 2021.
• Total Highest vaccination is 704952663700 in China.
• Highest number of vaccinations by the source name is the Ministry of Health is 7.41K.
• Top 10 countries with fully vaccinated:
• Top 10 Daily vaccination in the countries:

Analysis

From the above Visualization find some interesting points that are mentioned below

• China is the number 1 Total Vaccinated people are present
• The Dataset is available for 2021 and 2022.
• The Total of 223 Countries participated in Vaccination.
• 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 Dashboard for further Analysis.
• We can see the top 10 Sources

Recommendations

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

Conclusion

In Conclusion, we can take look at the Dashboard for further Analysis.

• In China and India in these two countries, most people are Vaccinated.
• In 2021 60.79% of people are fully Vaccinated and in 2020 only 39.2 % of people are fully Vaccinated.
• 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.