Qlik > Case Studies > QlikView BI solution achieves heavenly results for York Minster

QlikView BI solution achieves heavenly results for York Minster

Qlik Logo
Customer Company Size
SME
Region
  • Europe
Country
  • United Kingdom
Product
  • QlikView
Tech Stack
  • Sage accountancy package
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Revenue Growth
  • Productivity Improvements
Technology Category
  • Application Infrastructure & Middleware - Data Visualization
Applicable Industries
  • Buildings
  • Education
Applicable Functions
  • Sales & Marketing
  • Business Operation
Use Cases
  • Process Control & Optimization
  • Predictive Replenishment
Services
  • Data Science Services
About The Customer
York Minster is a world-renowned cathedral, famous for its impressive Gothic architecture and visited by thousands of worshippers and sightseers every year. The Minster is a deceptively large organisation, with around 150 employees and 500 volunteer workers belonging to departments such as Music, Visitor Services, Finance, and one of the largest groups, The Stoneyard, made up of craftspeople, such as masons and joiners who look after the fabric of the Minster. York Minster incurs operational costs of an incredible £9 per minute, 24 hours a day, and as a registered charity it depends on donations and visitors fees to survive. This means that the Minster has had to become increasingly aware of its income streams in order to improve margins and keep reinvesting in its many community and regeneration projects.
The Challenge
York Minster, a world-renowned cathedral, is a large organization with around 150 employees and 500 volunteer workers. The operational costs of the Minster are incredibly high, amounting to £9 per minute, 24 hours a day. As a registered charity, it depends on donations and visitors fees to survive. This means that the Minster has had to become increasingly aware of its income streams in order to improve margins and keep reinvesting in its many community and regeneration projects. The IT department is relatively small, with two employees including IT Manager David Wilkinson. Wilkinson also acts as Assistant to the Chief Accountant, and it is this dual role that brought him to QlikView. “When we started charging for entry into the Minster, we needed to be able to analyse visitor trends and tills data. We also wanted to identify where we were improving, especially how much income was coming through from GiftAid and the sale of guide books,” says Wilkinson.
The Solution
York Minster chose QlikView to help them make sense of their till data and financial information. Their IT provider CIBER was on hand during implementation. QlikView enabled York Minster to identify that there was scope to improve the promotion of certain types of admission charges including Gift Aid and guide books. When the till transactions were visualised, showing revenue by staff and by time, the Minster made the decision to include sales prompts on tills for these items so that they could measure the difference accurately. In addition to the reporting structure put in place for York Minster Revealed, and for reporting on till activity, QlikView has also been utilised for reporting on financial ledgers and job costings. Wilkinson is impressed with QlikView’s versatility: “It is a very useful tool, which enables us to analyse info within our Sage Line 500 databases and get quick answers when we need them. Being able to interrogate the data without having to create complex spreadsheets is such a time saver.”
Operational Impact
  • Clear visualisation of sales activity
  • Painless implementation
  • Quick and easy to use
  • Versatile; can be used by different departments for various functions
Quantitative Benefit
  • In 2007/08, the organisation more than doubled the amount reclaimed through Gift Aid on admission charges from the previous year.

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.