Program Dataset Connector: PDAC

Part of the Integrating tracker and aggregate data in DHIS2 DAC2021 Session: Wednesday 23nd June 14:00

If you are attending the DHIS2 Annual Conference, more details on this session are available here.

If you have not yet registered to the DHIS2 Annual Conference, do not hesitate to visit the DHIS2 Annual Conference website and secure your spot!

Program Dataset Connector: PDAC (DHIS2 Web-app)

Linking tracker and aggregate data models to enhance tracker analytics

Hi, my name is Pete and I’m a software engineer working at BAO Systems, currently living close to Cambridge (UK). I thought up the idea for this application in early 2021, developed it using the DHIS2 application platform and have been using it in my work with clients at BAO.

In the presentation I will be demonstrating how to create advanced tracker analytics by piping tracker data into the aggregate data model using a combination of the PDAC app, program indicators and indicators. This allows tracker data to make use of disaggregations in a way not possible using the tracker data model alone.

With this data flow, the power of program indicators in tracker and complex disaggregations in aggregate work together to give an extremely useful way of viewing tracker analytics, making it easier to spot trends and patterns in the data and help make better data driven decisions.

During the presentation I will show how a normal DHIS2 tracker analytics setup can be enhanced using the app, I will cover the following topics:

  • Initial setup required on the aggregate side
  • How to create program indicators for disaggregations by hand
  • Demonstrate the growing complexity of this method
  • Show how the PDAC app is used to automate this process using category option filters
  • See the program indicators, indicators and indicator groups outputted by the app
  • Understand how these are linked to the aggregate configuration
  • Show the data transfer process and final result

The presentation was held on Wednesday the 23 June, 14:00 – 15:00 CEST

The app will be submitted to the app hub soon, but in the mean time it can be found in github:

13 Likes

Thank you @plinnegan for this very timely information. Please, when is the presentation?

Hi @ifeanyiokoye great question! My presentation will be on Wednesday 23 June, 14:00 – 15:00 CEST. I will update the main post with this as well.

Questions during the session (from the zoom chat):

From @luciafm:
@Olav are they all in the DHIS2 Hub app? Having a easy way to find them all and see what each does will be great! Also to avoid duplicating functionalities as they aps move along. We have quite a to do list for MD Sync, will be great in any of these functions are already addressed by other apps

Answer:
From @Olav:
@luciafm at least one in the app hub, one I think in review for being added to the app hub


From @Rod:
@Olav - where do you plan to publish the inventory of data/metadata sync apps ?
From @luciafm:
I echo Rod’s question


From @Derebe:
Is this App available in App hub?

Answer:
From @Olav:
Yes, we’re working on updating the implementation guidance on this topic, and the current plan is to also include pointers to relevant tools there.


From @luciafm:
@plinnegan: is the code of your app open source?

@Derebe @luciafm The app is open source, you can find it on github here:

You can find the built app in the releases section on the github page, but it has not yet been published to the app hub. Hopefully within the next month it will be available though.

Recording of the session can be found here:

1 Like

Hello,

It seems that PDAC is not yet supported by version 2.36 of dhis 2. The list of indicators is not displayed.
Or may be I miss something in the configuration ?

Regards

Hi Mamadou,

Correct some versions of 2.36 are not supported. There is a bug in DHIS2 2.36 where the !like operator in the api doesn’t work. This means when the app sends a request to get the available program indicators it returns nothing. There is an issue in JIRA here for this work, and it’s been fixed in 2.36.4, so please try upgrading to this patch version if possible.

Best,
Pete

1 Like

Hello @plinnegan

Ok I see, thank you so much.

2.36.4 is not yet available on the dhis 2 download page.

Regards

Version 2.36.4 was released yesterday. PDAC is working very well, thank you very much.

2 Likes

Great! Glad to hear it’s working for you now :+1:

1 Like