DATA LAKES AND WAREHOUSES – NONPROFIT

Nonprofit builds an analytics-ready Data Warehouse

Overview

Analytics can be a major boon for nonprofit organizations.

These give them insight into everything from their internal operations to donor behavior. To capitalize on that opportunity, nonprofits need Data Warehouse solutions that can support advanced analytics capabilities through a single, centralized environment.

Our nonprofit client recently came to One Six Solutions looking for help building precisely that kind of Data Warehouse to enhance donor engagement and increase donations. Here’s what happened:

Nonprofits need data warehouse solutions that can support advanced analytics capabilities through a single, centralized environment.

Qlik logo full background
Microsoft SQL logo full color
Our Solution

Supporting deep-level analytics through multiple sources

The One Six team got started by mapping out a thorough assessment of the project’s initiatives and goals, and what would be needed to meet them. We also worked with the nonprofit to outline important KPIs and metrics that the solution would capture as well as helped select a business intelligence platform that met the organization’s requirements.

The technology roadmap we laid out involved an iterative implementation, providing incremental business value over a period of four weeks, without disrupting core operations.

Our team used SQL Server as the primary platform to build out the new Data Warehouse solution. We also took advantage of SSIS for ETL to integrate a wide variety of data sources with the analytics platform, including:

  • Call center systems.
  • Google Analytics.
  • CRM platforms.
  • Third-party data providers.

In this way, our client could bring in as much valuable data as possible to feed into its analytics projects and glean more insight into donor relationships. In addition, One Six developers built data visualizations and executive dashboards through Qlik Sense to help our client’s analytics team share their findings with non-technical users and key decision-makers.

Qlik Sense was the data visualization layer leveraged by the larger business team to support standard dashboards and ad-hoc analytics

Data from various ERP systems was integrated with SSIS for ETL

A SQL Server Data Warehouse provided reliable storage for both raw and aggregated data

Reporting services used to provide standard distributed reports to end users email inboxes by way of data driven subscriptions

The Results

Thanks to this new and improved Data Warehouse environment, our client can now analyze donor behavior and activity across multiple channels and product lines. The organization has already begun to better understand how that activity – whether it’s online or offline – directly correlates with nonprofit revenue and donations.