Qlik > 实例探究 > U.K. Council Saves £150,000 a Year with QlikView for Budget Reports

U.K. Council Saves £150,000 a Year with QlikView for Budget Reports

Qlik Logo
公司规模
Large Corporate
地区
  • Europe
国家
  • United Kingdom
产品
  • QlikView
技术栈
  • Oracle
  • Excel
实施规模
  • Enterprise-wide Deployment
影响指标
  • Cost Savings
  • Productivity Improvements
技术
  • 分析与建模 - 实时分析
用例
  • 预测性维护
服务
  • 数据科学服务
关于客户
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.
挑战
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.
解决方案
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.
运营影响
  • Budgetary information is now accessible during the month instead of at month end only.
  • Full prior month information is now available by mid-day on the first working day of the next month.
  • Budget holders have greatly improved information to manage their budgets.
  • Data entry functionality has been introduced so that revised forecast outturns and comments could be input to QlikView and then carried forward month by month.
  • Procurement reports now provide supporting evidence to help identify procurement efficiency savings and KPI information.
数量效益
  • Annual productive time savings of £150,000
  • Reporting of prior month budgetary information improves by two working days

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

相关案例.

联系我们

欢迎与我们交流!
* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

感谢您的信息!
我们会很快与你取得联系。