Business Intelligence can improve nonprofit and association decision making. Most of us are familiar with the scenario where we extract information from a variety of different systems that each serve their own purpose, but are not integrated. In recent years, there has been a push to integrate systems or to try to put everything into one multi-purpose system, like an AMS (Association Management System) or CRM (Customer Relationship Management). There are certainly benefits to this especially for the front-end users and customer service representatives. However, there are challenges as well. For example, it often will slow down a transactional system to store every email that was ever sent to a member. It may also be cost prohibitive to have a real-time integration between all of your systems.
DSK Solutions, Inc. received Avectra’s AUDC 2013 Innovation Award for an outstanding business intelligence (BI) project created for the Association for Financial Professionals (AFP). AFP’s sister company gtnews needed to meet contractual obligations for reporting statistics to sponsors. AFP’s Director of Data Research, Galina Kozachenko, envisioned a BI solution and turned to long time collaborators DSK to execute and enhance the project. DSK created new data marts and developed C# applications to manage the separate data sources. They recommended Tableau software to build dashboards and reports with superior data visualization capabilities.