Download PDF
Qlik > Case Studies > Procurement Lincolnshire Saves £3 million in First Year with £24 million forecast over five years using QlikView
Qlik Logo

Procurement Lincolnshire Saves £3 million in First Year with £24 million forecast over five years using QlikView

Technology Category
  • Analytics & Modeling - Real Time Analytics
Applicable Functions
  • Procurement
Use Cases
  • Supply Chain Visibility
Services
  • Data Science Services
The Challenge
Procurement Lincolnshire, a shared service partnership between eight local authorities in the East Midlands, wanted to respond to the need for efficiency savings by analysing its expenditure in more detail than ever before. They decided to improve its visibility over procurement activity with a new software platform to help meet the budget reduction targets posed by the government Comprehensive Spending Review in 2010. The procurement activities under scrutiny already cover around 30 categories. They range from reviews of high spending services, such as adult social care and children services, to outlays on photocopiers, pest control, and even dog kennelling. The challenge was finding a user friendly dashboard solution to access customised data mining reports for a more holistic view of the organisation spend.
About The Customer
Procurement Lincolnshire in the United Kingdom is a shared service partnership between eight local authorities which together spend more than £600 million a year on purchasing of goods and services. The service is formally hosted by the largest authority Lincolnshire County Council on behalf of the other member partners. The other members are Boston Borough Council, City of Lincoln Council, East Lindsey District Council, North Kesteven District Council, South Holland District Council, South Kesteven District Council, and West Lindsey District Council. In the current climate of fiscal restraint in the UK, the partnership wanted to respond to the need for efficiency savings by analysing its expenditure in more detail than ever before.
The Solution
Procurement Lincolnshire chose QlikView as the dashboard solution for their custom-built spend analysis platform. QlikView provides users with an extremely simple but powerful means to analyse data and identify value from it. QlikView also delivers multiple benefits with its patented in-memory associative technology. The versatility and flexibility of QlikView is giving users immediate reports that previously would have been produced on an ad hoc basis by IT staff. With a single click of the mouse, it is possible to drill through to a particular category of spend and view the suppliers for that category, total spend, spend Pareto (a measure of efficiency), and supplier location.
Operational Impact
  • The versatility and flexibility of QlikView is giving users immediate reports that previously would have been produced on an ad hoc basis by IT staff.
  • With a single click of the mouse, it is possible to drill through to a particular category of spend and view the suppliers for that category, total spend, spend Pareto (a measure of efficiency), and supplier location.
  • The selection and de-selection of data takes seconds and has reduced the time for analysis from half a day to half an hour.
Quantitative Benefit
  • First year savings of £3 million
  • Estimated forecast savings from the project over the next five years amounts to more than £24 million.
  • Saved around £30,000 a year in reducing operating costs for reports and analysis

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.