|
|
After merging databases and converting to Raiser's Edge®, Stamford Health Foundation employed JCA's experienced programming staff to clean and de-dupe the data. They said, "We couldn’t even begin to envision doing this consolidation and cleanup without them."
|
Are you spending too much time creating queries or reports, or ensuring that the data from one system matches another?
JCA can make these processes run smoothly and quickly by analyzing and cleaning the codes in your database.
Database codes need to be structured properly. Once these codes are in place, the database becomes a reliable resource for the organization and a powerful marketing tool.
JCA can help an organization analyze the efficiency of its codes, consolidate redundancies and in general, “clean up” the database. JCA can work with a customized system, as well as the multitude of database systems, including Raiser's Edge®, DonorPerfect, or PledgeMaker. With a decade of experience in many types of organizations, JCA can offer fresh, objective insight.
JCA can also review your organization’s reporting requirements to determine the best coding structure for the new system’s data. Analogous to building a house, the codes are the foundation of the fundraising system. Once the proper coding structure is in place, additional data can be stored in a logical and intuitive manner. This type of planning has a number of benefits including:
- Reduced staff training time/costs
- More accurate data: when files are ‘de-duped’ and merged into one system, the need to cross-reference among lists will be eliminated. Additionally, all subsequent constituent information will be recorded in a centralized location, significantly reducing the possibilities for data entry and/or retrieval inaccuracies.
- Faster queries and reporting
- Easier interface with outside accounting and administration systems.
- Greater system functionality—staff will be able to take advantage of the increased functionality of the software to more easily coordinate business practices, manage information and communicate effectively with their constituency.
- Increased productivity—with all information contained in a centralized system, staff will be able to produce reports and mailings with greater efficiency and accuracy.
Once the data is converted, JCA continues to support its clients with training and technical assistance. If the selected software needs customization, JCA is available to develop reports, documentation or programming to suit specific needs.
JCA has worked with serveral clients to clean data codes. Learn about the experiences of these clients:
Appalshop
Children's Hospital Trust
Cleveland Museum of Art
Lifespan
Pacific Northwest Ballet
Stamford Health Foundation
The marks Blackbaud® and The Raiser's Edge® are registered trademarks of Blackbaud, Inc. Jacobson Consulting Applications Inc. is an independent consulting firm and as such is neither sponsored nor endorsed by Blackbaud, Inc.
|