Dashboard recommendations for ODK data and Connecting to DHIS2

Support
21

How would I link? Via Ona server or how, without using briefcase?

22

ou sorry for late answer. didnĀ“t see it.
So i donĀ“t know about Ona-server, how they let you access the database
PowerBI has some connectors integrated to get data from many sources like Websites, SQL/MySQL Databases
Even CRM like Salesforce...

So the tricky thing is make the connector work. then in the Powerbi-Desktop you have a button to refresh the data in the report.

23

DHIS2 uses Postgresql... there is a connector for this in PowerBI.
You can Publish Data(make sure it is anonymized) also ob websites. it looks like the attached link, can also be embeded and is interactive.
Click on the charts to filter them live
a nice feature :))

2 Likes
24

This is great Mic! How did you connect the power BI with odk servers (ona/kobo toolbox)? Did you transfer the data from odk servers to DHIS2 then from DHIS2 to power BI?

25

Hi Mic,
This looks super cool.
Can you please elaborate on how you connected ODK and Power BI?
Thanks for your help.
Kind regards,
Martin

26

A post was split to a new topic: Connect directly from kobo to power bi

27

This is great well done @Mic Kindly share how you were able to create that link between odk server and powerbi

28

I also wanted to note for this thread that the ODK Central server provides an OData live data feed, which you can use within PowerBI.

2 Likes
29

We use Power BI to do the visualization from ODK Aggregate. I don't know detail about DHIS2 but i think it will be some how the same. What we have done is as follow

  • We have designed our forms on ODK aggregate

  • Since our forms were not in a normalized table format to be easily used in Power BI, we have created a normalized table structure with in our database (PostgreSQL). We have also prepared views which can be easily consumed by Power BI.

  • Then we use database triggers to update our normalized tables whenever there is a submission to ODK aggregate database.

  • Finally we design our reports in Power BI desktop software and publish them to Power BI online.

One thing to note is Power BI online is not free. You need to have license for all people who is going to access your report. Or you can buy the premium version which is very expensive.

This might not be the best solution but it works with our tight schedule where we don't option to see other alternatives. If i had enough time, i would have checked Apache Supersett or Redash for visualization both are open source and do the work.

Thank you,
Nuredin

2 Likes
30

Good evening,
I don't know Power BI and we deployed a lot if Redash dashboards, some over Aggregate database.
As we plan to to do over Central with its json API as soon as we will have install it.

2 Likes
31

Hi Amanda,

I am new developer in ODK software. I am looking for dashboard in ODK software.

Can you please share some video tutorial to how to create dashboard in ODK software or please write me method to how to preparing the dashboard thru ODK software.

Thanks to you in advance for your guidance and support.

Thanks & regards,

Anil

32

Dear Nuredin

We are experimenting, too, with Power BI and I assume that many do, so the following question might be interesting for a broader audience.

Our questionnaire (xlsform) has a lot of skip logic and repeats. For instance, capturing either data on a school or data on a ECD centre, as well as asking for the number of preprimary classes and then for enrolment numbers of each of them. As a result, not all fields are used after sending a few forms. Similarly, it could be that we add a field to the questionnaire later.

It seems that doing a power query (via API) leaves out all not yet used fields and doesn't update, so that later used/added fields are missed out in Power BI.

Now, I wonder whether the issue of "normalized tables" mentioned in the posting above bears an explanation for this issue?

Kind regards
York

33

Hi Amanda,

I am a software developer and I have successfully developed a small application using Spring Boot to pull data from ODK Central, perform any manipulation on the data and push the results to DHIS2 via APIs. The application uses a scheduler of every hour pull data.

Reach me via simiyuwdan@gmail.com for question or more information.