Project 1 - COVID-19 Vaccinations Trend Analysis
Project 1 - COVID-19 Vaccinations Trend Analysis
Aim:-
This Project mainly aims to find out the trend of the vaccinations around the world for the prevention of the Covid 19 pandemic and how much has been achieved so far.
Introduction –
The COVID 19 pandemic caused due to the Corona virus devastated the world by causing several fatalities around the world. This virus originated in Wuhan, China in 2019 and was later spread throughout the world due to human contact in one way or the other. The disease showed symptoms as basic as mild fever and cold but also caused life threatening symptoms like breathing problems caused by damage to the lungs. As this virus was new to the world and there was no vaccine or cure to it at the initial period there were several deaths around the world. Since the start of the COVID-19 outbreak, WHO has worked with countries and areas in Different regions on public health measures to slow or stop the spread of the virus.Safe and effective vaccines are an important tool, in combination with other measures, to protect people against COVID-19, save lives and reduce widescale social disruption.The main objective of this project to analyze Covid – 19 Vaccination data and find out some important insights.
Problem Statement :-
1) In this project we have analyzed the fully vaccinated countries
2) We have analyzed the vaccinated countries
3) We have analyzed the daily vaccinating countries
4) We have analyzed the total number of daily vaccinations, people who have fully vaccinated, people who is vaccinated
5) We have analyzed year wise daily vaccinating details, fully vaccinated people details, vaccinated people details
6) We have analyzed the country wise vaccines and iso_code details.
Methodology –
Step 1 –
Data Importing –
In power BI desktop with the help of the get data option import the CSV data which is named as country_vaccinations and clicked load option.
Step 2 –
Data Cleaning –
After loading the data and after analyzing the data | understood that there are 86512 rows and 15 columns. And in that some of the columns contained null values I have replaced the null values by 0 with the use of replace functions and started working on the data.
Step 3 –
Visualizations –
In visualization part with the help of power BI desktop software I have used different kinds of charts, graphs, cards and table to display the data in the format which will be easy to understand.
Analysis –
In the analysis part first | have analyzed the fully vaccinated countries by using Clusterd column chart and have used the slicer option to see the one particular country with their daily vaccination count and result obtained as below.
In the second analysis we have analyzed the total vaccinations by countries with the help of Clusterd column chart and used slicer option to see the count of each countries. And create summary to show the information of chart.
In the third analysis we have analyzed the top 5 country with daily vaccinations with the help of donut 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.
In the fourth analysis we have analyzed the sum of total vaccinations by year 2020,2021 and 2022 in the all country with the help of donut chart . below 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.
below 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 below chart I have used table to understand the vaccine details, iso_code and source name details country wise.
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 5 vaccinated countries here also India tops the list.
And then analyzed top 5 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. 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.