Download PDF
U.K. Council Saves £150,000 a Year with QlikView for Budget Reports
Technology Category
- Analytics & Modeling - Real Time Analytics
Use Cases
- Predictive Maintenance
Services
- Data Science Services
The Challenge
Peterborough City Council was facing a multitude of challenges in generating budget information. The council relied on a multitude of reports generated from Oracle and other financial reporting software to produce budget comparison reports (BCR) and key performance indicator (KPI) information. This often involved extensive manual manipulation of data in Excel to derive required outputs. Managers were also frustrated by the inability to report and analyse data in a single format. In addition, the council experienced delays in accessing BCR information and it was increasingly cumbersome to drill down into the data to provide individual budget holders information relevant to their roles. A critical weakness was that BCR information was only available at month end making it difficult to analyse and provide forecasts of any variations in actual as against projected expenditure. Finally, at a time of national constraint in public sector spending it was a major challenge to extract and manipulate procurement data to identify potential efficiency savings and create adequate mechanisms for accruals.
About The Customer
Peterborough City Council is a unitary local government authority in the United Kingdom delivering high quality public services to around 175,000 people. The authority employs 6,500 staff and has an annual budget of around £217 million (2009-2010). It is making major efficiency savings to meet stringent government targets for reduced spending in the public sector. The council's core funding from central government of £110 million in the 2010-2011 financial year has been reduced by £12 million in 2011-2012 which will rise to a cut of £24 million in 2014-2015.
The Solution
The council deployed QlikView in the last quarter of the 2009-2010 financial year enabling the assembling of numerous data sources in one business intelligence application. This allowed the production of faster and more accurate finance reports for users. QlikView quickly remedied these weaknesses. Its ease of use, speed of deployment, and ability to analyse data from many sources provided greater visibility across financial and performance data. The introduction of QlikView has vastly improved budget holders’ ability to access the information they need to manage their budgets and to carry out accurate forecasting. The time savings achieved through the use of QlikView means that finance staff can focus on improving quality of information to achieve more accurate budgetary outturns and reduce unanticipated movements in forecasts.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Remote Monitoring & Predictive Maintenance App for a Solar Energy System
The maintenance & tracking of various modules was an overhead for the customer due to the huge labor costs involved. Being an advanced solar solutions provider, they wanted to ensure early detection of issues and provide the best-in-class customer experience. Hence they wanted to automate the whole process.
Case Study
Predictive Maintenance for Industrial Chillers
For global leaders in the industrial chiller manufacturing, reliability of the entire production process is of the utmost importance. Chillers are refrigeration systems that produce ice water to provide cooling for a process or industrial application. One of those leaders sought a way to respond to asset performance issues, even before they occur. The intelligence to guarantee maximum reliability of cooling devices is embedded (pre-alarming). A pre-alarming phase means that the cooling device still works, but symptoms may appear, telling manufacturers that a failure is likely to occur in the near future. Chillers who are not internet connected at that moment, provide little insight in this pre-alarming phase.
Case Study
Aircraft Predictive Maintenance and Workflow Optimization
First, aircraft manufacturer have trouble monitoring the health of aircraft systems with health prognostics and deliver predictive maintenance insights. Second, aircraft manufacturer wants a solution that can provide an in-context advisory and align job assignments to match technician experience and expertise.
Case Study
Integral Plant Maintenance
Mercedes-Benz and his partner GAZ chose Siemens to be its maintenance partner at a new engine plant in Yaroslavl, Russia. The new plant offers a capacity to manufacture diesel engines for the Russian market, for locally produced Sprinter Classic. In addition to engines for the local market, the Yaroslavl plant will also produce spare parts. Mercedes-Benz Russia and his partner needed a service partner in order to ensure the operation of these lines in a maintenance partnership arrangement. The challenges included coordinating the entire maintenance management operation, in particular inspections, corrective and predictive maintenance activities, and the optimizing spare parts management. Siemens developed a customized maintenance solution that includes all electronic and mechanical maintenance activities (Integral Plant Maintenance).
Case Study
Asset Management and Predictive Maintenance
The customer prides itself on excellent engineering and customer centric philosophy, allowing its customer’s minds to be at ease and not worry about machine failure. They can easily deliver the excellent maintenance services to their customers, but there are some processes that can be automated to deliver less downtime for the customer and more efficient maintenance schedules.
