Data envelopment analysis (DEA) is a technique that was developed to measure the multiple dimensions of performance (efficiency) of producing units. DEA allows the use of various inputs and outputs to build a single efficiency score to measure the comparative efficiency (performance) of hospital units, physicians, or group practices. Comparing the units’ efficiency can be formulated as a linear optimization problem that can easily be solved using the Excel Add-in solver. DEA is being used to compare a group of units to identify relatively inefficient ones, identify the magnitude of the inefficiencies, and, by comparing the inefficient with the efficient ones, suggest the targets to reduce those inefficiencies. The Excel spreadsheet templates are provided to illustrate all presented examples.
WHY SHOULD YOU ATTEND?
While one could find rich literature on various aspects of data envelopment analysis (DEA), it is typically presented as an academic mathematical development in the area of linear optimization which is challenging to apply in practice.
One should attend this webinar because it is focused on examples from actual 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 measures are taken from real hospital projects rather than presenting just academic exercises.
AREA COVERED
- 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 an explanation of the spreadsheet setup:
- 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) - Strengths and limitations of DEA
- Available free DEA software
WHO WILL BENEFIT?
Nursing Managers, Chief Nursing Officers, Directors, and VP of quality and operations improvements of healthcare organizations
Comments