Translate with Google Translate

The use of Data Envelopment Analysis to calculate priority scores in needs assessments


Web link

About this resource

Resource type:Tools, guidelines and methodologies
Keywords:Evaluation-related, Needs assessment, Research methodology, Targeting, Identification and Profiling
Countries:Philippines, Syria
Agency:ACAPS - The Assessment Capacities Project
Author(s):Benini, A.
Date published:July 2015

This note introduces the concept and use of a scoring method called "Data Envelopment Analysis" (DEA) method as a tool for identifying humanitarian priorities (i.e. affected communities, geographical areas or sectors), using examples from Syria and Philippines.

In humanitarian action, "setting priorities is part of strategic response planning" (UNOCHA 2014). This is a difficult task. Numerous tools have been developed to aid it, but a universally suitable algorithm to establish priority indices has not been established.
This note introduces a method known as Data Envelopment Analysis (DEA) as a tool for computing priority measures for affected communities, sites or social groups. It is attractive because it circumvents some of the issues in classic index formation altogether. It avoids pre-defined indicator normalisation, weights and aggregation functions in favor of data-driven parameters. It is attractive also because a freeware application is available that works closely with MS Excel, the workhorse of humanitarian data analysis.

In addition to the technical note, demo workbooks are available here.

Related resources


Before you download this file, please answer two questions to help us monitor usage

1) What do you think you'll use this document for?

  • Other:

1) What is your email address?

2) What is the name of your organisation?

Please answer both questions above Submit

Starting your download...

Pilot version: You are downloading the pilot version of this guide; we welcome any feedback you have. Please email

Close this overlay