Project 1 - COVID-19 Vaccinations Trend Analysis

Aim:

Aim for this project is to analysis the provided data regarding the vaccination details of 222 countries in terms of people vaccinated by date, people fully vaccinated by country, daily vaccination by country and total vaccination by country.

Introduction: -

Covid 19 (Corona Virus) was found in the year 2019 in China. This virus created severe impact throughout the world. Many vaccines were found in short duration for the Covid 19, which brings the severity of the impact in human. With the data provided, we will analysis to understand the trend in vaccination and some facts regarding vaccination around the world.

Problem Statement: -

• To find the number of people vaccinated by date.
• To find out fully vaccinated people by country.
• To find out daily vaccination by country and.
• To find out total vaccination by country.

Methodology: -

Step 1. Data Importing:

        In power Bi Desktop with the help of the get data option imported CSV data which is named as country vaccinations and clicked load option.

Step 2: Data Cleaning:

        After loading the data and after analysing 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: Visualization:

      In visualization, I took the help of Power BI Desktop software to make graphs and charts here some relevant graphs and charts are attached.

Analysis:

    In observation found some interesting points that are mentioned below.

• According to data on people fully vaccinated in the year.
• The dataset available is from 2020 to 2022.
• Total vaccination by the country in map visualization.
• Total Highest Daily vaccination is 2088398023 in 2022
• Total Highest vaccination is 704952663700 in China.
• Highest number of vaccinations by the source name is the Ministry of Health is 7.41K.
• Top 10 countries with people fully vaccinated.
• Top 5 Daily vaccination in the countries.
• Top 10 Countries where most people are vaccinated.

Insights:

• In conclusion, we can look at the final Report for further analysis.
• We can see the top 10 sources.
• Countries by fully vaccination etc.

Recommendations:

• For the Purpose of getting best overview vaccination status, we should have accurate data.
• Vaccination is highly recommended to reduce impact on human.

Conclusion:

    Upon analysing the provided the data we come to know total people vaccinated by date, people fully vaccinated by country, daily vaccination by country and total vaccination by country.