Qlik > 实例探究 > Procurement Lincolnshire Saves £3 million in First Year with £24 million forecast over five years using QlikView

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

公司规模

Large Corporate

地区

Europe

国家

United Kingdom

产品

QlikView

技术栈

SQL Server
MS Access
MS Excel

实施规模

Enterprise-wide Deployment

影响指标

Cost Savings
Productivity Improvements

技术

分析与建模 - 实时分析

适用功能

采购

用例

供应链可见性(SCV)

服务

数据科学服务

关于客户

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.

登录后查看完整内容

挑战

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.

登录后查看完整内容

解决方案

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.

登录后查看完整内容

运营影响

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.
The new system has also saved Procurement Lincolnshire around £30,000 a year in reducing operating costs for reports and analysis, which means the partnership, is getting significantly more business value for less investment.

登录后查看完整内容

数量效益

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

登录后查看完整内容