Data-driven PowerApps and Power BI solutions helped Palmera deliver targeted food security support to over 20,000 people.

Palmera is a not-for-profit organisation that works to ensure vulnerable families in Sri Lanka are economically empowered so they can prosper, make informed decisions about their livelihoods, and better care for themselves and their children.
During the COVID curfews and the subsequent economic crisis, Palmera needed to capture, store and analyse thousands of data points on each familyxe2x80x99s food needs in order to design effective, targeted interventions. Their reliance on traditional data management methods was error-prone, difficult to scale, and often out of date.
Palmera needed to capture and act on thousands of data points on vulnerable families to deliver targeted food security support during Sri Lankaxe2x80x99s economic crisis and COVID curfews.
Traditional data storage and maintenance methods were error-prone, difficult to scale, and often out of date.
Capturing, analysing and reporting on thousands of family data points across remote regions was becoming unmanageable.
Field staff needed a tool simple enough for local teams with limited IT literacy to use with minimal training.
Delays in identifying and responding to at-risk families reduced the effectiveness of food security interventions.
Exigo Tech built a Microsoft Power Platform solution combining PowerApps for real-time field data capture with Power BI reporting for deep insight into community needs.
PowerApps on field devices let staff capture and synchronise family data in real time, giving instant access to up-to-date records.
An intuitive app with built-in data quality controls let local staff with limited IT literacy adopt the tool with minimal training.
A comprehensive suite of Power BI reports delivered deep insight into community needs, enabling more effective programme design.
Real-time data enabled Palmera to rapidly dispatch technical experts, microloans and support exactly where it was needed most.
PowerApps allows us to go beyond the blanket emergency solutions which can leave the most vulnerable out or without enough to bounce back out of poverty. With the support of village-based teams who monitor and collect this data, we can target our support, so that we direct our resources in the right way.