Qlik > Case Studies > Christian Aid makes major improvements to fundraising reporting thanks to QlikView

Christian Aid makes major improvements to fundraising reporting thanks to QlikView

Customer Company Size

Large Corporate

Country

United Kingdom

Product

QlikView

Tech Stack

Data Analysis Software

Implementation Scale

Enterprise-wide Deployment

Impact Metrics

Cost Savings
Productivity Improvements

Technology Category

Analytics & Modeling - Big Data Analytics

Applicable Functions

Sales & Marketing

Services

Data Science Services

About The Customer

Christian Aid is an international development charity that has been devoted to raising money to help the poorest communities around the world for more than sixty years. It aims to help communities become self-sustaining and also provides immediate relief in desperate situations. Christian Aid draws support from all sections of the population and Christian Aid Week is the largest single fundraising event in the UK, raising £14.5 million in 2008. In 2005, Christian Aid’s Board set out a strategic framework to guide its work up to 2010. It agreed to make the best possible use of its resources, learn from experience, and be open about, and accountable for, its actions.

The Challenge

Christian Aid, an international development charity, has a large supporter database that records details of voluntary donations given by supporters in response to marketing and fundraising initiatives. The ability to easily access and report on this data is vital to ensure that the best use is made of investment in fundraising, and to assure supporters that effective use is being made of their generous gifts. However, until recently, Christian Aid had struggled to deliver comprehensive analysis of results and trends from its large and complex database.

The Solution

Christian Aid called systems integration consultancy and outsourcing company CIBER to help. CIBER arranged a QlikView demonstration for Christian Aid, which convinced them that QlikView was capable of delivering the speedy data access, analysis and reporting required. Three months after the initial demonstration, Christian Aid has already implemented a series of highly customised QlikView dashboards that go a long way to meeting its unique data analysis and reporting needs. The QlikView consultant came one week at a time to create specific dashboards, responding to spontaneous requests and turning them into on-screen functionality.

Operational Impact

Greater accountability: QlikView is being used to develop and test a new coding system that is being introduced to the Ascent server and Christian Aid's accounting system, which will hugely improve reporting on all aspects of fundraising. This will eventually result in greater reliability, transparency and accountability.
Massive savings in time: Exercises that would previously have taken several days to compile can now be done very quickly. For example, a trend analysis of donation cash flow over the past three years was created in about one hour.
Better use of investment in fundraising: Significant funds go into recruiting new regular monthly donors and QlikView improved this process immensely. Using QlikView, Christian Aid can analyse the most effective marketing channels – from direct mail or television advertising to street recruitment – identifying those with the highest and lowest efficacy.

Quantitative Benefit

Time saving: Exercises that would previously have taken several days to compile can now be done very quickly. A trend analysis of donation cash flow over the past three years was created in about one hour.

Case Study missing?

Start adding your own!

Add New Record

No account yet?

Christian Aid makes major improvements to fundraising reporting thanks to QlikView

Contact us