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:-
• We can find out how many people are completely vaccinated.
• Total vaccinations by each year and then by country. In this analysis, we can see the number of people vaccinated per hundred.

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 the analysis part first | have analyzed the top 10 fully vaccinated countries by using area chart and have used the filter option to find the top countries and the result obtained as below,

From the below image we can able to come to know that India is the top country in terms full vaccination with 116 billon , followed by united states of America and china with 67 billion and 35 billion respectively.

In the second analysis we have analyzed the top 10 vaccinated countries with the help of pie chart and used filter option to find the top countries and with that we came to know that India is the top country with more number of vaccinated peoples followed by United States of America and Brazil.

In the third analysis we have analyzed the top 10 country with daily vaccinations with the help of pie chart and used filter option to find the top country with daily vaccinations and with that we came to know that China is the top country with more number of vaccinations followed by India and United States of America.

From the above images we have came to know about the statics of daily vaccination, people who have fully vaccinated and people who is vaccinated and I used cards for this to display the value.

Above image have shown that daily vaccinating details year wise and here we can conclude that 2021 is a year which having maximum daily vaccinating details and I have used bar chart.

Above image have shown that fully vaccinating details year wise and here we can conclude that 2021 is a year which is having maximum number fully vaccinated peoples and I have used Line chart.

From the above chart I have used table to understand the vaccine details and iso_code details country wise.

From the above images we have analyzed the daily vaccinations per million, people who have fully vaccinated per hundred, people who have vaccinated per hundred, total vaccinations per hundred.

From the above image we came to know about people who have vaccinated per hundred, people who have fully vaccinated per hundred, total vaccinated per hundred and we came. to know about that 2021 was the peak year in all the 3 cases.

Insights-

• Here we analyzed the top 10 fully vaccinated countries in which India tops the list which indicates that people in the country where showing lots of interests to get vaccinated.
• And also analyzed top 10 vaccinated countries here also India tops the list.
• And then analyzed top 10 daily vaccinating countries and here China tops the list.
• And also we analyse the sum of daily vaccinating details, fully vaccinating and vaccinating people details.
• And our year wise analyse shows that 2021 was the peak year for every vaccination details.

Recommendations-

• We should collect day to day reports and we should update our records daily to get more accurate details.
• So that we can move forward with more vaccination to the right country which needs the most.

Conclusions-

In this dataset we came to know that the vaccination process in every country was going in good pace that indicates we can have control of this disease very soon all over the world.