Life-Saving Research, Transparent Funding
Life-Saving Research, Transparent Funding
- Context: Dutch kidney foundation De Nierstichting fights kidney disease through research, prevention, and patient advocacy without government subsidies.
- Challenge: Manual Excel reporting consumed massive effort while providing no cross-sectional analysis or measurement of donation effectiveness.
- Solution: All Your BI replaced static Excel tables with dynamic Power BI dashboards enabling real-time financial performance tracking.
- Result: Complete KPI visibility with drill-down capabilities to transaction level replaced time-consuming manual report production challenges.
- Impact: From spreadsheet struggles to strategic clarity—every donated euro now demonstrates measurable impact on kidney health missions.
De Nierstichting champions kidney health across the Netherlands, investing in groundbreaking research like wearable artificial kidneys while fighting for shorter transplant waiting lists. Operating without government subsidies, they depend entirely on societal support, making transparent demonstration of donation effectiveness essential for maintaining public trust and funding their life-saving work.
Challenge
Picture monthly reporting nightmares plaguing this vital nonprofit: producing financial reports required massive manual effort using non-formatted Excel tables with zero cross-sectional analysis capabilities. The underlying logic had vanished, creating recurring challenges meeting monthly deadlines while donors received no insight into how effectively their contributions advanced kidney health initiatives across research, prevention, and patient support programs.
Solution
All Your BI transformed their financial reporting architecture with comprehensive Power BI dashboards that provide real-time visibility into revenue distribution between frontline kidney programs and operational costs, enabling complete transparency for donors and stakeholders.
Team
Execution
We delivered integrated financial intelligence featuring real-time KPI dashboards showing revenue, costs, and program distribution alongside dynamic cost and revenue analysis with drill-down capabilities to individual transactions. The solution includes turnover analysis enabling trend comparisons across periods, campaign impact measurement, and innovative treemap visualizations that reveal spending structures while maintaining focus through selective display of clicked elements only.
Client
De Nierstichting, the Dutch kidney foundation advancing kidney health through research, prevention, and patient advocacy without government funding support.
Latest work
At AYBi, we cut through the noise to give meaning to data. It’s not about technology — it’s about real connection. With the ambition of true data wizards, we transform insights into action. Expect everything.