Moving Beyond the Busywork of Manual Data Management
Raising The Village partners with households and villages to create time, space and opportunity to focus on improving their overall quality of life and work toward their future. Similarly, Alteryx frees up more time for the nonprofit’s staff to spend advancing sustainable development instead of chasing after data. Tasks such as building the nonprofit’s quarterly master scorecard of project goals and outcomes — which used to be two people’s full-time job — now take just minutes in Alteryx.
“Before, we had to do a lot on manual data entry, formatting, and cleaning in Excel spreadsheets,” says Cheung. “With the amount of correction involved just in preparing our scorecard, we weren’t spending enough time running our regressions or analysis of the key relationships between different pieces of information.”
For example, assessing whether the average attendance at training sessions on sustainable farming sessions in different villages influenced their crop yields the following season was a challenge. “We were losing valuable time in processing the analysis,” he says.
Then Cheung learned that Raising The Village could receive a free Alteryx license as part of the Alteryx for Good program. Created to help nonprofits accelerate their missions and amplify their positive impacts through more intelligent, data-driven decision making, Alteryx for Good helped Raising The Village launch its new analytics framework in late 2020.
“Suddenly, we gained so much space for our team to actually do what they're best at, which is analysis,” he says. “Alteryx software is equipping our project officers with real-time insights on the key drivers of success in a community. For us, that’s a major breakthrough — because we can immediately tell what we need to do, how do we need to change.”
A Clearer View of How Actions Drive Impact
Raising The Village tracks data on household income, employment, livestock assets, crop returns, and time spent on non-economic activities — such as fetching water and firewood — in more than 300 Ugandan villages at any given time. With only a small team of officers managing these remote initiatives, Alteryx provides crucial data-sharing visibility across various regions and project types.
Since launching the platform, “we’ve confirmed there’s a strong relationship between the number of women in leadership positions within a village and the acceleration of household incomes in the community,” says Cheung. “Sharing our findings on the value of gender equity with partner communities helps change perceptions. That’s one example of how these tools are enabling us to make informed decisions and maximize impact.”
Alteryx is also helping the nonprofit better understand and address the inverse relationship between villagers’ economic prosperity and the distance they travel each day to collect fresh water.
“That kind of insight helps us build a stronger case for investing in projects that improve people’s access to water, because we can clearly show how the time savings connects to ending ultra-poverty,” he says.