This project resolved a critical data crisis for a Danish NGO following a CRM migration resulting in broken data processes. By eliminating manual "black box" processes, I restored transparency and turned declining donation trends into measurable growth.
Following a CRM migration, a Danish NGO was left with fragmented data sources and obsolete SQL processes. Without technical support for their legacy systems, they relied on manual Excel workflows. This lack of transparency resulted in a "black box" environment where reporting was impossible, leading to a documented drop in donation volume.
To ensure long-term internal ownership, I bypassed the need for complex SQL maintenance by building an agile, end-to-end Power BI solution connected directly to Microsoft Dataverse. I embedded all ETL logic within Power Query, creating a "Single Source of Truth" that unified their data foundation. I designed the final dashboards with a heavy focus on UX, ensuring that prioritized insights were accessible to non-technical stakeholders.
.png)
