The fundraising division of a Canadian university was having issues building reports from their donor management system and needed assistance. Complex data structures from Raiser’s Edge made it difficult for them to build a foundation to move forward and adapt over time as the business changed and software updates took place. The client approached Imaginet to develop a new data warehouse and ETL solution to integrate better with Power BI and lay the groundwork for future updates.

While the Raiser’s Edge on-premises database was the primary data source, we used cloud resources like Azure Data Factory to orchestrate the data movements from the donor management system into the new warehouse. We produced a Power BI model to enable business users to easily create their own dashboards and reports, used Azure DevOps to track work items, and composed automated build and release mechanisms that the client could continue to use going forward. We offered additional training in Power BI and replicated existing reports to link the solution from beginning to end. We continue to provide ongoing mentoring and design advice, as well as demonstration videos to the client for training and coaching purposes.

In a short amount of time, Imaginet improved the client’s data structure, storage, and consumption, while increasing efficiency. Our thorough implementation and development processes enabled their team to learn as we completed the work, giving the client a better understanding of their data warehouse system and Power BI.

Thank you for taking the time to read this case study! We hope it provided valuable insights and inspiration for your own projects. If you enjoyed this content, be sure to check out our recent works for more case studies and blog posts on similar topics. Don’t forget to subscribe to our newsletter for the latest updates and exclusive content.