# Design Forum 2018-04-23: Data Warehousing and Analytics **URL:** \ **Category:** Development\ **Tags:** meetings, design-forum\ **Created:** [April 20, 2018, 12:51pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622 "2018-04-20T12:51:11Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![jthomas](https://talk.openmrs.org/user_avatar/talk.openmrs.org/jthomas/32/21_2.png) [@jthomas](https://talk.openmrs.org/u/jthomas)\ **Post date:** [April 20, 2018, 12:51pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/1 "2018-04-20T12:51:11Z")
Monday’s [design forum](https://wiki.openmrs.org/display/RES/Design+Forum) is a discussion Data Warehousing and Analytics. The eSaude team wants to work on data warehousing and analytics in the upcoming quarter. They are interested to learn about existing work by Bahmni and PIH, to understand if they can leverage one of these approaches. If you have a topic you would like to discuss during the call please post it at [http://om.rs/designtime](http://om.rs/designtime) or join us from 4-5 pm UTC. @ningosi @valvijo @pramidat @mseaton @darius The next design forum on Wednesday, April 25 @ 6-7 pm UTC - OPEN FORUM To join the call using Audio, Chat, & Screen Sharing please use the latest Firefox, Chrome, or other WebRTC-compatible browser and go to: > **[UberConference - The Best Free Conference Call](https://www.uberconference.com/openmrs)** > > UberConference provides a rich visual interface for conference calls. Simple, visual, and free to use, it's audio conferencing done right. Easily set up and join free conference calls, see who is in the conference, who is talking, and use powerful... ---
**Author:** ![lluismf](https://talk.openmrs.org/user_avatar/talk.openmrs.org/lluismf/32/770_2.png) [@lluismf](https://talk.openmrs.org/u/lluismf)\ **Post date:** [April 20, 2018, 1:36pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/2 "2018-04-20T13:36:07Z")
For ETL processes I suggest to look at [https://beam.apache.org/](https://beam.apache.org/) it’s pretty amazing ---
**Author:** ![darius](https://talk.openmrs.org/user_avatar/talk.openmrs.org/darius/32/8082_2.png) [@darius](https://talk.openmrs.org/u/darius)\ **Post date:** [April 23, 2018, 3:33pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/3 "2018-04-23T15:33:06Z")
Hi @ningosi, @valvijo, @mseaton, @pramidat had something come up and she can’t join today; she needs to postpone to another week. Sorry for the short notice! ---
**Author:** ![ningosi](https://talk.openmrs.org/user_avatar/talk.openmrs.org/ningosi/32/8060_2.png) [@ningosi](https://talk.openmrs.org/u/ningosi)\ **Post date:** [April 23, 2018, 3:37pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/4 "2018-04-23T15:37:17Z")
Thanks for informing. I think we are flexible to postpone to another date. @valvijo what do you say? ---
**Author:** ![burke](https://talk.openmrs.org/user_avatar/talk.openmrs.org/burke/32/17_2.png) [@burke](https://talk.openmrs.org/u/burke)\ **Post date:** [April 23, 2018, 4:11pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/5 "2018-04-23T16:11:32Z")
@jthomas, it would be nice to get @nkimaina from AMPATH to join this call if possible. He’s been experimenting with an [OpenMRS Real-time Streaming Topology for ETL](https://github.com/kimaina/openmrs-etl) that combines OpenMRS and other data sources into an ETL pipeline and would undoubtedly have some opinions and insights into OpenMRS-related data warehousing and analytics. ---
**Author:** ![jthomas](https://talk.openmrs.org/user_avatar/talk.openmrs.org/jthomas/32/21_2.png) [@jthomas](https://talk.openmrs.org/u/jthomas)\ **Post date:** [April 25, 2018, 3:32pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/6 "2018-04-25T15:32:18Z")
I will put this on the calendar for next Monday unless @ningosi @valvijo @pramidat @mseaton @darius @nkimaina have any conflicts. If people do please let us know. ---
**Author:** ![burke](https://talk.openmrs.org/user_avatar/talk.openmrs.org/burke/32/17_2.png) [@burke](https://talk.openmrs.org/u/burke)\ **Post date:** [April 30, 2018, 4:28pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/7 "2018-04-30T16:28:21Z")
@jthomas, this call needs to get rescheduled. There is a lot of interest and activity on the topic of Data Warehousing, but we were missing some of the key participants for today’s call. The timing should be led by the eSaude team (@ningosi & @valvijo), who have requested the design forum. The presenters listed below would be required as well. The proposed format would be: ## Data Warehousing Design Call Agenda ### 1. First 15-30 min: Brief (~5-10 min) presentations from three groups: 1. Bahmni (@pramidat) 2. PIH (@mseaton) 3. AMPATH (@nkimaina) Each group would present a technical overview of their current approach to data warehousing along with their future plans (where they’d like to go next). ### 2. 10 minutes for eSaúde @ningosi & @valvijo summarizing eSaúde’s needs/goals for data warehousing. ### 3. 20 minutes of Strategy Discussion Group discussion on ways forward. Are there opportunities to collaborate, divide and conquer, share best practices, etc? ---
**Author:** ![jthomas](https://talk.openmrs.org/user_avatar/talk.openmrs.org/jthomas/32/21_2.png) [@jthomas](https://talk.openmrs.org/u/jthomas)\ **Post date:** [May 1, 2018, 7:06pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/8 "2018-05-01T19:06:16Z")
@ningosi @valvijo, please let me know when you would like to reschedule for. @pramidat @mseaton @darius @nkimaina @burke ---
**Author:** ![owais.hussain](https://talk.openmrs.org/user_avatar/talk.openmrs.org/owais.hussain/32/530_2.png) [@owais.hussain](https://talk.openmrs.org/u/owais.hussain)\ **Post date:** [May 3, 2018, 11:24am UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/9 "2018-05-03T11:24:55Z")
I’d like to be part of this as well. ---
**Author:** ![ningosi](https://talk.openmrs.org/user_avatar/talk.openmrs.org/ningosi/32/8060_2.png) [@ningosi](https://talk.openmrs.org/u/ningosi)\ **Post date:** [May 3, 2018, 1:13pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/10 "2018-05-03T13:13:44Z")
Hi jamie, We will be available the week of 7th between Tuesday and Thursday, please find a slot for us during that time. @valvijo Thanks ---
**Author:** ![saurabhverma](https://talk.openmrs.org/letter_avatar/saurabhverma/32/5_5575768a8748004e209b776fc1b2916d.png) [@saurabhverma](https://talk.openmrs.org/u/saurabhverma)\ **Post date:** [May 3, 2018, 6:38pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/11 "2018-05-03T18:38:07Z")
Hi All, I am working for TekMindz. We have expertise of developing HMIS using OpenMRS. Our our core strength is developing products for clients as per their needs. We have expertise in using open source tools like pentaho for ETL, Elastic search and Kibana for real time dashboards. We can give a demo of the analytics dashboards that we have developed for our other clients. May be the approach used can be useful for any member looking forward for a implementation partner. Kindly let me know your views. I would like to participate in the OpenMRS design forum calls. Kindly share when is the next meeting. Thanks & Regards Saurabh Kumar Verma ---
**Author:** ![jthomas](https://talk.openmrs.org/user_avatar/talk.openmrs.org/jthomas/32/21_2.png) [@jthomas](https://talk.openmrs.org/u/jthomas)\ **Post date:** [May 4, 2018, 4:36pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/12 "2018-05-04T16:36:33Z")
> [@ningosi](#): > > We will be available the week of 7th between Tuesday and Thursday, please find a slot for us during that time. @valvijo @pramidat @mseaton @darius How about Wednesday, May 9 @ 6-7pm UTC or Thursday, May 10 @ 2-3pm UTC? ---
**Author:** ![darius](https://talk.openmrs.org/user_avatar/talk.openmrs.org/darius/32/8082_2.png) [@darius](https://talk.openmrs.org/u/darius)\ **Post date:** [May 4, 2018, 5:29pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/13 "2018-05-04T17:29:26Z")
> [@saurabhverma](#): > > I would like to participate in the OpenMRS design forum calls. Kindly share when is the next meeting. They are on Mondays and Wednesdays (the Monday time is more convenient for India). Call details at [Design Forum - Resources - OpenMRS Wiki](http://om.rs/d), and Jamie Thomas posts the agendas of upcoming calls here on Talk at [Topics tagged design-forum](https://talk.openmrs.org/tags/design-forum) > [@saurabhverma](#): > > We have expertise in using open source tools like pentaho for ETL, Elastic search and Kibana for real time dashboards. We can give a demo of the analytics dashboards that we have developed for our other clients. May be the approach used can be useful for any member looking forward for a implementation partner. This particular design forum is specifically to guide the eSaude team on the approaches that are out there, and they can leverage (with their developer team). So, if you want to demonstrate your analytics dashboards from the angle of how a dev team could leverage them (and there are some open-source artifacts someone could start from) then that would be helpful to present on this call. If you’re looking to show your capabilities for people to engage as an implementation partner, let’s set up a different call for that. ---
**Author:** ![darius](https://talk.openmrs.org/user_avatar/talk.openmrs.org/darius/32/8082_2.png) [@darius](https://talk.openmrs.org/u/darius)\ **Post date:** [May 4, 2018, 5:32pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/14 "2018-05-04T17:32:23Z")
6pm UTC is 11:30pm IST, so that seems a stretch for Pramida. (She can comment though.) I cannot do the Thursday time. It may be worth setting up a doodle poll for this one. ---
**Author:** ![ningosi](https://talk.openmrs.org/user_avatar/talk.openmrs.org/ningosi/32/8060_2.png) [@ningosi](https://talk.openmrs.org/u/ningosi)\ **Post date:** [May 5, 2018, 10:48am UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/15 "2018-05-05T10:48:45Z")
Thursday May 10 @2-3pm UTC will be fine with us ---
**Author:** ![saurabhverma](https://talk.openmrs.org/letter_avatar/saurabhverma/32/5_5575768a8748004e209b776fc1b2916d.png) [@saurabhverma](https://talk.openmrs.org/u/saurabhverma)\ **Post date:** [May 6, 2018, 8:30am UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/16 "2018-05-06T08:30:53Z")
Hi Darius, Thanks for the information. I would like to be part of the eSaude design group discussions. I will see how as an implementation partner we can be of any assistance. We have done work in analytics and etl for other domains while developing products for our clients in different domains. We can try to bring those practices and approaches here. I would be able to share those once I understand the current design stage and various discussions going on. Apart from that regarding our implementation partner showcases I have already shared with you on separate thread where we can discuss about it on Tuesday 8th 9:30 pm IST. Kindly let me know the next design discussion date and time of eSaude project. Thanks & Regards Saurabh Kumar Verma ---
**Author:** ![pramidat](https://talk.openmrs.org/letter_avatar/pramidat/32/5_5575768a8748004e209b776fc1b2916d.png) [@pramidat](https://talk.openmrs.org/u/pramidat)\ **Post date:** [May 7, 2018, 12:11pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/17 "2018-05-07T12:11:11Z")
I agree with @darius. May 10th 2PM to 3 PM UTC works for me. ---
**Author:** ![jthomas](https://talk.openmrs.org/user_avatar/talk.openmrs.org/jthomas/32/21_2.png) [@jthomas](https://talk.openmrs.org/u/jthomas)\ **Post date:** [May 7, 2018, 1:14pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/18 "2018-05-07T13:14:28Z")
@ningosi @valvijo @pramidat @mseaton @darius @nkimaina @burke Please take 5 min to take the Doodle poll below to try and coordinate a call time that will work for all. Would like to have this by EOD today if possible in case people pick Tuesday. [https://doodle.com/poll/pca826azaeubswq4](https://doodle.com/poll/pca826azaeubswq4) ---
**Author:** ![darius](https://talk.openmrs.org/user_avatar/talk.openmrs.org/darius/32/8082_2.png) [@darius](https://talk.openmrs.org/u/darius)\ **Post date:** [May 7, 2018, 3:52pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/19 "2018-05-07T15:52:26Z")
I replied to the doodle poll. (Note that in terms of presenting what Bahmni is currently working on, @pramidat is the person to do this, not me.) ---
**Author:** ![jthomas](https://talk.openmrs.org/user_avatar/talk.openmrs.org/jthomas/32/21_2.png) [@jthomas](https://talk.openmrs.org/u/jthomas)\ **Post date:** [May 8, 2018, 1:53pm UTC](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622/20 "2018-05-08T13:53:23Z")
Thank you to everyone who took the Doodle poll. It looks like Wednesday @2-3pm UTC is the best time for most parties. @pramidat @mseaton @nkimaina @ningosi @valvijo @darius @burke @owais.hussain @saurabhverma Please respond here if you can’t join so we can account for that during the call. [Next page](https://talk.openmrs.org/t/design-forum-2018-04-23-data-warehousing-and-analytics/17622.md?page=2)