BUILDING THE PROGRAMME NATIONAL DE LUTTE CONTRE LE SIDA (PNLS)’s CAPABILITIES TO MAKE BETTER DECISIONS THROUGH DATA AND TOOLS
The DCDJ Fellowship provides a dual benefit for both Côte d’Ivoire host organizations and Data Fellows themselves. At the Programme National de Lutte Contre le Sida (PNLS), DCDJ Data Fellow Flore Koffi identified a need for faster visualization of important HIV/AIDS treatment data, and built a new dashboard that enables PNLS staff to access, analyze, and use information for the fight against HIV/AIDS.
The Des Chiffres et Des Jeunes (DCDJ) Data Fellowship is a flagship DCDJ program that places technically-trained Ivorian youth into organizations where they encourage and increase the degree to which data is used for decision making. It is a unique opportunity for young people to sharpen data skills while contributing to a strengthened data ecosystem and to data-related resource availability in Côte d’Ivoire. DCDJ is a program led by Development Gateway and funded by the Data Collaboratives for Local Impact (DCLI) program.
The DCDJ Data Fellowship equips Côte d’Ivoire with the human and intellectual capital it needs to promote, maintain, and succeed in sustainable development. Building young peoples’ skills to strategically catalyze sustainable change, DCDJ leverages local capacity to improve data access, sharing, and availability.
Côte d’Ivoire’s Programme National de Lutte Contre le Sida (PNLS) is a government agency that leads the response against HIV/AIDS in Cote d’Ivoire. At PNLS, workers had access to data, but analyzing that data was a challenge. Until recently, PNLS stored important data used to track progress in controlling the HIV/AIDS epidemic in separate Excel sheets. Each time updates were made in one sheet, they had to be manually updated across several others.
Flore Koffi, a DCDJ Data Fellow assigned to PNLS in 2019, observed that individually editing Excel sheets was insufficient to keep up with PNLS’s data needs. She noted, “When someone updated one spreadsheet, the rest of the staff’s spreadsheets would not get updated – it was really difficult for everyone to access and analyze the data.” PNLS staff struggled to keep data current across the organization. Despite a few previous attempts at introducing a new solution, no tool had managed to replace the Excel system.
PNLS also lacked the tools and experienced staff to add visualization dimensions and capabilities to its analysis. Effectively preparing and presenting information was a challenge. For example, the department struggled with gathering accurate, impactful data to prepare regular presentations on disease trends and intervention performance.
During her placement at PNLS, Flore identified the opportunity to enhance the use of the data stored on Excel sheets. She also recognized that any tool that would replace the Excel system needed to be sustainable, systematic, and useful for healthcare workers’ needs. To create a centralized source of regularly updated, real-time data, Flore collected and cleaned data, then built a new dashboard using her programming skills from the Data Fellowship. It includes data storage, analysis, and visualization of locations where HIV screening and prevention measures are already occurring, and where they are needed. This data, once distributed across multiple copies of spreadsheets kept by different staff, is now centralized and accessible in real time. Insights that used to be unreliable, scattered across departments, or buried with other unusable data, are now extracted and useful.
Figure 1: Homepage of the newly-created PNLS dashboard
After identifying challenges, Fellows work to understand their placement sites’ overarching needs. At PNLS, Flore found the same need at PNLS that many Fellows find at their sites – for a singular data source where departments can access shared data and perform analyses. Flore’s solution to the data management and analysis problem was to create a unique, centralized data source where departments could access shared data and perform analyses.
She began collecting data in the M&E department, then worked with the HIV Screening, Transmission, Prevention, and other departments to gather more information. Flore then used a common programming language to build the new dashboard. She calculated baseline indicators to measure health outcomes, integrating and strengthening a measurement framework. She also trained PNLS staff on the indicators and how to run useful analyses. Because the tool also completes some analyses automatically, it is easy-to-use and requires just basic capacity building.
Outcomes & Impacts
Without visualization capabilities, effectively preparing and presenting information is a challenge. But with the new dashboard, the PNLS’s Head of HIV Screening Dept can quickly create graphs and charts for presentations. Staff can run reports and gather data without having to submit requests to the M&E department or propagating updates throughout other departments. Individuals now update a central cache of data, rather than reconciling changes across many copies of the same sheet.
Figure 2: By selecting the year 2017 in the Screening Data Tab, the dashboard shows screening data for each region, organized by indicator
DEVELOPMENT GATEWAY (DG)
Development Gateway (DG) provides data and digital solutions for international development. We create tools that help institutions collect and analyze information; strengthen institutional capability to use data; and explore what processes are needed to enable evidence-based decisions. A mission-driven nonprofit since 2001 with staff based in five global hubs and around the world, DG makes development data easier to gather, use, and understand.
DES CHIFFRES ET DES JEUNES (DCDJ)
Des Chiffres et Des Jeunes (DCDJ) is a program led by Development Gateway (DG) and funded by the MCC-PEPFAR Data Collaboratives for Local Impact (DCLI) Program. DCDJ aims to bolster the subnational supply and use of data for Ivorian citizens, engage youth as champions of these services, and fuel innovation to address rising data needs.
CÔTE D’IVOIRE’S NATIONAL AIDS CONTROL PROGRAM (PNLS)
Côte d’Ivoire’s National AIDS Control Program (PNLS) was established by ministerial decision N° 976 / MSLS / CAB of September 04, 2014, creating, organizing and operating the National AIDS Control Program. It coordinates the health sector response to the fight against AIDS and contributes to the reduction of morbidity and mortality linked to STIs, HIV and AIDS by promotional, preventive, curative and research activities.