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.
A patient’s first formative impression with your hospital often occurs in the Emergency Department. Ensuring that their experience, and the care provided exceed expectations is a critical aspect to attracting patients to your facility. Thus it’s critical to leverage the data you capture in a manner that highlights steps in the process that can be streamlined and improved upon, to ensure every second that counts is efficient, and every touch-point with the patient and their family is executed flawlessly.
The "Arrival" dashboard lets you see your patient arrival metrics by hour and by day, which is critical to ensuring you staff appropriately, and have the right resources in place.
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.
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.
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. With this visualization, 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.
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.
The net result was that the process improvements reduced total cycle time from 73.7 minutes to 64 minutes, a reduction of around 13%.