Project 1 - COVID-19 Vaccinations Trend Analysis

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. The countries around the world were forced to shut themselves to others in order to avoid the further spread of the virus and people were stuck inside their houses and faced many issues with their finances, mental health etc., and felt like animals in a cage. An effort was made to find a cure or vaccine by several health organizations to bring a stop to this pandemic.

In later stages of 2020 several experimental vaccines were developed and was administered to humans. The efforts were successful as the vaccines were helpful in reducing the affects the virus and even if people were infected, they were not in any life threating situation and escaped the illness having only minor symptoms.

Many countries later developed their own vaccines and also helped other countries without the resources by providing them with vaccines developed.

Problem Statements –

1. In this project we have analyzed the How people gets vaccination over the time period.
2. We have analyzed the percentage vaccination increase rate from year to year for each country.
3. We have analyzed that how many people gets the full vaccination dose in each country.
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 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.

Insights –

• Here we analyzed the countries how they have good medication facilities during the case of any emergenices like covid-19 pandemic how particular country managed it to overcome from the problem through vaccination to each people of the country. 
• And also analyzed that where vaccination are supplied or provided during pandemic.
• And then analyzed Forecasting of long it would take to vaccinate the complete country forecating analysis.
• 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.