Project 1 - COVID-19 Vaccinations Trend Analysis

Aim:-

The aim of the project is to analyse COVID-19 vaccination data in detail on daily vaccination, fully vaccinated people and total vaccinations by year and country.

Introduction:-

The COVID-19 outbreak has recently brought significant attention to the healthcare sector, and it has changed the concept of safety in every aspect of our lives. However, vaccination came to light as the only solution that could fight most effectively against coronavirus and probably eradicate it. The main objective of this project is to analyse the data on COVID-19 vaccinations. We can find important insights through the Analysis of COVID-19 vaccination data.

Problem Statement:-

We can find out through analysis :

• How many people are completely vaccinated.
• Total vaccinations by each day, year & country.
• Number of people vaccinated per hundred.
• Daily vaccination data of each country.
• Top 10 countries for fully vaccinated, daily and highly vaccinated.

Methodology:-

Data Importing:

In Power BI Desktop with the help of the Excel workbook option import the xlsx file data which is named country_vaccinations and click the load option.

Data Cleaning:

In this process, I cleaned the data with the option transform data in order to replace the null value from the columns to 0.

Data Interpretation:

In this process, I used diverse analytical methods to review, categorize and summarize data in order to answer the questions. For example, I found out there are a total of 86512 rows and 15 columns using power query and data analysis.

Visualization:

In this visualization, using Power BI Desktop I made a dashboard visualization like bar graphs, slices, cards and charts, and maps and gave a variety of colour and filter patterns in order to understand in the best way possible.

Analysis(Datasheets pertaining to it):-

During analysis found some interesting points:

• The dataset is available from 2020 to 2022
• 0.21% of people were fully vaccinated in the year 2020.
• 79.08% of people were fully vaccinated in the year 2021.
• 20.72% of people were fully vaccinated in the year 2022.

• Total vaccination in map visualization of country.

• The Total Highest Daily vaccination is 9223133948 in 2021.

• Total Highest daily vaccination is 3250342496 in China.

• Top 10 countries with fully vaccinated.

• Top 10 countries with Daily vaccination.

• Top 10 Countries with the most people vaccinated.

Insights:- 

• Here we analysed the top 10 fully vaccinated countries in which India tops the list which indicates that people in the country were showing lots of interest in getting vaccinated.
• Analysed the top 10 daily vaccinated countries in which China tops the list.
• Analysed the top 10 countries where most people are vaccinated with India in the top.
• Analysed the sum of daily vaccination yearly where 2021 highest.
• Analysed the sum of daily vaccinating details, fully vaccinating and vaccinating people 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.
• We can analyse the data of the overall world as well as various categories like citywise or region-wise.

Conclusion:-

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