Qlik > 实例探究 > Dienst Stadstoezicht keeps Amsterdam “clean, whole and safe” using QlikView

Dienst Stadstoezicht keeps Amsterdam “clean, whole and safe” using QlikView

Qlik Logo
公司规模
Large Corporate
地区
  • Europe
国家
  • Netherlands
产品
  • QlikView
技术栈
  • MS Excel
  • MS Access
  • SQL Database
  • IBM server
  • VMware ESX3.0
实施规模
  • Enterprise-wide Deployment
影响指标
  • Cost Savings
  • Productivity Improvements
技术
  • 分析与建模 - 实时分析
适用行业
  • 城市与自治市
适用功能
  • 商业运营
用例
  • 实时定位系统 (RTLS)
  • 质量预测分析
服务
  • 数据科学服务
关于客户
Dienst Stadstoezicht is an independent public service that helps to make Amsterdam a cleaner, safer, and more accessible city. Among its customers are the Amsterdam district councils. The Service implements the parking policy, supervises public space, and provides environmental services. With its sophisticated technical infrastructure and extensive databases, Stadstoezicht is an innovative organization which is increasingly developing into a knowledge and advice center for the entire city. It employs around 700 people.
挑战
Dienst Stadstoezicht, an independent public service in Amsterdam, was facing fierce competition from private companies in the fields of supervision and safety. To maximize its efficiency, it decided to automate as much as possible. It scans the number plates of parked cars and checks them against a database to determine whether the owners have a parking permit. This procedure also generates information about payment patterns in the various neighborhoods. However, the organization had six databases that were not linked, leading to considerable obscurity. They needed a solution to link these databases and transform the data into meaningful information.
解决方案
To solve the problem, Dienst Stadstoezicht decided to build a central data warehouse in mid-2006 which would link all the data. However, the data warehouse was not able to produce meaningful information just like that. Therefore, they decided to use QlikView, a reporting tool that was able to easily extract data from as many database sources. At the beginning of 2007, Stadstoezicht bought the QlikView standard package plus a considerable number of additional licenses to enable controllers, amongst others, to produce reports themselves. Right now, around 75 people are using QlikView, including forty team managers, five controllers and one ’enterpriser’. The other users are board members and the middle management of Parking, Supervision, P&O, Facilities, Planning & Control, and Finance and Services.
运营影响
  • QlikView has enabled Dienst Stadstoezicht to build fifteen applications in about fifteen weeks to measure payment levels, team performance, sick leave, and other performance indicators.
  • In the evening, the six source systems upload their data to the data warehouse and in the morning all the data is processed with ready-to-use reports thanks to QlikView.
  • QlikView has transformed the Dienst’s service into a knowledge and advice center for the whole city.
数量效益
  • QlikView, including the data warehouse, helps Stadstoezicht realize considerable annual savings in administrative costs.
  • The time previously needed to produce reports is now spent on analyzing the information.

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 的任何营销电子邮件。
提交

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