COVID-19 Vaccination Analysis
1. Problem Statement:
Analysis of COVID-19 Vaccination Data
You are tasked with analysing global COVID-19 vaccination data to provide
insights into vaccination rates, distribution, and demographic coverage. Your
goal is to identify trends, disparities, and progress in the global vaccination
efforts.
2 . Dataset Details
Dataset Name: COVID-19 Vaccination Data
Download Link: [COVID-19 Vaccination Data]
https://github.com/owid/covid-19-ata/blob/master/public/data/vaccinations/
vaccinations.csv
3. Description:
The dataset contains records of COVID-19 vaccination efforts across various
countries. It includes information on vaccination dates, total vaccinations,
people vaccinated, people fully vaccinated, daily vaccinations, and
vaccination rates.
4. Tasks to Do
1. Data Preparation
- Load the dataset into Tableau.
- Clean the data by removing any null values and ensuring data types are
correctly assigned.
2. Vaccination Progress Analysis
- Create a summary dashboard that provides an overview of total
vaccinations, people vaccinated, and people fully vaccinated globally.
- Visualize vaccination trends over time (daily/monthly).
3. Country-wise Vaccination Analysis
- Analyze the vaccination rates across different countries.
- Identify top and bottom countries based on vaccination coverage.
4. Demographic Coverage Analysis
- Evaluate the distribution of vaccinations among different age groups and
demographics (if available).
- Compare vaccination rates between different population segments.
5. Vaccination Distribution Analysis
- Analyze the distribution of vaccine types (if available).
- Compare the efficacy and distribution of different vaccine types.
5. Feature-wise Charts to Create
1. Global Vaccination Trends Over Time
- Chart Type: Line Chart
- Details: Plot daily/monthly vaccination trends to identify the pace and
progress of vaccination efforts.
2. Country-wise Vaccination Rates
- Chart Type: Map
- Details: Visualize the vaccination rates across different countries to
identify regions with high and low coverage.
3. Top and Bottom Countries by Vaccination Coverage
- Chart Type: Bar Chart
- Details: Highlight the top 10 and bottom 10 countries based on
vaccination rates to recognize disparities.
4. Demographic Coverage (if data available)
- Chart Type: Bar Chart
- Details: Compare vaccination rates among different age groups and
demographics.
5. Vaccination Distribution by Vaccine Type (if data available)
- Chart Type: Pie Chart/Bar Chart
- Details: Analyze the distribution of different vaccine types and their
coverage.
6. Step-by-Step Guide
1. Load the Dataset:
- Open Tableau and connect to the COVID-19 Vaccination dataset.
2. Create Global Vaccination Trends Over Time:
- Drag Date to Columns and Total Vaccinations, People Vaccinated, and
People Fully Vaccinated to Rows.
- Change the chart type to Line Chart.
3. Create Country-wise Vaccination Rates:
- Drag Country to Rows.
- Drag Total Vaccinations to the Color and Size marks.
- Change the chart type to Map.
4. Top and Bottom Countries by Vaccination Coverage:
- Drag Country to Rows.
- Drag Total Vaccinations to Columns.
- Sort the bar chart in descending order of total vaccinations.
- Create a calculated field to identify top and bottom countries.
5. Demographic Coverage (if available):
- Drag Age Group or Demographic to Columns.
- Drag Vaccination Rates to Rows.
- Change the chart type to Bar Chart.
6. Vaccination Distribution by Vaccine Type (if available):
- Drag Vaccine Type to Columns.
- Drag Total Vaccinations to Rows.
- Change the chart type to Pie Chart or Bar Chart.
7. Final Steps
- Arrange the charts in a dashboard layout for easy comparison and analysis.
- Add filters and interactive elements to allow users to explore the data.
- Review the dashboard for accuracy and clarity.
