Foundations of OR: 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
- Foundations of OR: Optimisation and (Meta-) Heuristics
- Foundations of OR: Statistical Methods in OR: Multivariate Statistics
- Foundations of OR: Follow on to Forecasting: ARIMA modelling for forecasting