Project 1 - COVID-19 Vaccinations Trend Analysis

Project Report on COVID-19 Analysis

 

 

Table of contents

• Aim
• Introduction
• Problem statement
• Methodology
• Analysis
• Insights
• Recommendations
• Conclusions

 

Aim:-

This project aims to analyze data in detail on vaccinated people and fully vaccinated by 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:-

• In the Country, Vaccination data set the first column is that Country in country column presents different countries.
• In the iso code column containing the iso code for the country. and In the data set contain a date for Vaccination.
• Another column is total Vaccination, People Vaccination, People fully Vaccination, Daily Vaccinated raw, Daily Vaccinations, Total Vaccinations per hundred, people Vaccination per hundred, People fully Vaccinated per Hundred, and Daily Vaccination per million in all columns Show how many people are Vaccinated in different criteria.

 

 

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 Replace values 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: GROUP BY

In this step, I used GROUP BY function and grouped the countries with the row count.

 

Step 4: Visualization

In visualization, I took the help of Power BI Desktop software to make graphs and charts

Below are some relevant graphs and charts attached.

 

Analysis:

From the above Visualizations, we can find some interesting points which are mentioned below

 

• China is the number one country that has Total Vaccinations.
• However, India is the number one country which has people fully vaccinated.
• The Dataset is available for 2021 and 2022.
• The Total of 223 Countries participated in Vaccination.
• And we can also see the people vaccinated by daily basis in all the countries.
• India, United States, China, Brazil, Indonesia, Germany, United States, Turkey, France, and England are the top 10 countries in which people completed the full Vaccinations.

    

      Insights:

    In this, we can take a look at final dashboard for the further analysis.

    We can see top 10 countries and various insights using the graphs above.

 

   

 

 

Recommendations:

• We can also analyze the data of the overall world.
• Like this dataset, we can perform operations with various categories, city-wise, or Region wise.
• We can collect good datasets for more effective analysis by using charts.

 

 

Conclusion:

In Conclusion, we can take look at the Dashboard for further Analysis.

• China and India are the two countries, in which most people are Vaccinated.
• India, United States, China, Brazil, Indonesia, Germany, the United States, Turkey, France, and England There are the top 10 countries is completed the full Vaccinations.