1. Abstract

The COVID-19 pandemic significantly impacted global health systems, economies, and societies. Vaccination programs were implemented worldwide to control the spread of the virus and reduce its effects. Analysing vaccination data helps governments, researchers, and policymakers understand vaccination trends, distribution patterns, and global progress in combating the pandemic.

This project focuses on analysing the COVID-19 vaccination dataset sourced from GitHub and provided by the World Health Organization (WHO). The dataset includes important information such as country-wise vaccination counts, daily vaccination rates, total vaccinations, and vaccine manufacturers.

Using Power BI, the dataset is first imported and cleaned using the Power Query Editor. Data preprocessing includes identifying missing values, replacing null values with appropriate values, verifying data types, and removing unnecessary columns. After cleaning the dataset, interactive visualizations and dashboards are created to analyse vaccination trends across different countries and time periods.

The Power BI dashboard helps in understanding vaccination progress, comparing countries based on vaccination coverage, and analysing vaccination growth over time. This project demonstrates the use of business intelligence tools for analysing real-world health datasets and generating meaningful insights.

2.Objectives

The main objectives of this project are:

1. To analyse global COVID-19 vaccination data.
2. To understand the structure and characteristics of real-world health datasets.
3. To perform data cleaning and preprocessing using Power Query Editor.
4. To identify missing values and replace them appropriately.
5. To analyse vaccination trends across countries.
6. To visualize vaccination progress using Power BI dashboards.
7. To study the relationship between vaccination rates and time.
8. To create interactive reports for better understanding of global vaccination efforts.

3. Existing System

Traditional analysis of vaccination data relies on:

1. Static reports published by health organizations
2. Spreadsheet-based analysis using Excel
3. Manual interpretation of statistical data
4. Limited graphical representation of vaccination statistics

Limitations of Existing Systems

1. Difficulty in analysing large vaccination datasets.
2. Lack of interactive visualization tools.
3. Time-consuming manual data processing.
4. Limited ability to compare vaccination data across multiple countries.
5. Static reports that cannot dynamically explore data patterns.

These limitations highlight the need for modern business intelligence tools like Power BI for better data analysis and visualization.

4. Proposed System

The proposed system uses Power BI to analyse and visualize COVID-19 vaccination data.

In this system:

1. COVID-19 vaccination datasets are collected from GitHub sources.
2. Data is imported into Power BI for analysis.
3. Power Query Editor is used to clean and preprocess the data.
4. Missing values are identified and replaced with appropriate values.
5. Data types are verified to ensure consistency.
6. Multiple visualizations are created to analyse vaccination trends.
7. Interactive dashboards allow users to explore vaccination statistics by country and time.

This system provides a clear and interactive platform for understanding global vaccination progress.

5. Implementation Procedure

The implementation of this project involves the following steps:

Step 1: Data Collection

The COVID-19 vaccination dataset is collected from GitHub and is sourced by the World Health Organization (WHO). The dataset contains country-wise vaccination information and vaccine manufacturer details.

 Step 2: Data Loading

The dataset is imported into Power BI Desktop.

The Transform Data option is selected to open the Power Query Editor.

Step 3: Data Understanding

The dataset contains information such as:

1. Country name
2. Date of vaccination record
3. Total vaccinations
4. Number of people vaccinated
5. Number of people fully vaccinated
6. Daily vaccinations
7. Vaccination rates per million people
8. Vaccine manufacturers

The dataset is examined to understand the structure and meaning of each variable.

Step 4: Data Cleaning

Data cleaning includes the following tasks:

1. Checking for missing or null values
2. Replacing null values with zero
3. Removing unnecessary columns such as ISO codes if not required
4. Ensuring correct data types for each column

Step 5: Data Transformation

In this stage:

1. Columns are formatted properly
2. Decimal values are converted to whole numbers where necessary
3. Data inconsistencies are corrected

Step 6: Data Visualization

Various visualizations are created using Power BI, including:

1. Line charts showing vaccination trends over time
2. Bar charts comparing vaccination numbers across countries
3. Pie charts representing vaccine distribution
4. Tables and charts showing daily vaccination statistics

Step 7: Dashboard Development

An interactive Power BI dashboard is created which includes:

1. Filters and slicers for country selection
2. Time-series visualizations of vaccination growth
3. Comparison of vaccination progress across different countries

This dashboard helps users analyse the global vaccination campaign effectively.

6. Software Requirements

The software tools used in this project include:

1. Power BI Desktop – Data visualization and dashboard creation
2. Power Query Editor – Data cleaning and preprocessing
3. Microsoft Excel / CSV files – Dataset format
4. Windows Operating System

7. Hardware Requirements

Minimum Hardware Requirements:

1. Processor: Intel i3 or higher
2. RAM: 4 GB or higher (8 GB recommended)
3. Storage: 256 GB or higher
4. Laptop or Desktop Computer
5. Advantages of the Project
6. Helps analyse global COVID-19 vaccination progress.
7. Provides interactive dashboards for better data exploration.
8. Enables comparison of vaccination statistics between countries.
9. Simplifies large datasets through clear visualizations.
10. Supports data-driven decision making in healthcare analysis.
11. Demonstrates practical application of Power BI in public health analytics.
12. Helps understand trends and patterns in vaccination programs.