Data Envelopment Analysis

Gain an understanding of the ideas and concepts of efficiency assessment of organisations and how Data Envelopment Analysis (DEA) models can be formulated and applied using Excel Solver.

Description

  • Build your knowledge of Data Envelopment Analysis (DEA). An established non-parametric methodology used to assess efficiency, performance, and productivity of organisations. 
  • Gain an understanding of the ideas and concepts of efficiency assessment for organisations and how DEA models can be formulated and applied using Excel Solver.
  • Increase your analytical skills by being able to identify inefficiencies and benchmark organisations against the best performers.

Learning objectives

  • Learn about the main ideas and concepts of efficiency assessment of organisations
  • Discuss the main DEA models and contexts in which these could be applied
  • Formulate a DEA model and interpret the solution using Excel Solver
  • Identify the advantages and limitations of the DEA methodology
  • Learn how the results of DEA models could inform better decision and policy making.

Topics

  • Basic concepts of efficiency analysis
  • Performance measures, inputs and outputs
  • The main DEA models and their specification
  • The use of Excel Solver to solve DEA models
  • Interpretation of results in a way useful for decision makers
  • Addressing typical problems arising in applications of DEA

Audience

The course is designed for delegates with an interest in the measurement and management of organisational performance. No knowledge of this field is required. A prior knowledge of linear programming methodology would be helpful but is not essential, as this will be briefly covered in the course.

Course format

  • PowerPoint presentation to introduce the topics including illustrative examples from different sectors
  • Case studies based on ‘real world’ problems
  • Practical sessions using Microsoft Excel with the Solver tool pack
  • Group discussion/work to explore the topics in more detail
  • Bring questions from your own work to embed your learning
  • Supporting resource pack available to use following the course

Related courses

  • Optimisation and (Meta-) Heuristics
  • Statistical Methods in OR: Multivariate Statistics
  • Follow on to Forecasting: ARIMA modelling for forecasting

Prices 

  • OR Society Member £475 plus VAT
  • Non-Member £625 plus VAT 
  • For group booking discounts please contact [email protected]
When
13/11/2024 09:00 - 17:00
GMT Standard Time
Where
Online 09:00-17:00
Spots available
16
Registration
Sign in or create an account to register
Last day to register is 12/11/2024