Project 1 - COVID-19 Vaccinations Trend Analysis

Authored by:

USING POWER BI

AIM:

To Analyze Data In Detail On Vaccinated And Fully Vaccinated People By Year And Country.

INTRODUCTION:

The Main Objective Of This Project Is To Analyze The Data On, COVID-19 Vaccinations. We Can Find Out Some Important Insights By Analyzing The Data.

PROBLEM STATEMENT:

• In Order To Know How Many People Are Full Vaccinated By The Initial Protocol?
• To Know The Population Which Has Received At Least One Dose Of The Vaccine?
• The Different Vaccines Used and Their Availability to Different Countries.

METHODOLOGY:

The Dataset Used Is Available For The Public And Which Is Collected From The Respective Health Departments Of The Countries And From The WHO. The Dataset Contains Information For The Period December 2020 To March 2022.

Step 1: Data Exploration:

In Order To Take Any Necessary Steps We Must Understand The Data We Have, Which Is Data Exploration And Based On Our Understanding We Can Go Ahead With The Appropriate Data Cleaning Steps Required.

Step 2: Data Importing:

To Import The Data Into Power BI, Let’s Start With The Get Data Option Under The Home Tab. As This Is A CSV File, Select The Text/CSV Option From The Drop-Down List And The Select The File Named. After Selecting The File, Data Will Be Displayed Click On Load And Save Data.

Step 3: Data Cleaning:

I Have Used Power BI Tool To Clean And Transform The Data As Per My Understanding And I Have Replaced Values, Grouped The Data And Created A New Table Where It Seemed Fit.

Step 4: Data Visualization

I Have Used Power BI Tool To Visualize The Data Available To Gain Meaningful Insights And Better Understand The Dataset. I Have Used Different Visualizations Like Bar Graphs, Line Graphs Which Are Available In The Tool.

ANALYSIS:

The Dataset Contains the Following Columns

Country – The Name Of The Countries (223 Countries In Total)

ISO Code – Code Initials For The Countries

Date – The Date, Month And Year Of The Data Collected

Total Vaccinations – The Total Number Of Vaccinations Administered Which Is Nothing But The Sum Of The Doses Given On Any Particular Date To The Total Vaccinations Of The Previous Day.

People Vaccinated – The Total Number Of People Who Received At Least One Dose Of Vaccine. This Is Also An Aggregated Column Meaning It Is The Sum Of Total Of The Previous Day To The Vaccinations Of The Present Day.

People Fully Vaccinated – The Aggregated Value Of People Who Received The Desired Number Of Doses (Min 2 Doses And 1 Booster Dose May Or May Not Be Included).

Daily Vaccinations Raw – Gives The Raw Data Collected On Vaccinations

Daily Vaccinations – The Vaccinations Administered On Any Particular Day

Total Vaccinations Per 100 – The Total Vaccinations Administered Per 100 People Which Also An Aggregated Data

People Vaccinated Per 100 – The Number Of People Who Received At Least One Dose Of Vaccine, Taking Into Account For Every 100 People

People Fully Vaccinated Per 100 – For Every 100 People How Many Are Fully Vaccinated (Received Min 2 Doses)

Daily Vaccinations Per Million – Gives The Number Of Vaccinations Administered For Every Million Population On Any Particular Day.

Vaccines – Gives the Different Vaccines and Their Manufacturers Separated By Commas.

Source Name – Gives The Name Of The Source From Which Data Is Provided.

Source Website – Gives The Website Link From Where The Data Was Obtained.

Now We Know That What The Data Set Contains To Analysis The Data.

CARD VISUALIZATION:

The Card Visualization Has Been Used To Show Different Numeric Values Like Total Countries, Vaccination Details And Number Of People Vaccinated.

In This We Can See That There Are 223 Countries Available In The Given Data Set.

There Are 549 Billion Peoples Are Fully Vaccinated All Over The World.

Total Vaccinations Available Is More Than 2 Trillion.

There Are 731 Billion Peoples Have Been Vaccinated At Least 1st Dose Or 2nd Dose.

The Slicer Is Added With Year And The Month. It Is Used To Know How The Vaccine Process Is Going On.

LINE GRAPH:

A Line Graph Is Used To Represent To Daily Vaccinations Versus The Date Of The Record.

In This Line Graph We Can See The People Vaccinated Date Based On Date.

The Vaccinated Ratio Is Gradually Increased From Jan 2021 And It Reaches High Of 44M On Jun 2021.

The Graph Has Seen Variations In Further Months Where It Has Dropped To 23 Million Doses In A Day And Again Seen A Raise Of 41 Million Doses. Still Around 15 Million Doses Were Administered At The End Of March 2022.

FUNNEL CHART:

A Funnel Chart Has Been Plotted To Represent The People Fully Vaccinated And The People Vaccinated At Least One Dose.

From The Funnel Chart We Can See That 37% Of Peoples Are Vaccinated At Least One Dose And 27.4% Of Peoples Are Fully Vaccinated In The World.

COLUMN CHART:

Through The Column Chart We Have Analysis The Top 10 Country In Which Peoples Are Fully Vaccinated.

The Country At The Top Level Of Daily Vaccination Is China And India.

MAP VISUALIZATION:

Map Visualization Is Also Shown Which Gives The Population Fully Vaccinated In Different Countries And Are Differentiated Based On The Color Gradient.

MULTIROW CARD:

Multirow Card Visualization Is Used To Get The Country Wise Individual Data With Refer To The Sum Of Total Vaccinations, Sum Of People Fully Vaccinated And Sum Of People Vaccinated At least One Dose.

ANALYSIS:

The Final Report Provides Valuable Insights Into The Vaccination Efforts Around The World. By Analyzing The Data, It Is Possible To Identify The Top 10 Countries With The Highest Rates Of Fully Vaccinated Individuals.

The High Rate of Fully Vaccinated Show That the People Are Interested In Destroy the Deadly Virus from the World.

By Using The Insights Gained From This Analysis, It Is Possible To Make Informed Decisions And Take Effective Action To Address The Challenges Posed By COVID-19. So, We Can Conclude That The Analysis Of The Data Has Been A Valuable And Informative Process, And It Is Hoped That The Insights Gained Will Be Useful In The Ongoing Efforts To Combat The Pandemic.

RECOMMENDATIONS:

We Can Perform Operations With Various Categories.

In Order To Improve The Accuracy And Usefulness Of The Data Analysis, It Is Important To Ensure That The Datasets Used Are Of High Quality And Are Properly Cleaned And Organized.

The Developed And Economically Strong Countries Should Help Out The Under Developed And Developing Countries To Improve The Vaccination Of The People.

At Least 90% Of The Population Should Be Vaccinated At Least Once To Avoid Further Problems.

CONCLUSIONS:

The Result Of This Analysis Reveal That The Trend Of COVID-19 Vaccinations Is Increasing In Many Countries. There Is Evidence That The Number Of People Receiving Their First Dose Of The Vaccine Is Steadily Increasing, While The Percentage Of People Receiving Their Second Dose Has Also Been Steadily Increasing. Additionally The Data Shows That The Rate Of Vaccination Varies Across Countries With Some Countries Having Higher Rates Than Others. In General, It Appears That The Rollout Of The Vaccine Is Progressing Well And That More People Are Becoming Vaccinated On A Daily Basis.