Case Study: Shelter improves reporting and near-real-time data with ANS and Microsoft Fabric

Shelter cuts data latency from 3–5 days to near real-time with ANS

ANS Group partnered with Shelter, a charity dedicated to defending the right to a safe home, to address significant data challenges. Shelter was struggling to manage numerous disparate data sources from its fundraising platforms, which prevented timely and accurate reporting. Supporter data took between three to five days to reach their CRM, and their reliance on 12-15 hour overnight processing windows restricted their ability to respond quickly to campaigns and events.

To solve this, ANS Group implemented Microsoft Fabric, creating a scalable data platform with a Lakehouse architecture that integrated with Shelter's existing Microsoft stack. This solution provided reliable, high-quality data and Power BI dashboards. As a result, ANS Group helped Shelter reduce data latency from days to near real-time, cut the onboarding of new data sources from months to two-week sprints, and eliminate the lengthy overnight processing windows, dramatically improving operational efficiency and decision-making.

Shelter