8. Data Analysis

Jason Knueppel -

The Data Alignment Activity data is composed of both the MOH and PEPFAR results on key indicators at the facility level and holds a wealth of potential for deeper understanding into the HIV landscape for your country.

Below are two methods to access and analyze the data:

          noun_connection_540136__med_red__-_Copy.png      DAA Explorer (R Shiny) Application

One method to analyze the data is through the DAA Explorer (R Shiny) application.  This provides the most flexibility and is useful for in-depth and trend analysis.  The app also provides a method to extract the raw data itself as well as predefined Excel Pivot tables.  The export ability also lends itself to integration with additional datasets (e.g. Human Resource data).


  logo_datim.png  DATIM Pivot Tables    

Another method to analyze the data is through the standard DATIM Pivot Tables.  This is helpful for a general high-level overview of the data.


Analyzing the Data!

The following analyses only scratch the surface of the possible deep-dive country teams can do.  When reviewing and analyzing, think about how the analyses can be made actionable...

  1. Initiate meetings with MOH colleagues to review the Data Alignment data in order to strategize on improving data quality and efficiencies in data collection and where it should have a programmatic impact.
  2. Analyze the gaps in reporting systems (processes and/or tools) and identify opportunities for strengthening these.
  3. Analyze the discordance between PEPFAR and MOH:
      • What might be contributing to discordance?
      • Do sites with EMRs (Electronic Medical Records) have higher or lower discordance and why?
      • Is there a correlation with the number of clinical staff present or the support type (DSD/TA)?
      • Can discordance in reporting be discussed with partners at the implicated facilities to understand potential causes and solutions?
      • Can further investigation be done during SIMS visits?
  4. Measure site level performance and provide feedback to facilities
  5. Investigate where there may still be misalignment with the country's Master Facility List and DATIM and how this needs to be addressed and easily maintained.
  6. Review differences in indicator definitions or calculations (to what extent are PEPFAR and MoH indicator definitions aligned?).


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Powered by Zendesk