Healthcare costs can quickly spin out of control. Misallocation of resources can quickly bring down quality of care. To keep efficiency and profitability moving in the right direction, you need to see all your key healthcare reporting metrics across hospitals, programs, and regions. You need to cut that data many different ways and share it with key employees in order to manage your business more effectively. Use Tableau to:
- Understand profitability by specialties, HRGs (Healthcare Resource Groups), gender, and age.
- Identify patterns of cost and profitability by admission method and specialty.
- Provide interactive, web-based dashboards to staff so they can get exactly the data they need right on the floor and in real time.
For-profit hospitals need to be able to analyze and understand profitability across many dimensions of their business
This visualization provides a perspective on which specialties are the most profitable for a national healthcare organization. Medical and surgical specialties are high in revenue and have strong profitability, according to the bar chart at the bottom of the dashboard. Using the dashboard, you can evaluate which regions respond well to advertising, and make decisions about where and how to expand service.
Healthcare providers and insurers need to know which diseases are the most prevalent in a given population, which ages are most affected, and what the associated costs are. Using anonymous patient-level costing data is extremely useful for this type of analysis.
Using this dashboard, a healthcare insurer can evaluate the risks of particular applicants, which diseases they are most susceptible to, and what the costs of treatment for them would be. This application uses data from MEPS (Medical Expenditure Panel Survey).
The insurer can select a number of diseases to consider using the filter on the right. They can filter age at the bottom right. The entire dashboard will update based on the filters.
When published to Tableau Server, the dashboard provides a secure way for managers and executives to explore service trends right in a browser.
In a large hospital, thousands of patients come and go each week. How do you know if you are planning correctly to meet the needs of your population?
With this visualization, hospital administrators can better understand the demographics of an enormous client base. Clicking on any zip code on the map shows a breakdown of the patient demographics in that zip code.
By analyzing patient origin, age and length of stay, hospitals can anticipate their staffing and facilities needs as well as understand which neighborhoods to target for outreach.
Wait time is one of the most important drivers of patient dissatisfaction. Track the time it takes to cycle a patient through from reception to discharge with all variables included. This allows you take the appropriate action to improve flows and improve patient experience.
This visualization tracks about two months of data in a multi-physician office. On week 4, the office implemented a plan to improve processes, targeted at reducing wait times in the waiting room and exam room.
The top view shows that after the process improvement, total cycle time did in fact decrease. Clicking through the steps of the patient cycle on the bottom right, you can see that the reduction in wait time was most dramatic at the two targeted steps. Other steps in the process stayed constant.
The net result was that the process improvements reduced total cycle time from 73.7 minutes to 64 minutes, a reduction of around 13%.
Easy access to medical records and patient information could significantly improve the completeness and analysis of patient cohorts. Estimates indicate that more than 50% of patient information is maintained in unstructured data formats. This makes it difficult and costly to mine and leverage the data for improved care delivery, risk avoidance and cost efficiencies.
Developed by Hitachi Consulting and Attivio, this workbook demonstrates the power of visual data presentation and unified information access to patient electronic medical record data, text documents, and medical images for healthcare provider organizations.
By visualizing the number of patients by location, ICD-9 code, and practitioner progress note, and offering the ability to drill down to detailed records of each individual patient, this workbook provides a comprehensive and interactive platform for health care providers at all levels to monitor, analyze and improve their services.