AMPATH launched AMRS to make patients records easier to find. They used the Elastic Stack to develop visualisations for their users.

The <a href="https://www.ampathkenya.org/">Academic Model Providing Access to Healthcare</a> (AMPATH) was founded in 2001 to combat one of the world’s worst epidemics: HIV. AMPATH is a partnership between the Kenyan Ministry of Health, Moi University in Eldoret, Kenya, and a consortium of American universities.
<h2>The challenge: Paper charts and paper records
</h2>In most parts of the world, reliable patient records are hard to find. Access to patient data in clinics is a critical part of healthcare. However, paper records are hard to read, get lost or damaged, and are inefficient to store and retrieve. Imagine having to pull hundreds of charts daily from this stack of records:
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blte22b81766ce71874/5d5da3dcd47d0742ac772761/ampath-medical-records-blog.jpg" data-sys-asset-uid="blte22b81766ce71874" alt="Manual paper filing of records " style="display: block; margin: auto;">
Another problem with paper records is that they make reporting difficult. Separate books, called registers, are used to track patient data for aggregate government reporting. Sometimes several registers must be filled out to collect the information from a single visit.
A register is essentially a spreadsheet. Rows and columns track patient metrics. The results from each page are tallied and transferred to other registers. This is a slow, error-prone, time-consuming, unreliable process that leads to delayed reports.
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt91fccdf3de93a257/5d5da2ddef04464325fb845c/ampath-registers-blog.jpg" data-sys-asset-uid="blt91fccdf3de93a257" alt="Logging records in manual registers" style="display: block; margin: auto;">
<h2>Making the move to digital
</h2>To manage the huge volumes of charts and develop better reports on patient care, AMPATH helped develop an open-source electronic medical record called OpenMRS. Launched in 2006, <a href="https://en.wikipedia.org/wiki/OpenMRS">OpenMRS</a> is currently used in over 60 countries around the world.
By 2015, widespread affordable cellular networks and affordably priced tablets allowed AMPATH to deploy an implementation of OpenMRS designed to run on tablets, called the <a href="http://www.gregoryschmidt.ca/writing/history-of-ampath-medical-record-system">AMPATH Medical Record System</a> (AMRS), which was designed for use during clinical appointments.
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/bltdd370567952f5040/5d5da51b5b220072e8aa2b37/ampath-amrs-blog.jpg" data-sys-asset-uid="bltdd370567952f5040" alt="AMPATH Medical Records System" style="display: block; margin: auto;">
<h3>Moving to the Elastic Stack
</h3>Every day hundreds of providers across Western Kenya use AMRS. This results in a huge amount of data that needs to be managed and made available to key decision makers such as clinicians, clinic administrators, and the Ministry of Health.
Initially, AMPATH <a href="http://www.gregoryschmidt.ca/writing/ampath-ehr-current-data-capabilities">wrote custom code for each new visualization</a> and each new dashboard. The trouble is this took a lot of developer time, the visualizations created were slow to load, and they were hard to debug.
Stakeholders often requested new data visualizations, and it was hard to keep up with the demand using custom code. There was also interest in finding a tool to allow everyone to design their own visualizations, which would help them to better leverage their data and would free up developers’ time.
AMPATH required a solution that could handle a lot of data. The database has almost 8 million visit encounters, with 250 million clinical questions asked.
The Elastic Stack stood out as the right tool. It can handle large data sets and has an easy-to-use interface, a wide feature set, a great community with good documentation, and pricing aligned with AMPATH’s needs.
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt92c9d5808c9d1497/5d5da561999e83431b7656d8/ampath-stats-blog.jpg" data-sys-asset-uid="blt92c9d5808c9d1497" alt="AMPATH data and statistics" style="display: block; margin: auto;">
<h2>AMPATH’s ETL process
</h2>In 2017 AMPATH started development on an extract, transform, load (ETL) process to move data from the electronic medical record MySQL database, through Logstash, into Elasticsearch. Kibana is then used to generate dashboards.
Let's look at the process in the real world.
<h3>Data collection
</h3>Clinicians use AMPATH’s application on their tablet’s web browser during the clinical visit. The application is built in Angular and stores data in a MySQL database exposed via a REST API in OpenMRS.
<h3>Data storage and ETL
</h3>To make reporting easier, the relational tables are flattened using the ETL process. <a href="https://github.com/AMPATH/etl">SQL scripts</a> extract the desired data by performing joins on several tables. The data is then transformed into a form that answers the questions asked (e.g., is this patient currently on antiretroviral drugs?). A SQL scripts then loads the transformed data into a MySQL table. This is now a flattened table.
Each flattened table represents a report. These reports are distributed to different decision makers and users.
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt70e6f994770a02a8/5d5daad765c1577f11a494ba/ampath-diagram-blog.jpg" data-sys-asset-uid="blt70e6f994770a02a8" alt="AMPATH data pipeline" style="display: block; margin: auto;">
<h3>Ingestion into Elasticsearch
</h3>After the flattened data is stored in MySQL tables, it is ready to be consumed by Elasticsearch. This is done with Logstash. One of the benefits of Logstash is its ability to consume data from a variety of data sources.
Logstash consumes the MySQL data and pumps it into Elasticsearch in real time using the <a href="https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html">JDBC input plugin</a>. This plugin supports scheduling and selective data as input by using SQL queries. Each row in the MySQL table is considered a single event, and the columns in each row (event) are considered fields in the event.
<a href="https://medium.com/@fatmali/https-medium-com-fatmali-how-to-setup-a-docker-elk-elastic-logstash-kibana-stack-in-a-jiffy-ab56e2660416">AMPATH’s Elastic Stack is set up on a separate server from MySQL</a> using <a href="https://www.docker.com/">Docker</a>. AMPATH’s <a href="https://gist.github.com/Fatmali/c860f6046f821208a9af55bec49928c9">Logstash</a> config file is used to query the MySQL tables. Check out <a href="https://qbox.io/blog/migrating-mysql-data-into-elasticsearch-using-logstash">this blog post</a> for more details on AMPATH’s Logstash process.
<h2>Kibana visualizations
</h2>AMPATH started building Kibana visualizations in 2018 with a dedicated team, expanding the visualization component library, building new dashboards, and training new users on how to use Kibana.
These visualizations will be used by clinicians, clinic administrators, and key decision makers in AMPATH and the Ministry of Health.
Below are some examples of system monitoring Kibana dashboards currently in use.
90-90-90 Trend Analysis Dashboard
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt01b888705a604cf5/5d5da6abac511e7362584693/ampath-trend-analysis-blog.jpg" data-sys-asset-uid="blt01b888705a604cf5" alt="ampath-trend-analysis-blog.jpg">
 
