Keeping constituent data aligned across systems is hard—especially when your school’s fundraising data lives in Raiser’s Edge NXT® and your student information lives in Education Management. In this session, you’ll learn how to use Power BI, Blackbaud SKY API, Power Automate, SharePoint, and Google Apps Script to continuously compare key records across both databases and surface mismatches before they become bigger problems.

We’ll walk through a real implementation that powers three dashboards—Current Parents, Current Students, and Faculty/Staff—built specifically to validate that the “same person” is represented consistently across systems.

You’ll leave with a repeatable approach for pulling data, automating refreshes, and creating a reliable reconciliation view that helps your team trust what they see (and act on it) across platforms.