1. Collect — Think about all the data at your organization that you might care about—information about donors, transactions, ticket buyers, marketing campaigns, purchases at the gift shop, website visits, etc. This data is saved in multiple locations and in multiple formats—some on local servers in SQL, some in the Cloud in Oracle, and some on individual computers in Excel. Identifying and collecting this disparate data is the first step. The goal is to copy and standardize the needed data into a central location—commonly referred to as a data warehouse.
The Challenge — Each system has proprietary database and table structures that must be deciphered to map each field to your data warehouse. Some vendors publish their data schema while others can only be found by reverse engineering. Do you have the resources to identify and map the data warehouse?
2. Organize — The next step is to organize the data in a way that makes reporting easy. This might mean matching records across systems, simplifying multiple tables into flat files, consolidating records, joining tables from different systems, or other steps to make easy reporting possible.
The Challenge — Merging tables and data elements into a logical structure requires deep knowledge of not only the originating software but also understanding the business reporting needs of executive management. Does your organization have the skill sets necessary—and time available—to dedicate to the project?
3. Analyze — Data warehouses themselves are not the visible end-product—they are just the storage of data from which we take useful snippets of information to discover something new. This mass of organized data can now be twisted and turned to find meaningful patterns or interesting trends. This is where you have the “ah-ha” moment that can set your organization apart—the Intelligence part of BI.
The Challenge — The most beautifully designed data warehouse means nothing if you do not have the data tools and expertise to answer the questions you need. Can you easily drill down and make sense of the data as needed without requiring technical skills or manual manipulation?
4. Present —"A boring data table is worth a thousand words" said no one ever. Your executives and board need to quickly see the results of the analysis. No matter how obvious it may seem to you—can you convey the information in a thought-provoking, yet easy to grasp manner?
The Challenge — Charts and graphs make powerful visualizations but do you have the tools to answer the next question? Can you easily drill into the data to uncover the root cause of the change? If your BI tools require you to tell your boss "I will have to do more analysis and get back with you" then you have lost.
Business Intelligence solutions can be complex and many nonprofits with limited resources may think a robust solution is out of reach. When considering BI tools, successful nonprofits should:
- Find a BI solution that can identify and collect the data needed for your data warehouse with pre-configured mapping to The Raiser's Edge and ticketing systems like Gateway Galaxy and Siriusware.
- Find a BI solution that understands how nonprofits use data and has the structure already built to organize critical fundraising data.
- Find a BI solution that allows non-technical users to analyze data to create their own dashboards with dynamic visualization—and the ability to drill all the way down to the individual record.
- Find a BI solution that presents the intelligent analytics in a format that allows all levels of the organization to understand—and to get Answers to their questions.
What is JCA's BI solution for nonprofits? JCA Answers is a Business Intelligence suite built from the ground up for nonprofits. Answers has a comprehensive data warehouse under the hood and stunning dashboards with dynamic visualizations and charts that can be accessed from your desktop, tablet, or phone. JCA Answers will help you visualize the most important metrics for your business and present them in a format that will provide your audience with actionable insights. JCA Answers comes pre-configured for use with The Raiser's Edge, Gateway Galaxy, and Siriusware.
When your organization has questions about donors, members, and attendees—JCA has the Answers.
Learn More About Answers