Building an AI-Powered COVID-19 Vaccination Dashboard in Tableau

Introduction

The COVID-19 pandemic has brought unprecedented challenges for public health, with data analytics playing a crucial role in tracking the virus‘ spread and informing response efforts. With the development and rollout of multiple effective vaccines, the focus has shifted to efficiently distributing doses and monitoring vaccination progress worldwide.

Data visualization tools like Tableau offer powerful capabilities to make sense of the vast, fast-changing vaccination datasets and surface insights to guide decision-making. Tableau‘s ease of use, rich feature set, and AI/ML integrations make it well-suited for building comprehensive COVID-19 vaccination dashboards.

In this post, we‘ll walk through how data scientists and analysts can use Tableau to visualize the latest vaccination data, apply advanced analytics, and share interactive dashboards. We‘ll also explore how AI and machine learning can enhance these efforts and consider best practices for working with sensitive public health data.

Why Tableau for COVID-19 Vaccination Analysis?

Tableau has emerged as a leading platform for COVID-19 response, used by major public health agencies, research institutions, and businesses worldwide to visualize and track pandemic data. Some key advantages of Tableau for this use case include:

• Broad connectivity to data sources (spreadsheets, databases, cloud platforms, etc.)
• Intuitive drag-and-drop interface for rapidly building visualizations
• Rich library of charts, graphs, maps and dashboards
• Powerful calculation engine and built-in statistical functions
• Interactive dashboards and stories for data exploration
• Robust security and governance for sensitive data
• AI/ML extensions for advanced analytics
• Flexible sharing and embedding of visualizations

As vaccination campaigns generate ever-increasing amounts of data, Tableau provides the tools to quickly ingest, analyze and visualize this information to extract actionable insights. The platform‘s expanding AI capabilities further enable intelligent analysis at scale.

The COVID-19 Vaccination Dataset

Our World in Data, a project of the Global Change Data Lab, maintains a comprehensive global dataset on COVID-19 vaccinations compiled from official sources. The dataset contains the following fields relevant to our dashboard:

• location: name of the country (or region within a country)
• date: date of the observation
• total_vaccinations: total number of doses administered (including first and second doses)
• people_vaccinated: total number of people who received at least one vaccine dose
• people_fully_vaccinated: total number of people who received all doses prescribed by the initial vaccination protocol
• daily_vaccinations: number of doses administered each day (7-day rolling average)
• vaccines: names of the vaccines used in the country

The data is updated daily and includes country-level data for over 200 countries and territories. As of March 2023, the dataset contains over 100,000 rows and growing.

Some key worldwide totals as of March 10, 2023:

• Total vaccine doses administered: 13.25 billion
• Number of people vaccinated: 5.47 billion (69.6% of global population)
• Number of people fully vaccinated: 5.01 billion (63.7% of global population)

While the dataset is largely complete, some challenges and limitations to note:

• Missing data for certain countries and dates
• Potential reporting delays or backlogs
• Inconsistent reporting cadences between countries
• Differences in how countries define metrics like "fully vaccinated"
• Lack of detailed demographic breakdowns for most countries

Tableau‘s data shaping and blending capabilities can help address many of these issues to create a more consistent, analysis-ready dataset.

Building the Visualization in Tableau

With the data in hand, we can begin building our interactive dashboard in Tableau. The general steps include:

1. Connect to the data source (CSV file, database, etc.)
2. Drag dimensions and measures to the canvas to create charts and graphs
3. Refine and format the visualizations
4. Arrange visualizations on a dashboard and add interactive controls
5. Publish and share the dashboard

Let‘s walk through some examples of key visualizations to include.

Vaccination Progress by Country

To compare vaccination progress across countries, we can leverage Tableau‘s built-in mapping capabilities. After connecting to the data:

1. Double-click the Country dimension to create a map view.
2. Drag the People Fully Vaccinated measure to the Color shelf to shade countries by total fully vaccinated.
3. Add People Vaccinated to the Size shelf to scale the country circles accordingly.
4. Drag Percent Population Fully Vaccinated to the Label shelf and format the label.

The resulting view allows us to quickly identify leaders and laggards in vaccination progress. Hovering over a country provides additional details.

Some observations:

• Countries shaded darker green (UAE, Chile, Portugal, etc.) have fully vaccinated over 80% of their population.
• Those shaded lighter yellow (many countries in Africa) have reached less than 20%.
• Significant inequities between high- and low-income countries are apparent.

Vaccinations Over Time

To visualize the rate of vaccinations over time:

1. Drag the Date dimension to the Columns shelf.
2. Drag Daily Vaccinations to the Rows shelf.
3. Change the mark type to Line.
4. Add SUM(Total Vaccinations) to the Rows shelf and change the mark type to Area to show total doses over time.
5. Adjust the axis range and formatting as needed.

This view shows daily doses administered globally (7-day rolling average) as well as the cumulative total. Key callouts:

• Daily doses peaked at over 44 million/day in June 2021 but have since declined to ~15-20 million/day in early 2023.
• The total doses administered curve begins rising exponentially in January 2021 and continues to grow steadily.
• There are noticeable dips in daily doses in December of each year, likely due to holidays and reporting lags.

Vaccination Rates by Region

To compare vaccination rates across regions, we can use a combination of a map and a bar chart:

