He estimates that the Alteryx APA Platform saves OzHarvest colleagues at least 10 hours a week on manual data management tasks. The nonprofit’s reporting is also more comprehensive and reliable, thanks to improved data cleansing and visualization capabilities.
Even better, says Douglas, the software requires almost no programming expertise to use. “Because it’s a drag-and-drop platform, I was able to start pulling and combining data from various sources almost immediately,” he says. “Alteryx has allowed me to add new skills and play a more integral role in our mission.”
Reliable stats on reach and impact unlock funding support
OzHarvest saw immediate benefits from being able to show current and prospective donors how their support helps feed people in need in local communities.
“As our CEO is walking into a media interview or a speaking engagement, she can say, ‘We have delivered this many meals and rescued this many kilos of food from landfill’ in as close to real time as possible,” Miller says. “Also, for the food outlets and other business partners that we work with, our ability to share accurate and consistent numbers that show the impact of their donations is crucial in strengthening those relationships.”
After the COVID-19 pandemic exploded in March 2020, OzHarvest lost major sources of revenue due to cancelling its flagship fundraiser and other events. As a result, OzHarvest had to rely more heavily on government funding. And as more than 800,000 Australians lost their jobs within three months, the nonprofit also faced a spiking demand for relief.
“When we apply for a grant, the government or organization wants to understand how many people we will support in that specific geographic area and among specific demographic groups,” Miller says.
Because the Alteryx data aggregation and filtering tools enable OzHarvest to pinpoint its impact by neighborhood, answering such questions is simple.
“We are very successful at targeting our pitches to the federal, state and local governments,” he says. “We can show them that, ‘If you give us this amount of money, we can reach this number of people.’”