Vaccination progress and mitigating second-order impacts are both essential to achieving herd immunity and returning to normal from this pandemic. However, such data about smaller countries are often left in the dark.
What it does
This is why we decided to create two interactive dashboards: one showing vaccination progress for every country and another reporting findings from the C2M2 program. In our “Worldwide Vaccination Progress” report, you can hover over a region to see the % of vaccinated people in its population and select them to see more specific details like daily vaccination over time.
Our other dashboard features a bubble chart of all the second-order impacts COVID-19 has had on three cities in Asia. Each bubble shows where the information is taken from, the area of impact, and a brief description of that. They are colored based on their reporting location. When you click on a particular bubble, a chart corresponding to its description will pop up.
How we built it
For our “Worldwide Vaccination Progress” dashboard, we first downloaded the dataset from Gabriel Preda’s “COVID-19 World Vaccination Progress” (Link: https://www.kaggle.com/gpreda/covid-world-vaccination-progress) and Rishav Sharma’s “2021 World Population” (Link: https://www.kaggle.com/gpreda/covid-world-vaccination-progress). We then populated them on Tableau and created a world map at the top of our dashboard. We also implemented data filtering based on the country with the world map, so when the user clicks on one area/selects multiple areas, the data about that area(s) will show up.
As for our other dashboard, we first extracted the data from the 2020-2021 baseline reports from C2M2. We then organized the graphing data based on which second-order impact area it’s describing and the other qualitative data on a general table. We then populated the data and created our visualization using Tableau.
Challenges we ran into
We spent a lot of time organizing our data for the second-order impact dashboard because they are mostly qualitative and separate from one another. In the same focus area, two cities can represent different types of data (i.e. Bangladesh shows a specific % change in income reduction, but Santiago shows the % decrease in GDP, currency, and stock).
Accomplishments that we're proud of
Since this is our first time using Tableau, we’re quite happy with the fact that we’re able to complete our “Vaccination progress” dashboard and create a visualization for the second-order impact under time constraints.
What we learned
Controlling COVID-19 has revealed the weaknesses in the existing health infrastructure, i.e. despite having a lot of PCPs, not many people in Mongolia can afford them. It has also gravely affected tourism, employment, and poverty. Education-wise, challenges in remote learning arose, resulting in loss of income for teachers and youth exposure to risks.
What's next for VaxRate
Given our limited experience with Tableau, we intend on improving our GUI on our “Worldwide Vaccination Progress” report to be easier on the eye as well as creating a more interactive page for our “Second-order impact” dashboard. We are also considering populating more data from C2M2 or other sources which reports on COVID-19 impact on small regions on the aforementioned dashboard.