# Analytics: How can we make your life easier?

**URL:** <https://talk.openmrs.org/t/analytics-how-can-we-make-your-life-easier/29285>\
**Category:** Development\
**Tags:** roadmap, reporting\
**Created:** [July 2, 2020, 4:39pm UTC](https://talk.openmrs.org/t/analytics-how-can-we-make-your-life-easier/29285 "2020-07-02T16:39:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![grace](https://talk.openmrs.org/user_avatar/talk.openmrs.org/grace/32/16942_2.png) [@grace](https://talk.openmrs.org/u/grace)\
**Post date:** [July 2, 2020, 4:39pm UTC](https://talk.openmrs.org/t/analytics-how-can-we-make-your-life-easier/29285/1 "2020-07-02T16:39:26Z")

</div>

We’ve had a number of previous posts on how we can improve analytics: [Advanced Reporting/Analytics for OpenMRS](https://talk.openmrs.org/t/the-promise-of-openmrs-etl-advanced-reporting-analytics-for-openmrs/28129), an[out of the box ETL solution for OpenMRS](https://talk.openmrs.org/t/thoughts-on-designing-a-data-metadata-driven-out-of-the-box-etl-solution-for-openmrs/26352), [Analytics on FHIR](https://talk.openmrs.org/t/analytics-on-fhir/29048), an [ELT/ETL Pipeline Demo](https://talk.openmrs.org/t/openmrs-elt-etl-pipeline-demo/28016), and the previous [ETL/ELT standup](https://talk.openmrs.org/t/reminder-2020-05-20-etl-elt-stand-up/28415).

The core of the matter is **we want to improve the tools for reporting and analytics** on the OpenMRS platform - and **we want to be clear on the prominent use-cases faced by the community** , so we can start together by focusing on examples that will offer high value for multiple groups.

We’re [gathering requirements](https://wiki.openmrs.org/pages/viewpage.action?pageId=235276342) as we will soon open a squad and tackle the technical next steps (previously referred to as the “ETL Squad”). @akimaina, @bashir, and @aojwang are the technical leads and we’re keen to hear your responses here. Concrete examples of common problems will help focus the new squad’s efforts from the start.

Right now, there are 2 things you can do before we kick off the squad:

### **We want to hear your use cases - and the problems you’ve faced**

1. What do you want to do with your data?

2. What makes it hard for you to do that right now?

### **Vote on the examples that resonate with you**

For example, we’ve heard pain points like these ones below - vote on the ones that resonate with you/your implementation!

_Poll ([view on site](https://talk.openmrs.org/t/analytics-how-can-we-make-your-life-easier/29285/1))_

**If you’re using OpenMRS and want improved reporting and analytics tools, simply reply to this Talk post, and/or vote on the examples above with what resonates! 🙂**

@akimaina @bashir @aojwang @mksd @mseaton @mogoodrich @jdick @nkimaina @paulamendola @burke @ibacher @dkayiwa @ssmusoke @morrisng @ggomez @mozzy @k.joseph @chris @ccwhite23 @janflowers @ayesh @rubailly@danfuterman @wyclif(If I’ve neglected to tag anyone, please do add them below 🙂 )

---

<div class="post-metadata">

**Author:** ![ssmusoke](https://talk.openmrs.org/user_avatar/talk.openmrs.org/ssmusoke/32/8020_2.png) [@ssmusoke](https://talk.openmrs.org/u/ssmusoke)\
**Post date:** [July 3, 2020, 5:56am UTC](https://talk.openmrs.org/t/analytics-how-can-we-make-your-life-easier/29285/2 "2020-07-03T05:56:52Z")

</div>

Based on our experience with UgandaEMR running at over 1000 sites, a simple first step for all sites would be an automated ability to unroll the EAV concept data into tables following either encounters or forms and maybe some other custom transformations

That will simplify reporting for 80% of facility needs and provide a basis for more complex reporting and computations

---

<div class="post-metadata">

**Author:** ![ccwhite23](https://talk.openmrs.org/letter_avatar/ccwhite23/32/5_5575768a8748004e209b776fc1b2916d.png) [@ccwhite23](https://talk.openmrs.org/u/ccwhite23)\
**Post date:** [July 8, 2020, 6:24pm UTC](https://talk.openmrs.org/t/analytics-how-can-we-make-your-life-easier/29285/3 "2020-07-08T18:24:52Z")

</div>

@janflowers

---

<div class="post-metadata">

**Author:** ![grace](https://talk.openmrs.org/user_avatar/talk.openmrs.org/grace/32/16942_2.png) [@grace](https://talk.openmrs.org/u/grace)\
**Post date:** [July 8, 2020, 11:26pm UTC](https://talk.openmrs.org/t/analytics-how-can-we-make-your-life-easier/29285/4 "2020-07-08T23:26:41Z")

</div>

@ball @mseaton anything to add here?