Armchair TB Dashboard: One Indicator
The Armchair TB project uses R to retrieve and process data, and Tableau to analyse and present data. This post presents the first of the Tableau dashboards that shows one of eleven indicators as a trend over time comparing it to all regions and countries in EAC, ECOWAS and SADC.
The dashboard is broken in to three components: the visual (blue), compare (green) and filters (orange).
This visual (blue) is created using the filters on the right-hand side (green and orange). The name, ID, description and source of the indicator comes from the World Bank DataBank and updates for every indicator. To change the indicator, select a different indicator from the filter. It is also possible to select region(s), country(ies) and year(s) in the same way.
The green filter changes whether you see the curve as one line, per region or per country. Use the legend at the bottom to highlight regions and countries of interest (click on the coloured square for one, hold down Ctrl + click to select more than one).
Use case: Identify the countries that are driving the largest change in the region that has the largest change in incidence of tuberculosis per 100,000 people.
Use the Indicator filter to select “Incidence of tuberculosis”.
From the first image, the region with the largest change is SADC.
Select SADC from Region (removing EAC and ECOWAS from the analysis), then change the compare to country.
The countries driving the change in SADC are Eswatini, Lesotho, South Africa, Namibia and Botswana. Select those countries (from Country), and choose a different indicator (for example tuberculosis treatment success rate) to see how those countries performed in that indicator.
Wash, rinse and repeat.
Live version
The interactive version of this dashboard is available for use and download on Tableau Public.
The datasource is created using the wbstats R package. The code and data is available on GitHub. A guide for downloading the data is available as a part of the Armchair TB project.
This is part of the Armchair TB Project. Find out more about the project, and related content here.
About the authors:
Dr Puni Mamdoo is a doctor and public health specialist from Durban, South Africa now currently residing in Cape Town. She works in the field of health systems and public health, particularly with TB and HIV programs.
Kirstin Lyon is a visual analytics specialist interested in public health, and is working with a Mozambique team visualising TB and HIV data in Tableau and R. Kirstin is based in Copenhagen, Denmark.