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

Edit This Case Study Record

	Christian Aid makes major improvements to fundraising reporting thanks to QlikView Qlik

Christian Aid makes major improvements to fundraising reporting thanks to QlikView

Qlik

Technology Category	Analytics & Modeling - Big Data Analytics
Applicable Functions	Sales & Marketing
Services	Data Science Services
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Big Data Analytics

Applicable Functions

Sales & Marketing

Services

Data Science Services

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.

About 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.

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.

Impact #1	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.
Impact #2	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.
Impact #3	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.

Impact #1

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.

Impact #2

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.

Impact #3

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.

Benefit #1	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.

Benefit #1

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.

Download PDF Version

Overview

Christian Aid makes major improvements to fundraising reporting thanks to QlikView

Operational Impact

Quantitative Benefit