PEPFAR MER Cleaning Favorites

Office of Program Planning and Evaluation (PPEV) has created curated cleaning favorites for the MER indicators to be used by field teams to perform quality control checks on their data. These curated favorites are in the form of pivot tables and are accessible via DATIM.

Purpose: These curated cleaning favorites are created as a starting point for reviewing quarterly data. These curated favorites’ layouts emulate the MER data entry screen. This allows for DATIM users to review the totals of MER indicators and if the totals are not equal to the users’ expected result, users can look at the disaggregated data to see where a data error is present.

These curated favorites also include the MER indicators that are calculated by auto-summing data entered into other indicators and/or disaggregates (i.e. HTS_TST numerator, HTS_RECENT numerator, etc.).

Users should use these tables to check if their auto-summed indicator value is accurate. If not, users may use the curated favorite table to check in which indicator/disaggregate the data error occurred and clean accordingly during the data cleaning period.

NAMING CONVENTION: In DATIM’s Data Visualizer app, each curated cleaning favorite has the following naming convention:

PEPFAR FY25Q1 Results <Indicator> <’N’ or ‘D’><Disaggregation, if any> Completeness Review Pivot

The ’N’ or ‘D’ represents Numerator or Denominator. For example, for the numerator of PMTCT_STAT disaggregated by Age/Sex/KnownNewResult, the canned cleaning favorite is named:

“PEPFAR FY25Q1 Results PMTCT_STAT N AUTO-SUM Age/Sex/KnownNewResult Completeness Review Pivot”

Note: if the indicator is calculated by auto-summing other indicators and/or disaggregates, “AUTO-SUM” will be present in the favorite’s name (as seen in above example).

NESTED MENU FORMAT: The nested menu navigation is structured following the data entry screens. The menu follows this logic:

Results > Programmatic Area (Prevention, Testing, Treatment, etc) > Indicator > Disaggregation Type > Reporting Period > Opens new window or tab to display the Data Visualizer table.

NOTE: There are sometimes many different disaggregation types for one indicator. These reflect updates to the MER Guidance and Indicators over the years. The link will redirect users to the curated cleaning favorite in DATIM.

ACCESS: DATIM users can access the curated favorites by going to the “MER Review Favorites” Dashboard and clicking through the nested menu. The curated favorites display data directly from the live DATIM system.

NOTE: This means that data may change/differ based on your user role permissions, whether MER data entry or data cleaning is in-progress, and whether MER data has been approved.

HOW TO USE:

1. Starting from the DATIM Landing Page, use the menu to find the MER Results Review Favorites: (after logging in through Okta) https://www.datim.org/dhis-web-dashboard/#/rCUIegdBgWV

This is a screenshot of the MER Results Review Favorites page on DATIM. The user has the option to select and view the MER data they have access to - from a menu of available options.

2. DATIM users may filter or update the group set options on the left side or the dropdown menus across the top of the app page to add customizations.

This is a screenshot of the DATIM Data Visualizer. The user can use the left hand column to select the types of data they would like to view and display. The user can use the top bar to organize this data into columns and rows for easy display.

3. After adding filters or additional customization, users should also save the edited favorite under a new name to retain the favorite for future use.

Note: Once a curated favorite is edited by a user, it cannot be guaranteed that the favorite will be displaying the correct data the user is querying.

This screenshot displays how a user can save a certain view by selecting the "Update" button.

Have more questions? Submit a request

Comments