PCA - H2: Analytics
PCA automatically generates DHIS2 analytics to support the work of H2 users at the field level (quality supervisors) as well as at the central level (headquarters overview). This is achieved by automatically generating a series of DHIS2 Program Indicators that are used to create various visualizations as detailed below
In-App Analytics (android only)
When using H2 in an android device with DHIS2 or PSI’s android fork, for versions 2.6 or greater, you can include in the setup DHIS2 visualizations that use the local information of the device to display data.
PRE-REQUISITE: the server that you connect to has the DHIS2 Android config app installed and initiated.
When the analytics setup in the Android Settings app (DHIS2) is done, the local analytics page will be displayed aside the assessment page (See Image 1) at the bottom of the app. Here, it is possible to find the different program lists at the top and then their respective visualizations, normally there are 3 of them: one pie chart and two tables.
In-App Chart 1
The first visualization is a pie chart showing the accumulated absolute and percentage value for the competency classes presented in the program selected (See Image 1). The chart could be displayed also as table if necessary and has filters options for periods and organization units.
Name | ProgramShortName + “ - Competency Classes (last 6 months)” |
---|---|
Type | Visualization - Pie chart |
Data Dimension Items | Program Indicators:
|
Period | Relative, last 6 months |
Legend | N/A |
Organisation Units | User’s Organization Units |
In-App Chart 2
The second visualization is a table showing the absolute value (counting) for the competency classes presented in the program selected (See Image 2). The table combines at row level the competency classes and at column level the last 6 months. The chart could be displayed also as bar chart, line chart, and bullet chart if necessary and has filters options for periods and organization units.
Name | ProgramShortName + “ - Competency Classes (last 6 months)” |
---|---|
Type | Visualization - Table |
Data Dimension Items | Program Indicators:
|
Period | Relative, last 6 months |
Legend | N/A |
Organisation Units | User’s Organization Units |
In-App Chart 3
The last visualization is a similar table to the last one and shows the absolute value (counting) for the competency classes presented in the program selected (See Image 3). The table combines at row level the organizaztion units and at column level the competency classes. The chart could be displayed also as bar chart, line chart, and bullet chart if necessary and has filters options for periods and organization units.
Name | ProgramShortName + “ - Competency Classes (last 6 months by OrgUnits)” |
---|---|
Type | Visualization - Table |
Data Dimension Items | Program Indicators:
|
Period | Relative, last 6 months |
Legend | N/A |
Organisation Units | User’s Organization Units |
DHIS2 Global Analytics
PCA automates the creation of the dashboard for H2 programs. It contains 6 elements consisting of: 4 Visualizations, 1 Map and 1 Event Report (See Image 4). The Dashboard will be named according to the assigned program name, as well as assigned the same sharing permissions.
Program Settings for Analytics
We use the following program variable to configure its analytics:
Root Organizational Unit: Select an OU, for Pivot Table, Map and Event Report Line List type visualization.
Organizational Unit Level: Select the OU level in which the information displayed in the Pivot Table and Line List type event report display will be segmented.
Map Organizational Unit Level: You must select the OU level in which the information shown in the map will be segmented.
User organization unit: if selected, it will allow the creation of Column, Stacked Column and Pivot Table type visualizations.
Object 1 – Pivot Table
This pivot table type visualization will show you the average score per district over the last 12 months (See Image 5). We use the following variables to set up this visualization:
Name | Program Name - Average Score by District from last 12 months |
|
---|---|---|
Type | Visualization - Pivot Table |
|
Data Dimension Items | Global Score – Program Indicator |
|
Relative period | Last 12 months |
|
Legend | Red - Yellow - Green (<80%, 80-89%, >89%) |
|
Organisation Units | As per Program Settings: Option 1: Use User’s Org Units Option 2: Set Org Unit Root and Level as per Program definition |
|
Object 2 – Stacked Column
This Stacked Column type visualization will show you the competency class over a range of the last 4 quarters. (See Image 6). We use the following variables to configure this visualization:
Name | Program Name - Number and Percentage of Assessment by Competency Class (last 4 quarters) |
---|---|
Type | Visualization - Stacked Column |
Data Dimension Items | Competency C – Program Indicator Competency CNI – Program Indicator Competency NC – Program Indicator |
Relative period | Last 4 quarters |
Legend | Not aplicable |
Organisation Units | As per Program Settings: Option 1: Use User’s Org Units Option 2: Set Org Unit Root and Level as per Program definition |
Object 3 – Column
This Column type visualization will show you the overall score over a range of the last 12 months (See Image 7). We use the following variables to configure this visualization:
Name | Program Name - Average Global Score by checklist from last 12 months |
---|---|
Type | Visualization - Column |
Data Dimension Items | Global Score – Program Indicator |
Relative period | Last 12 months |
Legend | Not aplicable |
Organisation Units | As per Program Settings: Option 1: Use User’s Org Units Option 2: Set Org Unit Root and Level as per Program definition |
Object 4 – Pivot Table
This Pivot Table visualization will show you the number of evaluations in a range of the last 12 months (See Image 7). We use the following variables to configure this visualization:
Name | Program Name - Number of Assessment by checklist (last 12 months) |
---|---|
Type | Visualization - Pivot Table |
Data Dimension Items | Number of Assessment – Program Indicator |
Relative period | Last 12 months |
Legend | Not aplicable |
Organisation Units | As per Program Settings: Option 1: Use User’s Org Units Option 2: Set Org Unit Root and Level as per Program definition |
Object 5 – Map
This map with basemap osmLight, will show you the overall score over a range of the last 12 months. We use the following variables to configure this visualization:
Name | Program Name - Global Score Map |
---|---|
Type | Map |
Data Dimension Items | Global Score – Program Indicator |
Relative period | Last 12 months |
Legend | Red - Yellow - Green (<80%, 80-89%, >89%) |
Organisation Units | As per Program Settings: Option 1: Use User’s Org Units Option 2: Set Org Unit Root and Level as per Program definition |
Object 6 – Event Report
This event report with table style line list, will show you the overall score over a range of the last 12 months. We use the following varialbes to configure this visualization:
Name | Program Name - Global Score |
---|---|
Type | Event Report |
Data Dimension Items | Global Score – Program Indicator |
Relative period | Last 12 months |
Legend | Not aplicable |
Organisation Units | As per Program Settings: Option 1: Use User’s Org Units Option 2: Set Org Unit Root and Level as per Program definition |
Shared Indicators
As part of the PCA automatic metadata generation, the following Program indicators are created and kep up to date:
Program Indicator name | In-App Analytics | Global Analytics | Formula | Condition |
---|---|---|---|---|
Competency - C | x | x | Get Enrollment Count | Attribute HNQIS - Competency Class == "competent" |
Competency - CNI | x | x | Get Enrollment Count | Attribute HNQIS - Competency Class == "improvement" |
Competency - NC | x | x | Get Enrollment Count | Attribute HNQIS - Competency Class == "notcompetent" |
Global Score |
| x | Get HNQIS - Global Score Attribute | HNQIS - Global Score has Value |
Number of Assessment |
| x | Get Enrollment Count | - |