Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Healthcare Dashboards: Examples of Visualizing Key Metrics and KPIs

DZone's Guide to

Healthcare Dashboards: Examples of Visualizing Key Metrics and KPIs

Examine how visualizing healthcare data can provide a better understanding of goings-on in hospitals and suggest ways to visualize commonly tracked metrics.

· Big Data Zone ·
Free Resource

Hortonworks Sandbox for HDP and HDF is your chance to get started on learning, developing, testing and trying out new features. Each download comes preconfigured with interactive tutorials, sample data and developments from the Apache community.

The world of healthcare analytics is vast and can encompass a wide variety of organizations and use cases — from hospitals to medical equipment manufacturers, and emergency rooms to intensive care units. And while some of the dashboard metrics tracked by healthcare organizations can be fairly similar to the ones monitored in other industries such as finance or marketing, the use of business intelligence in hospitals presents a unique set of potential insights that can help physicians save lives by providing more effective and resourceful care to patients.

This article will examine a number of ways in which visualizing healthcare data can help physicians and management gain a better understanding of goings-on within hospitals and suggest ways to visualize commonly tracked metrics. But first, let's understand where this data is coming from.

Common Data Sources in Healthcare

  • Electronic Medical Records (EMR): These are essentially a digital version of the patient's paper chart, used by clinicians to monitor the patient's condition, treatments he or she is due for, etc. These are usually kept within the bounds of the facility in which the patient is being treated.
  • Electronic Health Records (EHR): A broader set of digital records pertaining to the patient's overall health, including information regarding previous treatment administered by other healthcare providers, specialists, laboratory tests, and more. These would typically move with the patient and be shared by various providers.
  • Specific departmental data: Gathered by specific divisions or units within the healthcare organization.
  • Administrative data: Collected in Healthcare Management Systems (HMS) and looks at the hospital's overall operations. Would typically be used by a hospital's senior managerial staff and may include information regarding matters such as resource utilization and human resources.
  • Financial data: Often stored in proprietary financial management systems for larger organizations.

As you can see, many healthcare providers often find themselves working with many disparate data sources. However, there can often be unique benefits in connecting data stored in these various sources to find correlations between them. Consolidating the data can be done in an enterprise data warehouse, which is a project best undertaken by heavily staffed IT departments.

Examples of Data Visualization in Healthcare

Once you've gathered all the required data and undergone the prerequisite data modeling steps, you can start looking at effectively monitoring key hospital analytics metrics and thinking of insightful ways to visualize them in a healthcare dashboard. Here are a few healthcare analytics examples, with the disclaimer that these are by no means the only things a hospital would generally be looking at, nor necessarily the most crucial ones.

For the purposes of this article, we've used sample data. 

Cost of Admission by Department

This is a very simple visualization, but nevertheless, one that can help hospitals understand how their financial resources are being utilized. By using a bar chart, we immediately provide additional information that might have been more difficult to notice in tabular format — such as shifts in the relative costs between departments, as well as peaks that could indicate an issue that needs to be addressed or at least further investigated.

A different way of visualizing the same data would be a line chart:

This visualization gives us a clearer idea of trends and outliers, and some people might find it more intuitive to examine the data regarding to a specific department in this format — the significant information becomes more apparent immediately. However, this is largely dependant on what the viewer's emphasis is on when examining the data.

Another common way to look at the same data would be via the following visualization, which gives the exact revenue figures and a very clear idea of each department's costs on an annual basis:

As we've mentioned before, an effective dashboard reveals detail on demand. This means that after providing a high-level KPI overview, you might want to give the dashboard viewer the ability to drill into the data — in this case, the admission costs of the various units within the operating rooms. We chose a line chart, as it gives us an immediate indication of highs and lows in admission costs:

ER Admissions and Length of Stay

This visualization gives us a single-glance view of data from several different sources. In our sample dataset, we had to join data from admissions, divisions, and ER tables. Combining these datasets gives us a clearer idea of hospital resource utilization by examining the number of patients being admitted to the emergency room and the average time these patients spend at the hospital. This sets the way for further investigation into peaks, trends, and patterns.

Leading Diagnoses by Number of Patients, Cost and Stay

Here, we've kept the data in tabular form. However, by combining financial and administrative data with departmental records, we gain the ability to quickly get answers to specific questions that can shed further insight into the various treatments being administered and how these affect hospital finances and room availability. Applying filters will enable us to examine specific dimensions such as region, time, or facility.

Image title

Hospital Donations

If your organization bases its budget on donations, like so many do, it's important to track trends in order to understand how to plan for the year ahead. A donations dashboard can help you to find ways to increase engagement of donors and ensure financial stability. If donated amounts are different from what you expected them to be or change dramatically, you can analyze the retention level of donors and find ways to engage more.


Hortonworks Community Connection (HCC) is an online collaboration destination for developers, DevOps, customers and partners to get answers to questions, collaborate on technical articles and share code examples from GitHub.  Join the discussion.

Topics:
big data ,kpi ,data visualization ,dashboards ,healthcare ,data analytics

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}