How Data Analytics Transformed a Non-Profit’s Library Network Across Africa

Library network across East and West Africa

Executive Summary

A leading African youth education non-profit knew its school library program was changing lives, but lacked the rigorous data to prove it, scale it, or sustain donor confidence.

Adept Technologies designed and executed a comprehensive data audit and impact evaluation across 40 libraries in Kenya, Tanzania, and Ghana, analysing feedback from over 1,450 respondents using Excel, Python, and AI-assisted tools. The result: a programme that now reaches 57,000+ learners, has achieved full gender parity, and reports literacy scores of 81-83%, backed by interactive dashboards that have become central to the organisation's strategic planning and donor reporting.

Introduction

In many parts of sub-Saharan Africa, a well-stocked school library is not a given, it is a lifeline.

Our client is a non-profit organisation operating at the intersection of education, technology, and community development across East and West Africa. For over a decade, they have worked quietly but ambitiously to install fully equipped, turnkey libraries in under-resourced primary and secondary schools, pairing physical books with digital learning tools, trained librarians, and structured literacy programmes.

Their vision is straightforward and powerful: that every child, regardless of geography or income, should have access to the resources that unlock curiosity, critical thinking, and opportunity. By 2024, they had placed libraries in 40 schools across Kenya, Tanzania, and Ghana. Yet for all this momentum, there was a gap between what the organisation knew anecdotally and what it could demonstrate with evidence. Donors were asking harder questions. Programme managers needed sharper data to decide where to expand next. And the team had an instinct that gender access was uneven, but no data to confirm it, let alone act on it.

The Solution, Adept's Approach: A Structured, End-to-End Data Operation

Adept Technologies was engaged to design and execute a full data audit and impact evaluation framework. The engagement ran from June 2024 and remains ongoing, with the first major phase covering 21 primary schools and 19 secondary schools across Kenya and Ghana.

Step 1 — Data Audit & Gap Analysis

Identifying what data existed, what was missing, and what was structurally unfit for analysis. This audit became the blueprint for everything that followed.

Step 2 — Questionnaire Design & Enumerator Training

Bespoke questionnaires tailored to four distinct respondent groups: students, teachers, librarians, and school administrators.

Step 3 — Field Data Collection from 1,450+ Respondents

Trained enumerators deployed across 40 library sites, gathering data from over 1,450 respondents — a sample large enough to be statistically meaningful.

Step 4 — Data Cleaning, Entry & Statistical Analysis

Excel, Python, and AI-assisted tools used for statistical modelling, cross-tabulation, and trend analysis, in compliance with data protection best practices.

Step 5 — Dashboard Development & Reporting

Two interactive dashboards and two detailed analytical reports were produced, becoming the organisation's primary tools for donor communication and strategic planning.

Qualitative Impact: What the Numbers Don't Fully Capture

Teachers reported that literacy resources which combined physical books with digital interactivity had the highest engagement. Librarians identified that student-led book clubs, an initiative that had grown organically, were a significant driver of the literacy score improvements. Perhaps most meaningfully, the gender parity finding did not merely confirm a problem, it catalysed a solution.

When the 3:1 ratio was surfaced, the organisation implemented targeted outreach and girl-friendly programming. Within 18 months, they had closed the gap entirely. The dashboards themselves produced an unexpected benefit: for the first time, school administrators could see how their library compared to others in the network. This healthy visibility created peer accountability and motivated schools with lower usage rates to improve.

Conclusion

This project is a demonstration of what becomes possible when rigorous data practice meets genuine mission.

The non-profit entered this engagement with a strong intuition that their libraries were changing lives. They leave it with something far more powerful: proof. Proof that can be shared with donors, presented to governments, and used to guide every future decision about where to build the next library, how to allocate resources, and which communities to prioritise.

For Adept Technologies, this is exactly the kind of work that defines our purpose, turning raw, scattered data into clear, actionable insight that drives meaningful change. Whether in education, health, development, or the private sector, the methodology is transferable. The outcomes speak for themselves.

Frequently Asked Questions