Elephants, slices and exporting data

by Jana Gombitova

How do you eat an elephant?

Above: Elephant wall mural photographed by Ben Kerckx.

I was three weeks into my Akvo life when my colleague Emmanuel turned to me and asked: “Jana, how do you eat an elephant?” At the time, I didn’t think much of it beyond the general saying, but it turned out to be one of the guiding principles behind how we improve Akvo Flow. We’ve also used it as an approach to tackling one big opportunity this year: improving how data captured in Flow is exported.

So, how do you eat an elephant?  

Understand your elephant

First, you need to understand the elephant you are dealing with: its size, shape and what it is made of. From our research and user feedback, we knew that improving exports could not be done with one small fix. This is a full grown elephant we are dealing with. Improving exports involves multiple questions, problems, and opportunities. Here are a few pieces of this elephant, just to paint the picture:
Read More »

WPDx – Improving water service through evidence-based decision making

by Emily Armanetti


In 2014, Global Water Challenge, a coalition of corporations and NGOs working to solve the world’s water challenges, established a working group of experts in the water sector to advance water, sanitation and hygiene (WASH) sustainability by improving water data point sharing.

At the time, The Water Institute at UNC estimated that 1.8 billion people lacked access to safe water. Although teams of people work around the world to improve water and sanitation services and to collect data on water point functionality, existing water points don’t always function properly and old ways of doing things meant that water point data was often used only once, then locked away in file cabinets or on servers and proprietary systems. The working group set out to change this by establishing a framework for sharing data, ultimately improving WASH sustainability.
Read More »

Get your data flowing with Akvo Flow’s API

by Jana Gombitova

Akvo Flow API

Above: Connection at the Stedelijk Museum in Amsterdam. Photograph by Ruud van der Werf, 2014.
You capture data. Actually, you capture a lot of data. This month we celebrated a great milestone in Akvo Flow: over 5 million forms have been submitted with our tool. But what happens after you hit the submit button? How can you get the data out, understand it and make value of it? Besides Flow’s frequently used view data and data exports functionality, or the newly introduced direct link between Flow and Lumen, you can use Flow’s API.

Read More »

Highlights of the DGIS Akvo partnership (PPP3, 2014-2017)

by Charlotte Soedjak

DGIS Akvo partnership

Above: The various phases of the partnership between Akvo and DGIS.


Since 2008, the Dutch Ministry of Foreign Affairs (DGIS) and Akvo have been involved a public private partnership (PPP), focused on practical innovations in the international WASH sector. In particular, we have been targeting challenges around knowledge management, transparency, data sharing, monitoring and reporting. Building on pilots in earlier DGIS and Akvo partnerships (PPP1 and PPP2), which aimed to improve WASH related project reporting and mobile-based data collection, this partnership is concentrated on scaling-up efforts to support data collection and monitoring initiatives at national and regional scale. In this blog, I’d like to highlight some of the many activities that were either kick-started with the support of PPP3, or resulted as a spin-off. 

Read More »

Five key lessons from Water Point Mapping in Liberia

by Geert Soet

Above: The Great wall of China Hotel, Monrovia. Photo by Geert Soet

Arriving at Liberia’s Roberts International airport with a small suitcase and my passport, the rain was pouring down on Africa’s first republic. For the people that do know the country by name, it will most likely remind them of the long-running and ruinous civil war in the 1990s or the recent ebola crisis. 

With those thoughts in the back of my mind, I was not too happy with the fact that I did not possess a visa and only brought a copy of an invitation letter with me. But once again, it was made clear to me that you have to experience countries and their people first hand. In my imagination, the immigration manager was surly. In reality, he escorted me to the taxi rank with his own umbrella. When the ATM ate my card, it was no problem at all to pay later.

All in all, it was the start of an interesting week! My task was to guide the process of data cleaning for the 2017 Water Point Mapping in Liberia, led by the Ministry of Public Works and the Liberia WaSH consortium. Below you’ll find a list of the five most important lessons we took from this experience.

Read More »

A new look and feel for Akvo RSR results framework

by Anthony Gonzalez

We’re really excited to release a new design for Akvo RSR’s results framework that is cleaner and easier to navigate. Besides the new design, we’ve also made it easier to update indicator results data and to manage the approval flow for indicator updates.

What’s new? 

  • A streamlined, more user-friendly design.
  • An approval flow for indicator updates: this flow allows field officers to access indicators that need updating quickly and easily. It also allows monitor and evaluation (M&E) staff and project managers to view indicator updates that are pending approval or have already been approved. 
  • A bulk actions filter: this allows you to swiftly lock and unlock indicator reporting periods. It also lets you filter indicator reporting periods so that you can easily find a specific period. 
  • Indicator updates can no longer be made via the project editor. 
