Healthcare Data Analytics: Methods of Matching Scarce Resources with Uncertain Patient Demand, Data Envelopment Analysis: Comparing Productivity and Performance of Units with Multiple Inputs and Outputs

Data envelopment analysis (DEA) is a technique that was developed to measure the multiple dimensions of performance (efficiency) of producing units. 

Webinar Jan 01 2026, Thursday 01:00 PM EDT 60 Minutes Intermediate Level Code: GRC0000323

  • Data Envelopment Analysis:  What is it? What is it for?
  • A concept of the efficiency frontier and a scoring function
  • DEA as a linear optimization problem
  • Examples of DEA using Excel Add-in Solver with explanation of the spreadsheet set up:
      - 6 hospitals: 2 Inputs and 2 Outputs
      - 12 medical labs: 2 Inputs and 3 Outputs
      -  A network of 8 hospitals: 5 Inputs and 3 Outputs(based on the actual project within Froedtert Health Hospital System)
  • Strength and limitations of DEA
  • Available free DEA software

  • Nursing Managers
  • Chief Nursing Officers
  • Directors and VP of quality and operations improvements of healthcare organizations

While one could find a rich literature on various aspects data envelopment analysis (DEA), it is typically presented as an academic mathematical development in the area of linear optimization which is difficult to apply in practice.

One should attend this webinar because it is focused on examples from the real hospital practice rather than using the complicated mathematics of linear optimization theory.

All presented examples are illustrated by the provided Excel spreadsheet using the Excel solver Add-in. The examples are taken from the real hospital projects rather than presenting just academic exercises

The performance assessment of many health care units based on the profit alone as the main metric is usually inappropriate. This raises essential questions about how the performance of such units can be more appropriately assessed. The core idea is that a set of inputs and outputs can be identified that are common across a set of units that should be compared and managed. The values of the inputs and outputs are used to create a scoring function for each unit relative to other similar units. Linear programming is then employed to find out the values of the parameters that maximize or minimize the scoring function. Such an approach is called Data Envelopment Analysis (DEA). One of the useful byproducts of this approach is that it also allows to estimate the improvement targets for the lower performing units.

Alexander Kolker
Alexander Kolker

Alexander Kolker holds a Ph.D. in applied mathematics. He is an expert in advanced data analytics for operations management, computer simulation and staffing optimization with the main focus on healthcare applications. Alexander is the lead editor and author of 2 books, 8 book chapters, 10 journal papers, and a speaker at 18 international conferences & webinars in the area of operations management and data analytics. As an adjunct faculty at the UW-Milwaukee Lubar School of Business, he developed and taught a graduate course Business 755-Healthcare Delivery Systems-Data Analytics. He worked 12 years for GE (General Electric) Healthcare as a Data Scientist and CT Detector design engineer, 3 years for Froedtert Hospital, the largest healthcare facility in Southern state of Wisconsin, and 5 years for Children’s Hospital of Wisconsin as a lead computer simulation and system improvement consultant.

Currently he is teaching a 12-sessions online course “Healthcare Operations Research and Management Science” for the UK, National Health System (NHS).

  • 60 Mins | Jan 01, Thu , 01:00 PM EDT

Because of the inevitable variability of the patient census (uncertainty), the planned (budgeted) staffing is usually:...

Alexander Kolker By Alexander Kolker

  • 60 Mins | Jan 01, Thu , 01:00 PM EDT

Integer Linear Optimization is a very powerful and resourceful methodology for developing rather complex optimized staff...

Alexander Kolker By Alexander Kolker

  • 60 Mins | Jan 01, Thu , 01:00 PM EDT

Discrete event simulation (DES) is the most powerful methodology used in process data analytics/Operation Research. Pro...

Alexander Kolker By Alexander Kolker

  • Oct 27, Monday | 01:00 PM EDT | 75 Mins

Tattoos were always associated with sailors, marines, and bikers. Not today. Over the past few decades, there has been r...

  • Oct 27, Monday | 01:00 PM EDT | 60 Mins

This webinar is for you if you ever find yourself in a difficult emotional situation where a cool head is necessary. Th...

  • Oct 27, Monday | 08:12 PM EDT | 90 Mins

Nisi earum est dicta ab perspiciatis expedita sint. Sint voluptatem deserunt autem rerum quia possimus ea asperiores. Fa...

By