How better data can help Calgary non-profits meet surging demand for services
Athabasca University project helps Calgary not-for-profits get handle on client data amid surging demand for services
An Athabasca University researcher is harnessing the power of cloud technology to help not-for-profits in Calgary modernize their data collection and improve their chances of securing critical grant funding.
Dr. Kharah Ross, a health psychologist in the Faculty of Humanities and Social Sciences, worked with IDEA Lab, AU’s virtual research platform, to create a new database for Elizabeth House, a Calgary transitional home for vulnerable women and children. The small organization has about half a dozen staff who deliver 24/7 support to clients at its shelter and in the community.
Until recently, Elizabeth House had been storing 25 years worth of client data in filing cabinets. That made it all but impossible to easily understand who was accessing services and when, or what supports had been offered previously—data that is critical for grant funding applications. Meanwhile, commercial data management tools are too expensive for non-profit agencies operating on less than $100,000 a year, explained Ross.
They don't have the money to do this, and the risk is they’re going to be left behind. That is unacceptable. Dr. Kharah Ross, health psychologist, Faculty of Humanities and Social Sciences
Ross used REDCap, a virtual data management tool, to create a prototype database management system for Elizabeth House. Thanks to the success of that initial pilot project, she secured funding from the Calgary Foundation and, more recently, from the Social Sciences and Humanities Research Council (SSHRC) to expand the work. Now, she’s collaborating with PolicyWise to help three other Calgary non-profits—Community LAMDA Society, Emma House, and Highbanks Society—modernize with a data management system.
Research that connects to community need
Ross often works with community agencies on research projects in the area of maternal-child health. Too often, she said, she’s seen agencies struggle through an inability to collect or analyze data. She felt compelled to help and has done some early work with Elizabeth House and others to understand their data needs.
“In my field, there’s more and more emphasis on needing to get out of the ivory tower—you need to be doing work that can translate into real-world implications. I’ve been trying to do that.”
With only seven rooms, Elizabeth House sees “modest” numbers of clients compared to other shelters, explained executive director Michelle Haywood. But the agency still gets about 100 phone calls a year from women seeking shelter.
“Having good data and information that’s easily accessible means greater efficiencies—and hopefully, greater effectiveness in the work that we’re doing, which is client focused,” Haywood said.
Data critical to accessing grant funding
Without that data, it’s also hard for organizations like Elizabeth House to show their impact—which is increasingly critical for accessing funding support, Haywood added. Elizabeth House is a non-denominational charity run by the Roman Catholic Diocese of Calgary, however most of its funding comes from individual donations, not from larger organizations, she said.
Because we’re small, I can’t say we served hundreds of people last year. Funders want to hear those numbers. That’s why data matters.
Since the pandemic, Elizabeth House and other charities have seen a surge in demand for services, fuelled by rising inflation, domestic violence rates, and Calgary’s affordable housing crisis. Haywood said the organization has done what it can to help, including extending residency limits for women and children, but there are limits without more funding.
“We are meant to be transitional. It’s not a forever home. But we’re also realizing the landscape has changed.”
Though a database might seem like a small solution to such a big problem, the ability to scale up could mean helping countless other organizations, Ross said. In fact, she recently finished designs on an affordable, and easy-to-adapt data management system. Future plans include interviewing agency employees to better understand if the system meets their needs, and then applying for additional funding to assess scalability and sustainability.
“Researchers do this work all the time. If we can figure it out, we should.”