Read More »

Unboxing Marcomms

by Linda Leunissen

Over the last week and a half the Akvo Marketing and Communications (Marcomms) team has onboarded two new team members. Admittedly, that doesn’t sound like a big deal, but in reality it means our existing team of two doubled in size. It’s a 100% increase.

Alvaro has been part of our team for three years. I myself have been with Akvo for more than five years. We both got introduced to fully function teams, who took us on board and showed us the ropes. The way Akvo does Marcomms is different than any other organisation either of us worked for, and learning from our co-workers in a well functioning team was invaluable in changing the way we approached things.

Today we find ourselves in a very different situation. Two weeks ago our team consisted of Alvaro and me but now we’ve added two new people to this micro team. We thought long and hard about how to go about the onboarding process. Of course we’re excited to have our new colleagues Georgia and Laura on board, but it does pose some questions: How do we keep the spirit in which we’ve worked the last five years going, but also leave room for this new team to create it’s own patterns? And how do we make sure we keep using our method of discoverable communications, while also creating an identity, style and way of working as a new team that we all feel ownership of? It’s important our new colleagues feel like they are part of shaping the way we work, but it’s also important to have continuity.
Read More »

Impressions of Stockholm World Water Week 2017 (Akvo’s eleventh)

by Alvaro de Salvo

Stockholm World Water Week

Above: The Akvo stand in full swing. Photo by Alvaro de Salvo

Last week, a handful of us attended one of the biggest congregations worldwide dealing with water related issues. Organised by SIWI, Stockholm World Water Week (#WWWeek) took place in Sweden’s capital between Sunday 27 August and Friday 1 September. It was Akvo’s eleventh time at this event and my second

Akvo was conceived at SWWW in 2006, and we’ve been back every year since, often with the intention to disrupt the sector into becoming more data driven. At Akvo, we believe that the sector needs to embrace digitalisation and become more open, effective, and efficient. 

As you’re probably aware, #WWWeek is the annual meeting point of many of the world’s water sector entities and experts: government bodies, NGOs, funders and investors, private utilities, corporations, consultants, scientists, engineers and observers. We’ve been actively bridging the water sector with technology, and done the best we can to continuously poke it. This year hasn’t been any different. Read More »

The Team, The Team, The Team

by Henry Jewell


After five incredible years, the time has come for me to leave Akvo. It has been a privilege to work with all the people that I have interacted with through this journey, all of whom are passionate about being a positive force for change in the world.

It is nearly fall in Ann Arbor, Michigan (the town I call home), and that means one thing, and one thing only –  it is football season. One speech, above all others, is synonymous with the University of Michigan football team, Bo Schembechler’s 1983 “The Team, The Team, The Team” address. An excerpt of this speech that I find very emotive is:

“The Team, The Team, The Team, and if we think that way, all of us, everything that you do, you take into consideration what effect does it have on my Team?”
How do we define the team we work on? Is it our immediate colleagues that sit next to us? Our colleagues from different locations? Our partners?  Or even the community in which we operate? No single organization can solve the large social challenges that the international development sector is facing; collectively we can achieve a lot more. Within the sector we are good at talking about collaboration but in practice this normally occurs at a superficial level, which does not allow for a fundamental change in the way we work together.
Read More »

Fake news and my summer internship

by Edgar Aguilar

Above: At the Open Gov Hub in Washington, D.C. Photo by Ethel Méndez Castillo.

This year has been really eye opening to me and I am sure the same holds true for many others. I started to realize that “fake news” and “alternative truths” are pervasive, particularly on the Internet, and this has made me more skeptical of what I see on my Facebook feed. But how do we find more truth in the information we consume? My unexpected summer internship just helped me to start answering that question to myself: we collect good data that we then understand and share openly.

My plans for the summer were not necessarily to work at an international organization that “creates open source, internet and mobile software and sensors” in order to make “international development and country governance more effective, transparent and collaborative.” I’d had no plans to come to Washington, D.C. and I had never heard of Akvo Foundation or the Open Gov Hub. I just knew about all the poor decisions and ineffective results achieved by governments and organizations around the world caused by the lack of access to good and real information. Honestly, I had never really thought about ways in which people could be working to improve the data used in decision-making and measuring results. However, one week changed all of this, and I had to move to DC for a summer internship at Akvo Foundation USA. It was through this internship that I found out that some people are working to integrate technology into the monitoring of development processes.
Read More »