Information Builders > Case Studies > WebFOCUS Streamlines Fundraising for UNC Charlotte Foundation

WebFOCUS Streamlines Fundraising for UNC Charlotte Foundation

Information Builders Logo
Company Size
1,000+
Region
  • America
Country
  • United States
Product
  • WebFOCUS
  • ReportCaster
  • Financial Reporting
  • Professional Services
Tech Stack
  • Business Intelligence
  • Data Integration
  • Data Integrity
  • Oracle Database
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Customer Satisfaction
  • Productivity Improvements
Technology Category
  • Analytics & Modeling - Real Time Analytics
  • Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries
  • Education
Applicable Functions
  • Business Operation
  • Sales & Marketing
Use Cases
  • Predictive Quality Analytics
  • Real-Time Location System (RTLS)
Services
  • Data Science Services
  • System Integration
About The Customer
The University of North Carolina at Charlotte (UNC) is an urban research university with more than 90,000 living alumni and adds 4,000 to 4,500 new alumni each year. Many of those alumni, along with other community members, contribute funds to the university in the form of gifts. The UNC Charlotte Foundation, Division of University Advancement, is charged with reaching out to the alumni and community to raise funds for the university and with managing all aspects of donations. The foundation has a staff of 11 IT professionals who are responsible for supplying donors and university executives with detailed information on donation amounts, contributors, progress toward objectives, fund disbursements, and more.
The Challenge
The University of North Carolina at Charlotte (UNC) Foundation, Division of University Advancement, is responsible for fundraising and managing all aspects of donations. The foundation faced challenges in tracking all the information about donations, contributors, and fundraising programs. The IT staff needed to supply donors and university executives with detailed information on donation amounts, contributors, progress toward objectives, fund disbursements, and more. The existing system was inefficient, with requests for new reports having a ten-day minimum turnaround. The foundation needed a solution that could provide more accurate and timely information about fundraising and donors to university leaders and relieve the IT group from creating custom reports.
The Solution
The university engaged Information Builders Professional Services to create an operational data store that feeds a series of WebFOCUS dashboards. This data integration and integrity solution improves data quality as it copies production data from the university’s Banner ERP system to an Oracle database set up for reporting. They also created parameterized reports that let people filter the data by date range, geography, and other variables. The dashboards display information via easy-to-read graphs that identify precise metrics such as total contributions, contributions by college, and contributions by project. Geographic displays make it easy to see where the most generous donors reside. Users can drill down into the numbers to uncover granular details about donors.
Operational Impact
  • Better information has led to more targeted financial projections and outreach.
  • Performance metrics make the staff more proactive and effective in fundraising efforts.
  • The dashboards have led to huge improvements in reporting efficiency, cutting the time required to access data from 30 minutes to 20 seconds.
  • The system is very easy to use, with virtually zero learning curve.
  • The dashboards are having a very positive effect on fundraising.
Quantitative Benefit
  • The amount of requests for reports has skyrocketed because now people know they can get accurate information in a timely manner.
  • The time required to access data has been cut from 30 minutes to 20 seconds.

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.