Structured qualitative evidence database across interviews, focus groups, KIIs, and desk review
Back to Case Studies
Situation Analysis Recovery for a UNICEF Report Project in Palestine
I rebuilt the evidence workflow for the primary contractor on a delayed UNICEF report project in Palestine and helped deliver a draft report within three weeks.
A primary contractor on a delayed UNICEF report project in Palestine needed a defensible evidence workflow fast enough to recover the delivery window. I rebuilt the evidence base, organised qualitative material for retrieval, and supported analysis and drafting in parallel so the team could deliver a UNICEF-ready draft on 8 March 2026.
What this project delivered
Coded analysis sheets for service access, quotes, geography, and theory-of-change themes
Retrieval workflow for faster drafting and review
Recommendation matrix and action-planning inputs tied to the evidence base
UNICEF-ready draft report dated 8 March 2026
Three-week recovery window
Draft delivered on 8 March 2026
Evidence database, coded analysis sheets, recommendation matrix, UNICEF-ready draft report
Recovered a delayed situation analysis and delivered a UNICEF-ready draft within three weeks.
Project overview
The problem
A primary contractor on a UNICEF report project in Palestine needed to recover a delayed situation analysis fast enough to salvage the delivery window. Raw qualitative material was scattered across interviews, notes, spreadsheets, and draft sections, yet the final report still had to meet UNICEF expectations on methodology, ethics, safeguarding, limitations, and evidence-linked recommendations. The team needed a system that could organise evidence for retrieval, analysis, and drafting at the same time, not a slower workflow that forced writing to wait for full manual review.
Context
The project ran in the last two weeks of February and the first week of March 2026. The final draft report is a UNICEF situation assessment on access to essential services for children and young people with disabilities in Gaza, the West Bank, and East Jerusalem, with chapters on methods, context, legal and policy frameworks, services, coordination, governance, cross-cutting issues, analysis, lessons learnt, recommendations, and annexes.
Constraints
The assignment had very little time left and the raw material could not stay scattered across interviews, notes, spreadsheets, and draft sections. The team needed a fast way to retrieve evidence by geography, respondent type, service area, and theory-of-change theme while keeping a clear line from source material to findings and recommendations.
What the team needed
- A clear evidence structure that could turn raw qualitative material into report-ready records fast
- A way to compare lived experience, service issues, and system-level findings across Gaza, the West Bank, and East Jerusalem
- A traceable workflow linking quotes, coded issues, theory-of-change themes, and report sections
- Drafting support that could move analysis and writing at the same time instead of waiting for full manual review
- Recommendations and action points grounded in coded evidence rather than loose notes
Build
What I built
A structured qualitative evidence database, retrieval workflow, recommendation matrix, and UNICEF-ready draft report.
Named systems and workflow pieces
- A structured qualitative evidence database with linked source, participant, coded evidence, service-access, quote, and theory-of-change layers
- AI-assisted organisation and retrieval support for faster review and drafting
- Evidence extraction and synthesis across interview, focus group, key informant, and desk-review material
- Drafted and shaped report sections in line with UNICEF report logic
- Recommendation support and action-planning inputs tied back to the evidence base
- A workflow that let the team draft from organised evidence rather than raw transcripts
Where this connects to the services
This delivery combined database architecture for evidence workflows, custom AI retrieval systems, data synthesis services, and report writing systems in one working stack so the team could move from raw submissions into drafting and live review without losing the route back to source material.
Visual proof
The recovery workflow moved evidence and drafting in parallel
The build organised scattered qualitative material into a retrieval-ready structure so chapter drafting and recommendation work could move without waiting on a full manual clean-up first.
Organise
Collected interviews, notes, spreadsheets, and draft material into one working evidence base.
Code
Turned qualitative material into records that could be filtered by service area, geography, respondent type, and issue.
Retrieve
Linked quotes, service-access patterns, and theory-of-change themes so the team could pull evidence quickly during drafting.
Draft
Used the organised evidence to shape chapter-ready findings, recommendations, and the final UNICEF-ready draft.
Interview or note to coded record to chapter-ready finding to draft report and recommendation
Execution
How it worked
The workflow moved from raw material to usable output through a short sequence of controlled steps.
Process
- 01
Collected and organised raw material into one working evidence base instead of separate files and notes
- 02
Broke qualitative material into coded records that could be filtered by service area, geography, respondent group, and issue type
- 03
Linked quotes and excerpts to service-access patterns and theory-of-change themes for traceable use in drafting
- 04
Built retrieval paths that reduced repeated transcript reading and manual searching
- 05
Synthesised the coded material into chapter-ready findings, comparisons, and recommendation inputs
- 06
Worked in parallel on evidence handling and report writing so the draft could be completed inside the recovery window
Deliverables
Outputs
These were the named assets, dated deliverables, and working materials left behind by the project.
Working outputs
- Qualitative evidence database with 59 source records
- Structured analysis sheets for adolescents, caregivers, KIIs, service access, quotes, and theory-of-change evidence
- 494 service-access entries
- 924 coded quotes and excerpts
- 651 theory-of-change evidence entries
- UNICEF draft report dated 8 March 2026
- Recommendation matrix and action-planning material
Outcome
Result
Recovered a delayed situation analysis and delivered a UNICEF-ready draft within three weeks.
Main result
- Recovered a delayed project and got it back into a workable delivery rhythm
- Completed a UNICEF-ready draft inside a three-week turnaround
- Made evidence retrieval much faster for drafting and review
- Reduced repeated manual reading of transcripts and notes
- Gave the contractor a clearer line from source material to findings and recommendations
When time is short, the real time saver is not faster writing. It is building the evidence system early enough that analysis and drafting can move side by side.
Qualification
Best fit
These are the situations where this kind of evidence workflow tends to be the strongest fit.
Who this is best for
- Deadline-recovery projects where analysis and drafting need to move in parallel
- Situation analyses or assessments built from messy qualitative material
- Teams that need evidence retrieval by geography, respondent type, and service area
- Assignments where recommendations must stay visibly tied to coded evidence
- Research and contractor teams under review pressure, not just writing pressure
Relevant services
Service stack connected to this case study
This case study sits inside the same delivery work, service logic, and practical outcomes shown across the site.
Database Architecture
Design practical database systems so information can be captured, organised, and used more effectively.
Custom AI Building
Build custom AI knowledge bases and tools around your own data environment.
Data Synthesis
Combine and interpret inputs from multiple sources into integrated findings.
Report Writing
Develop clear, structured outputs from evidence, data, and synthesised information.
Insight Generation
Turn raw data and synthesis into practical insights for decisions, planning, and strategy.
Similar case studies
Similar case studies
These are the closest delivery examples on the site, based on the same service mix, adjacent workflow logic, or a very similar problem shape.
Let's talk
Need a similar workflow?
If your team is dealing with the same kind of information, reporting, or evidence bottleneck, send a short brief and I can assess fit quickly.