joshuaolubori / covid-19-vaccination-uk

Breakdown of vaccination rates across the UK

UK Road Accidents and Casualties Tracking Dashboard (2021 - 2022)

Featuring data modeling in Power BI, and Dax

Table of Contents

• Requirement gathering
• Identifying stakeholders
• Understanding raw data
• Data processing
• Data modeling
• Data visualization
• Insights
• Contact

About The Project 🍪

Tracking COVID-19 vaccination data across the UK

Requirement Gathering

Client wants a dashboard to capture a big picture of the COVID-19 vaccination data in the UK

a. Primary KPIs

• Number of people who had not received a vaccination

• Number of people who had received one vaccination only

• Number of people who had received two vaccinations only

• Number of people who had received at least 4 vaccinations

b. Secondary KPIs

• Proportion of people who had received at least 4 vaccinations by age group, ethnicity and religion

Identifying Stakeholders 🧑🏽‍💼

• NHS
• Hospitals
• Ministy of Health

Understanding Raw Data 🥩

The data resides in a Excel file with 4 sheets. The data I need resides in sheet Table_1

Field	Description
Characteristic	The characteristic of a group of individuals
Group	The group to which the individuals belong
Region	The region associated with the group
Age group	The age group to which the individuals belong
Population	The total population of the group
Number of people who had not received a vaccination	The count of individuals who have not received any vaccination
Number of people who had received one vaccination only	The count of individuals who have received one vaccination only
Number of people who had received two vaccinations only	The count of individuals who have received two vaccinations only
Number of people who had received three vaccinations only	The count of individuals who have received three vaccinations only
Number of people who had received at least four vaccinations	The count of individuals who have received four or more vaccinations
Proportion of people who had not received a vaccination (%)	The percentage of individuals who have not received any vaccination
Proportion of people who had not received a vaccination, 95% confidence interval - Lower bound	The lower bound of the confidence interval for the proportion of individuals who have not received any vaccination
Proportion of people who had not received a vaccination, 95% confidence interval - Upper bound	The upper bound of the confidence interval for the proportion of individuals who have not received any vaccination
Proportion of people who had received one vaccination (%)	The percentage of individuals who have received one vaccination only
Proportion of people who had received one vaccination, 95% confidence interval - Lower bound	The lower bound of the confidence interval for the proportion of individuals who have received one vaccination only
Proportion of people who had received one vaccination, 95% confidence interval - Upper bound	The upper bound of the confidence interval for the proportion of individuals who have received one vaccination only
Proportion of people who had received two vaccinations (%)	The percentage of individuals who have received two vaccinations only
Proportion of people who had received two vaccinations, 95% confidence interval - Lower bound	The lower bound of the confidence interval for the proportion of individuals who have received two vaccinations only
Proportion of people who had received two vaccinations, 95% confidence interval - Upper bound	The upper bound of the confidence interval for the proportion of individuals who have received two vaccinations only
Proportion of people who had received three vaccinations (%)	The percentage of individuals who have received three vaccinations only
Proportion of people who had received three vaccinations, 95% confidence interval - Lower bound	The lower bound of the confidence interval for the proportion of individuals who have received three vaccinations only
Proportion of people who had received three vaccinations, 95% confidence interval - Upper bound	The upper bound of the confidence interval for the proportion of individuals who have received three vaccinations only
Proportion of people who had received at least four vaccinations (%)	The percentage of individuals who have received four or more vaccinations
Proportion of people who had received at least four vaccinations, 95% confidence interval - Lower bound	The lower bound of the confidence interval for the proportion of individuals who have received four or more vaccinations
Proportion of people who had received at least four vaccinations, 95% confidence interval - Upper bound	The upper bound of the confidence interval for the proportion of individuals who have received four or more vaccinations
Age-standardised proportion of people who had not received a vaccination (%)	The age-standardized percentage of individuals who have not received any vaccination
Age-standardised proportion of people who had not received a vaccination, 95% confidence interval

Data Processing ⚙️

• The data is in a (relatively) tall format: The Group column collapses fields that should be individual columns into one one column.

• Using the Power Query Pivot Column feature, I pivoted the column into a wider format, bring the total column count to 64.

• Before pivoting, I changed all NA and Errors to zero because the pivoting operation is confused by strings in numeric columns.

• After pivoting, I replaced zeros to nulls and reordered the columns appropriately

Data Visualization 🎨

• Power BI magic!✨ The report pbix file is available in this repo to explore design decisions (The file can only be opened in PowerBI)

Deriving Insights

• The older a person is, the more likely they have received at least 4 vaccinations

• Black Africans have the lowest vaccination rates at about 60%

• Jewish people have the highest vaccination rates

Contact

Edun Joshua Olubori - connect on linkedin - [email protected]

Project Link: Check out the dashboard

(back to top)