Overview of trends of HIV viral suppression in a clinic
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt8d1ab99f9386299e/5d5daa482372b57f91ccc125/ampath-vl-analysis-blog.jpg" data-sys-asset-uid="blt8d1ab99f9386299e" alt="Dashboard showing HIV viral load suppression" style="display: block; margin: auto;">
 
Using these charts to view the trends, the clinicians and the management of a clinic can check if a patient's HIV treatment is meeting international targets. This is a critical indicators for clinics.
Control of HIV viral load suppression (an indicator of HIV treatment control), compared across multiple counties
	
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blte4e5bb799f042884/5d5da81465c1577f11a49498/ampath-vl-to-target-blog.jpg" data-sys-asset-uid="blte4e5bb799f042884" alt="HIV viral load suppression compared to target rates" style="display: block; margin: auto;">
 
Comparison of HIV viral load suppression with target rates
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt1db0b2340648f3ba/5d5da8ca3f108672e37b00aa/ampath-vl-suppression-blog.jpg" data-sys-asset-uid="blt1db0b2340648f3ba" alt="HIV viral load suppression compared to target rates." style="display: block; margin: auto;">
 

	Utilizing anomaly detection in server response times with machine learning
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt8394c9a1ad7d6d27/5d5da8f7c0e6e77f8baf24f7/ampath-uptime-blog.jpg" data-sys-asset-uid="blt8394c9a1ad7d6d27" alt="AMPATH uptime monitoring" style="display: block; margin: auto;">
 

	While AMPATH’s primary use case is monitoring and visualizing HIV-related health data, it also use the Elastic Stack for a variety of other uses, including uptime monitoring and log analytics.

	Generating dashboards on the fly is a request AMPATH devs face on a daily basis. Before Kibana, this process was long and tedious, taking several weeks to code and produce visualizations that were often slow as they involved fetching data from a relational database. With Kibana, the AMPATH visualization team is able to create visualizations on the fly and embed them to the EMR. Users can then view and query the visualizations efficiently and quickly.
