Case Study: Modernization of the CALP Database for Alberta Non-Profits
For nearly a decade, the Community Learning Network (CALP) portal has steadily evolved to meet changing province of Alberta data reporting needs and operational realities. While these incremental updates helped address immediate requirements, they also introduced growing complexity behind the scenes.
By 2024, it was clear that a more comprehensive update was needed. Rebuilding CALP's database & infrastructure was performed on the enterprise-level Members Village Nation Builder tier to improve usability, strengthen data integrity, and support a wide range of use cases.
Why This Project Was Necessary
The CALP portal supports close to 100 organizations, each with different programs, users, and reporting demands. Over time a series of small software enhancements lead to:
- Reactionary system structures
- Short-term changes made maintenance more difficult and costly
- Data entry and review took longer than necessary
- The UI no longer reflected how users evolved
Rather than continuing with small changes on top of an aging structure, we proposed an overhaul to address the underlying design and processes. The goal was to saves time in the long run, enhance use cases, and provide stronger data guardrails.
What Changed at a High Level
The update focuses on a cleaner, more intentional user experience (UX), with improvements focused on both efficiency and clarity:
- UI improvements which require less time for common tasks
- Process improvements with purpose-built workflows
- Separation of functionality based on user roles and use cases
- Guardrails within tools to prevent unintended data changes
These changes were designed to improve today’s experience and make future updates easier and more sustainable.
Historical Data: Fully Preserved
A critical requirement of this project was protecting historical database data. All existing data across previous reporting cycles was transformed as part of the update with zero data loss.
Historical cycles remain intact and unchanged. Users can continue to access their data with confidence, knowing that reports and records from earlier years reflect exactly what was originally submitted. This separation between past and future cycles ensures continuity while allowing the system to evolve.
A New Structure
For CALP the ability to get a snapshot of a contact along with their full history has been improved. This ensures non-profit administrators spend less time hunting for relevant data and more time focusing on their mission.
CALP's Program Offerings now hold high-level information for a reporting cycle, such as programming area and program category.
This approach reduces repetitive data entry and eliminates the risk of accidental changes to previous years’ information.
Reporting Improvements
The final report has been replaced with Excel exports, giving admins more control over how they access, analyze and submit their data to the province of Alberta.
Administrators can now:
- Access predefined exports for common reporting needs
- Perform ad-hoc searching and filtering
- Export exactly the data they need, when they need it
More flexibility to work with and control their database in ways that match internal processes, rather than being constrained by a single rigid report format.
Long-term Benefits
For the Alberta non-profits relying on the CALP portal, these database upgrades translate into meaningful daily benefits such as:
- Less time spent entering and reviewing data
- Fewer workarounds and manual adjustments
- Better integration with website builder (CMS)
- Improved confidence in data accuracy
- Better support for complex use cases
- Enhanced security of data including Canadian data residency
Just as importantly, the updated foundation allows the portal to adapt more easily to future requirements without disrupting existing data.
Does this case study sound like the answer to your database portal issues? Request a no-obligation software fit call and personalized demo.