Qlik > Case Studies > Dienst Stadstoezicht keeps Amsterdam “clean, whole and safe” using QlikView

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

Qlik Logo
Customer Company Size
Large Corporate
Region
  • Europe
Country
  • Netherlands
Product
  • QlikView
Tech Stack
  • MS Excel
  • MS Access
  • SQL Database
  • IBM server
  • VMware ESX3.0
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Cost Savings
  • Productivity Improvements
Technology Category
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Cities & Municipalities
Applicable Functions
  • Business Operation
Use Cases
  • Real-Time Location System (RTLS)
  • Predictive Quality Analytics
Services
  • Data Science Services
About The Customer
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.
The Challenge
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.
The Solution
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.
Operational Impact
  • 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.
Quantitative Benefit
  • 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

Related Case Studies.

Contact us

Let's talk!
* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.