HIV Daily Clinic Overview Dashboard - overview of the HIV care system
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt051542fb3689a6f6/5d5da92f3f108672e37b00b8/ampath-clinic-overview-blog.jpg" data-sys-asset-uid="blt051542fb3689a6f6" alt="AMPATH clinic overview" style="display: block; margin: auto;">
 
The following dashboard is helpful for administration to know which locations may have long waits.
HIV Daily Clinic Overview Dashboard - comparing the average wait time to see clinicians
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/blt56be5a2789fd8944/5d5da959999e83431b76570c/ampath-clinic-encounters-blog.jpg" data-sys-asset-uid="blt56be5a2789fd8944" alt="AMPATH clinic encounters dashboard" style="display: block; margin: auto;">
 
<h2>Next steps
</h2>This coming year AMPATH would like to expand its dashboards to cover new disease verticals, and train users to be able to build their own Kibana visualizations. We also hope to expand the use of Elastic’s machine learning features for monitoring system performance.
<hr>Elastic has been an indispensable part of AMPATH’s mission to provide healthcare in low-resource settings. As AMPATH continues to expand its care system, there is no doubt that the success in patient care is linked to timely accessible to data. This is made possible with the Elastic Stack.
Authors’ Bios
	
Fatma Ali is a full stack developer in Eldoret, Kenya and is AMPATH’s ETL lead (<a href="https://medium.com/@fatmali">https://medium.com/@fatmali</a>)
Susan Mastamet is AMPATH’s visualization lead in Eldoret, Kenya.
Gregory Schmidt, MD designs medical record systems with AMPATH. (<a href="http://www.gregoryschmidt.ca">www.gregoryschmidt.ca</a> @_GregSchmidt)
Jonathan Dick, MD is the Chief Medical Information Officer at AMPATH.
<img src="https://images.contentstack.io/v3/assets/bltefdd0b53724fa2ce/bltfd2924fb5224b866/5d5da97e999e83431b765712/ampath-team-photo-blog.jpg" data-sys-asset-uid="bltfd2924fb5224b866" alt="AMRS team photo" style="display: block; margin: auto;">
<figcaption>
AMRS Team
</figcaption>

Ampath-Banner.jpg

Ampath-thumbnail.jpg

AMPATH: Providing healthcare in rural Kenya using the Elastic Stack

Start free trial

Blog Footer CTA

Sign up for Elastic Cloud free trial

AMPATH medical record team

By submitting you acknowledge that you've read and agree to our <a href="/legal/elastic-cloud-account-terms" target="_self">Terms of Service</a>, and you agree to receive the <a href="/legal/privacy-statement#how-we-use-the-information" target="_self">selected communications</a> at the contact details you provided above. See <a href="/legal/privacy-statement/" target="_self">Elastic’s Privacy Statement</a> for more details or to opt-out at any time.

Communication Preferences - ONLY for /communication-preferences

제출하면 귀하가 <a href="/kr/legal/elastic-cloud-account-terms" target="_self">Elastic 서비스 약관</a>을 읽고 이에 동의하며, 위에 제공된 연락처로 <a href="/kr/legal/privacy-statement#how-we-use-the-information" target="_self">선택한 커뮤니케이션</a>을 수신하는 데 동의한 것으로 간주됩니다. 언제든지 수신을 거부할 수 있으며 자세한 내용은 <a href="/kr/legal/privacy-statement/" target="_self">Elastic 개인정보 취급방침</a>을 참조하시기 바랍니다.

By submitting you acknowledge that you've read and agree to our <a href="/legal/serverless-preview-terms" target="_blank">Terms of Service</a>, and that Elastic may <a href="/legal/privacy-statement#how-we-use-the-information" target="_blank">contact you</a> about our related products and services, using the details you provide above. See <a href="/legal/privacy-statement/" target="_blank">Elastic’s Privacy Statement</a> for more details or to opt-out at any time.

Serverless GDPR Text

제출하면 귀하가 Elastic <a href="/kr/legal/serverless-preview-terms" target="_self">서비스 약관</a>을 읽고 이에 동의하며, 위에 제공된 세부 정보를 사용하여 Elastic이 관련 제품 및 서비스에 대해 귀하에게 <a href="/kr/legal/privacy-statement#how-we-use-the-information" target="_self">연락할 수 있음</a>을 이해한 것으로 간주됩니다. 언제든지 수신을 거부할 수 있으며 자세한 내용은 <a href="/kr/legal/privacy-statement/" target="_self">Elastic 개인정보 취급방침</a>을 참조하시기 바랍니다.

By submitting you agree to <a href="/agreements/global/cloud-services-monthly" rel="nofollow">Elastic Cloud Terms of Service</a>. Your personal data will be processed in accordance with <a href="/legal/privacy-statement">Elastic's Privacy Statement</a>.

Cloud Trial GDPR Text

제출하면 <a href="/kr/agreements/global/cloud-services-monthly" rel="nofollow">Elastic Cloud 서비스 약관</a>에 동의하시게 됩니다. 개인 데이터는 <a href="/kr/legal/privacy-statement">Elastic의 개인정보 취급방침</a>에 따라 처리됩니다.

By submitting you acknowledge that you've read and agree to our <a href="/legal/terms-of-use" target="_blank">Terms of Service</a>, and that Elastic may <a href="/legal/privacy-statement#how-we-use-the-information" target="_blank">contact you</a> about our related products and services, using the details you provide above. See <a href="/legal/privacy-statement/" target="_blank">Elastic’s Privacy Statement</a> for more details or to opt-out at any time.

Newsletter GDPR Text

제출하면 귀하가 Elastic <a href="/kr/legal/terms-of-use" target="_self">서비스 약관</a>을 읽고 이에 동의하며, 위에 제공된 세부 정보를 사용하여 Elastic이 관련 제품 및 서비스에 대해 귀하에게 <a href="/kr/legal/privacy-statement#how-we-use-the-information" target="_self">연락할 수 있음</a>을 이해한 것으로 간주됩니다. 언제든지 수신을 거부할 수 있으며 자세한 내용은 <a href="/kr/legal/privacy-statement/" target="_self">Elastic 개인정보 취급방침</a>을 참조하시기 바랍니다.

Explore similar demos

Overview

Speakers

Close

See more insights

The content on this page is not available in the selected language. As Elastic grows globally, we continue to support content in multiple languages.

The content on this page is not available in the selected language.

이 페이지의 콘텐츠는 선택하신 언어로 제공되지 않습니다. Elastic은 다양한 언어로 콘텐츠를 제공하기 위해 최선을 다하고 있습니다.조금만 더 기다려주세요!

Author

Articles by

Learn more

Watch now (no PT)

Watch now

See all top stories

All (no PT translation)

Contact information

Press Release

Share on Reddit

Share this story

Share by Email

Thank you for your interest!

Contact Info

Follow us on Youtube

Load More

Share on LinkedIn

Follow us on LinkedIn

Search Integrations

All Solutions

Video for

Follow us on Twitter

See when this webinar starts in my time zone

내 표준 시간대로 웨비나 시작 시간 확인하기

Register to Watch

Register now

See All Posts

Can't make it? Register and we'll send you the recording. You'll also receive an email with related content

참여가 어려우신가요? 등록하시면 녹화 자료를 보내드리겠습니다. 이메일로 관련 콘텐츠도 받아보실 수 있습니다.

Small image for

On-demand webinar

Featured webinar

Register to Attend

Share on Facebook

Reset all

Upcoming webinar

View more posts

Print

Hosted by

Sign In to Attend

View next

Follow us on Facebook

Share

Highlights

Read less

You'll also receive an email with related content

이메일을 통해 관련 내용을 보내드리겠습니다.

Thank you for registering. We will send you a confirmation email soon.

등록해 주셔서 감사합니다. 곧 확인 이메일을 보내드리겠습니다.

Author

Articles by AMPATH medical record team

AMPATH: Providing healthcare in rural Kenya using the Elastic Stack

Sign up for Elastic Cloud free trial