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

Edit This Case Study Record

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

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

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Functions	Procurement
Use Cases	Supply Chain Visibility
Services	Data Science Services
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Functions

Procurement

Use Cases

Supply Chain Visibility

Services

Data Science Services

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

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.

Impact #1	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.
Impact #2	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.
Impact #3	The selection and de-selection of data takes seconds and has reduced the time for analysis from half a day to half an hour.

Impact #1

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.

Impact #2

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.

Impact #3

The selection and de-selection of data takes seconds and has reduced the time for analysis from half a day to half an hour.

Benefit #1	First year savings of £3 million
Benefit #2	Estimated forecast savings from the project over the next five years amounts to more than £24 million.
Benefit #3	Saved around £30,000 a year in reducing operating costs for reports and analysis

Benefit #1

First year savings of £3 million

Benefit #2

Estimated forecast savings from the project over the next five years amounts to more than £24 million.

Benefit #3

Saved around £30,000 a year in reducing operating costs for reports and analysis

Download PDF Version

Overview

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

Operational Impact

Quantitative Benefit