Project 1 - COVID-19 Vaccinations Trend Analysis

COVID-19 Vaccinations Trend Analysis

Aim:

This Project mainly aims to analyze the vaccinated people, fully vaccinated people and daily vaccinating people details according to year and date.

Introduction:

The main purpose of the project is to analyze various kinds of covid-19 vaccination details so that we can able to understand different statistics about vaccination throughout the world and we can derive some recommendations, Insights and we can bring out conclusion.

Problem Statements:

• In this project we have analyzed the top 10 fully vaccinated countries
• We have analyzed the top 5 vaccinated countries
• We have analyzed the top 5 daily vaccinating countries
• We have analyzed the total number of daily vaccinations, people who have fully vaccinated, people who is vaccinated
• We have analyzed year wise daily vaccinating details, fully vaccinated people details, vaccinated people details
• 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 I 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 I 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 with116 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 5 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 5 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 column chart

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

From the above chart we have used table to understand the vaccine details and iso_code details by 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 I 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 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.