1. Create a new Geographic Role for the Country field and assign countries to regions.
2. Drag Percent Population Fully Vaccinated to the Rows shelf and Region to the Columns shelf.
3. Change the mark type to Bar.
4. Drag Region to Color on the Marks shelf to color the bars by region.
5. Create a new map view and drag Region to Color to shade the regions by % fully vaccinated.
6. Arrange the two views vertically on a dashboard.

The dashboard shows the stark differences in vaccination rates between regions:

• South America leads with over 70% fully vaccinated, followed by Europe and North America over 60%.
• Africa lags significantly behind at just 20.2% fully vaccinated.
• Asia and Oceania fall in the middle around 59-64%.

Vaccine Manufacturers

To see the breakout of doses administered by vaccine manufacturer:

1. Drag Vaccine to the Columns shelf and SUM(Total Vaccinations) to Rows.
2. Change the mark type to Bar.
3. Add SUM(Total Vaccinations) as a Quick Table Calculation to show the percent of total for each vaccine.
4. Create a new pie chart view with Vaccine and SUM(Total Vaccinations).
5. Combine the bar chart and pie chart on a dashboard with a caption.

Key insights:

• Oxford/AstraZeneca, Pfizer/BioNTech, Sinovac, and Moderna make up the top 4 vaccines with over 70% of total doses.
• Over 40 different vaccines are in use worldwide, with major differences between countries and regions.
• China‘s CanSino and Sinopharm vaccines are prevalent in Asia, Novavax in Australia, J&J in African countries.

Applying Advanced Analytics

Tableau offers multiple options to incorporate more advanced analytics into our COVID-19 vaccination dashboard.

Forecasting

Tableau‘s built-in forecasting feature uses exponential smoothing to predict future values:

1. In the Vaccinations Over Time view, drag the Forecast value to the Columns shelf.
2. Set the forecast length to 1 month (or desired period).
3. Right-click the forecast line and "Show Forecast Results" to display predicted values.

The forecast shows vaccinations continuing to increase steadily worldwide, surpassing 15 billion total doses by May 2023. However, the prediction intervals widen significantly over time, indicating growing uncertainty in the long-term trajectory.

Clustering

Tableau‘s clustering feature can group countries based on similarities in their vaccination data:

1. Select multiple measures to cluster on (e.g. Total Vaccinations, % Fully Vaccinated, etc.)
2. Drag the Cluster dimension to the Detail shelf on the Marks card.
3. Specify the number of clusters desired (e.g. 4) and the clustering method.
4. Assign colors to each cluster and analyze the results.

Clustering reveals some interesting groupings, such as:

• Countries that have administered a high number of doses and fully vaccinated most of their population (e.g. China, UK, UAE)
• Those with very low vaccination rates across all metrics (many countries in sub-Saharan Africa)
• Outliers like Israel and Mongolia that have extremely high rates compared to their regions

Machine Learning Extensions

Tableau integrates with multiple platforms like Python, R, and MATLAB to execute machine learning workflows:

1. Author the machine learning model outside Tableau.
2. Connect to the model file in Tableau.
3. Configure input/output parameters and specify fields to predict.
4. View predictions in Tableau and embed them in calculations.

Some potential applications of ML for our vaccination data:

• Predicting future vaccine uptake based on demographics, mobility, policies, etc.
• Identifying populations at highest risk for low vaccination rates
• Optimizing vaccine distribution and supply chains
• Forecasting adverse events and public sentiment

Tableau‘s TabPy library enables direct integration with Python for more complex data science workflows. Tableau Prep can also help automate the data cleaning and shaping process using fuzzy clustering, pivot/join, and other AI-powered tools.

Conclusion

This post demonstrates how Tableau can be leveraged to create insightful, interactive visualizations of global COVID-19 vaccination progress. By ingesting the latest data, rapidly building a variety of charts and dashboards, and applying advanced analytics, we surfaced important insights on the state of the worldwide vaccination campaign.

Incorporating AI/ML techniques like predictive modeling and clustering further enhance the dashboard to address key questions like:

• Which countries are likely to face vaccine shortages in the coming months?
• What are the key drivers of vaccine hesitancy?
• How can we optimize allocation of vaccines to high-risk populations?
• What is the projected impact of vaccinations on future case rates and deaths?

As more granular data becomes available and vaccination campaigns continue, these intelligent analytics will become increasingly vital for informing public health policy and decision making.

Some key takeaways and best practices:

• Leverage Tableau‘s rich library of visualizations and dashboarding capabilities to rapidly explore the data
• Choose appropriate chart types for each metric based on data types and analytical goals
• Utilize built-in analytical functions like forecasting, clustering, and calculation fields
• Incorporate advanced statistics and machine learning via external tools and integrations
• Design interactive, user-friendly dashboards for collaborating with stakeholders
• Establish data governance processes to ensure security and privacy of sensitive information
• Keep dashboards updated with the latest available data to guide decisions

While the Tableau visualizations surfaced important descriptive insights, a deeper understanding of the complex dynamics driving vaccination rates requires advanced modeling and AI/ML techniques. By operationalizing these intelligent workflows and building them into our Tableau dashboards, we can provide health authorities and policymakers with predictive, prescriptive decision support to help bring an end to this devastating pandemic.