Problem – This health care non-profit struggled to develop strategic marketing initiatives based on existing donors and donor saturations of Iowa counties/cities.  They needed a solution that would mesh monthly donor/donation metrics with geo-location data and allow “what-if” analysis.

Solution – We created a Microsoft SSAS cube and automations that integrated with their existing blood donor system, extracted summary donor/donation information and allowed the Public Relations department to target their marketing efforts.  It would allow drill-down from the State down to the Zip code level allowing strategic planning.