Dashboard recommendations for ODK data and Connecting to DHIS2

Hi Everyone,
we need to work in this topic because every application has real time dashboard when any person to entry in
application show in dashboard.Monitoring staff easily check enumerator work.And on the spot call if enumerator doing wrong work.
1-we need to video how to make real time dashboard ?
2-how to check data mentoring staff easily ?

2 Likes

I can really recommend PowerBI from Microsoft. It is free and easy. You can also link it to the Database directly instead of using briefcase and you can publish the content to websites as well (automatic updated like in Google Fusion Tables)

Hi @Amanda_Berman,

Please have a look at OpenFN Since its Free Open Source Software may be you can build a solution on top of that.

1 Like

I have heard great things about Power BI. So you can keep pushing data as it comes in?

Thanks! I will look into this now.

I am currently working on similar analytical dashboard project. If you are good at R, you can pull data from ona platform and use shinyapps.io server to deploy your analytics online.

hi, I have developed a robust dashboard and reporting solution that one can use by connecting it directly with the ODK data. Please let me know if you would like to see a demo of it. I have not made it commercial yet as I have developed it as during my leisure time. You could use it to pull the data from ODK server and design report and dashboard.

Thanks,
Kanagu.

4 Likes

I Need your dashboard demo my email is azamiqbal51@gmail.com.and after that i will purchase your product

I've played with using Google Data Studio as a linked dashboard to allow for real time updates. Its worked well for the basics. It is limited in some regards associated with indicators which need to be estimated post-collection, and for data points within repeat groups (which don't publish to google sheets).

Publishing from Aggregate directly to Google Sheets is straight forward. Then linking the Sheet to Google Data Studio is also straight forward. Potential problems arise when computing values within google sheets, and using data from repeat groups.

I'm happy to discuss more if others are interested. I've had it on my list to check out PowerBI and would gladly like to hear more from the community on their experience linking PowerBI to Aggregate.

3 Likes

Hi Azam, please give me a demo. My email is: stephenkojwang@gmail.com

Hi Llyod, kindly also share with me your google data studio for a review. My google account: stephenkojwang@gmail.com

Thanks.

can i also give it a try? fabla2020@gmail.com

Hi Fabla and Stephen

I give a very general workflow of connecting ODK Aggregate, Google Sheets, and Google Data Studio HERE.

Do you have specific questions? If I'm able I will try to address them in the forum so everyone can benefit (with hopes others can provide insights as well).

3 Likes

Hello, Mic how to do that in Power BI?

Hello Kanagu, could your share it with us pleas?
Congrats for your job

Dear Kanagu, I am also very very interested of using your robust dashbord and reporting tool. I am running a project with Kobotoolbox (on the humanitarianresponse.info server instance). They have a simple reporting tool but it's not working now.
I'd like to have a look at your solution and hopefully it will help me.
My email: juhudi.duparc@congoinitiative.org

With respect SPECIFICALLY to DHIS2 - has anyone successfully connected ODK data to DHIS2? Or know of a developer/consultant to assist?

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

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.

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