• Ready for review
  • 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.

    Image 1: Landing Page Android Fork

    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:

    • Country + ProgramShortName + “C”

    • Country + ProgramShortName + “NC”

    • Country + ProgramShortName + “CNI”

    Period

    Relative, last 6 months

    Legend

    N/A

    Organisation Units

    User’s Organization Units

    Image 2: In-App chart 1

    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:

    • Country + ProgramShortName + “C”

    • Country + ProgramShortName + “NC”

    • Country + ProgramShortName + “CNI”

    Period

    Relative, last 6 months

    Legend

    N/A

    Organisation Units

    User’s Organization Units

    Image 2: In-App Chart 2

    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:

    • Country + ProgramShortName + “C”

    • Country + ProgramShortName + “NC”

    • Country + ProgramShortName + “CNI”

    Period

    Relative, last 6 months

    Legend

    N/A

    Organisation Units

    User’s Organization Units

    Image 3: In-App Chart 3

    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:

    1. Root Organizational Unit: Select an OU, for Pivot Table, Map and Event Report Line List type visualization.

    2. 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.

    3. Map Organizational Unit Level: You must select the OU level in which the information shown in the map will be segmented.

    4. User organization unit: if selected, it will allow the creation of Column, Stacked Column and Pivot Table type visualizations.

    Image 4: HNQIS2 Settings

    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

     

    Image 5: Object 1- Pivot Table

    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

    Image 6: Object 2 - Stacked Column

    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

    Image 7: Object - Column

    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

    Image 7: Object - Pivot Table

    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

    Image 8: Object 5 - Map

    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

    Image 9: Object 6 - Event Report

    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

    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

    -