Mozambique TB/HIV Coinfection Overview (Demo)

This demonstration presents a Business Intelligence (BI) Dashboard designed to provide comprehensive insights into TB/HIV coinfection trends and treatment outcomes at a yearly level. Developed in collaboration with the USAID team in Mozambique, this dashboard leverages publicly available data from the data.pepfar.gov website (until its recent decommissioning). The analysis focuses on key PEPFAR indicators, including TB_STAT (TB status of HIV patients), TB_STAT_POS (HIV patients with a positive TB status), and TB_ART (HIV patients on antiretroviral therapy who are also receiving TB treatment).

The original dataset available to the USAID team included additional disaggregates such as age, sex, partner organization, and health facilities, as well as distinctions between new and existing cases. These granular details allow for a more nuanced understanding of the data, enabling targeted interventions and resource allocation. While TB_STAT and TB_STAT_POS were historically reported quarterly, and TB_ART was reported quarterly until 2022 (transitioning to yearly reporting thereafter), this dashboard consolidates the data at a yearly level to provide a high-level overview of trends and performance over time.

Built using Tableau, this dashboard is based on a prototype originally created with the Mozambique USAID team. It serves as an example of how BI tools can transform complex datasets into actionable insights for public health decision-making. By visualizing critical metrics and disaggregated data at a yearly level, the dashboard empowers health program managers, policymakers, and stakeholders to monitor program performance, identify disparities, and develop evidence-based strategies to combat TB/HIV coinfection. This tool is particularly valuable in resource-limited settings, where data-driven decisions can significantly improve patient outcomes and optimize healthcare delivery.