Supporting deep-level analytics through multiple sources

The OneSix 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, OneSix 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.