Using Executive Dashboards for Hospital Management

Those of us who have done dashboard projects in multiple industries know that the first step is to understand that vertical’s particular workflows, business rules and measures of performance. Finding out what KPIs to display on the enterprise dashboard for a particular type of business is no easy task unless you have first hand knowledge of that industry. Most consultants called in to implement a business dashboard don’t really know the industry first hand and must rely on the client’s subject matter experts. That is fine, but the dashboard vendor or consultant must do as much preparation in studying the client’s business as much as possible in advance. Yes, your particular expertise may be in dashboarding as a horizontal service, but as nice as your dashboard looks and works, it will not succeed if it doesn’t measure the right things.

For anyone involved in healthcare-related performance dashboards, here is a great primer on the workflows for a hospital. This is from a vendor named statcom and, while it is a sales and marketing tool, it does offer plenty of value-add and education for us dashboarders. It is offered as an interactive flash hospital workflow and patient flow simulator.  I’ve grabbed a couple of screenshots of the demo as well as the different executive dashboards involved:

Interactive hospital workflow demo 

After launching the demo, there is a nice interactive menu as you can see. By the way, here is the link to the hospital workflow simulator. Even this menu listing is of value to someone new in this space, as it breaks down the functions and groups within a healthcare facility: Hospital executives, Emergency Department, Patient and Family Communications, Bed Management, Hospital Support Services, Procedure Centers, Perioperative Services, Physicians and Nurses, Diagnostic Services, Case Management, Clinical Support Services.

Hospital roles and workflows

Here are some dashboards that track key performance indicators in a hospital:

This first one is an executive dashboard for upper management. They call it a Business Activity Monitoring Dashboard. KPIs include: LOS (length of stay) statistics, Projected Occupancy, Average Bed Turns, Accuracy of Discharge Predictions, Emergency Department Disposition to Bed Placement in Unit, and the unfortunately-named Average Dead Bed Time (ouch!!!).

Executive Dashboard KPIs for a Hospital

The Emergency Department Dashboard shows real time performance metrics such as Cycle times from door to discharge, milestone measurements of door to disposition, triage to disposition and triage to MD assessment, Diagnostic turnarounds and patient statistics such as the number of patients that are Emergency Department Boarders, Leaving against Medical Advice and (unfortunately) Expired.

Emergency Department Dashboard

The hospital case management dashboard show key stats such as:

  • Occupancy predictions by day of week (based upon estimated day of discharge)
  • Average time of day that patients are discharged by unit (running 7-day average)
  • Time from case management referral to completion
  • Case Management order status

Case Management Dashboard

Bed management is of course a major focus in hospitals and we have seen several bed managment dashboards before on the Dashboard Spy. This one, according to statcom, provides bed managers a real-time view of bed availability and discharge status including:

  • Occupied and available beds across the system and by unit
  • Number of critical and telemetry beds available
  • Number of observation patients
  • Length of stay (LOS) and discharge statistics from time a discharge order is written until the patient actually leaves the room
  • Key hospital support service performance relative to bed turns, such as Environmental Services: stat turnaround, clean next bed turnaround, last bed on the Unit turnaround, and routine turnaround 

Bed Management Dashboard

Tags: Hospital Dashboard, Hospital Workflow Monitoring, Business Activity Monitoring Dashboards, hospital kpi

4 Comments

  1. Comment by Ernesto:

    I need simulate a hospital, but the simulator software is so expensive…

    Could you help me?

    Tankyou,

    Ernesto.

  2. Comment by Abelardo:

    Depending on the type of simulation, you may be able to do it in a spreadsheet!

    I suggest to contact a local university with an Industrial Engineering program, if there’s one in your area. They should be able to help you.

  3. Comment by mary:

    can you contact me if you develop dashboard metrics for companinies and host on-line. thank you

  4. Comment by David:

    How can I find more info on this company? Did they go out of business or were they purchased? Stat Com.

Leave a Reply

More info on business dashboards...close