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

Edit This Case Study Record

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

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

Qlik

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
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. Read More
About 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. Read More
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. Read More Log in to view content
Contents

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

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.

About 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.

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.

Impact #1	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.
Impact #2	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.
Impact #3	QlikView has transformed the Dienst’s service into a knowledge and advice center for the whole city.

Impact #1

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.

Impact #2

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.

Impact #3

QlikView has transformed the Dienst’s service into a knowledge and advice center for the whole city.

Benefit #1	QlikView, including the data warehouse, helps Stadstoezicht realize considerable annual savings in administrative costs.
Benefit #2	The time previously needed to produce reports is now spent on analyzing the information.

Benefit #1

QlikView, including the data warehouse, helps Stadstoezicht realize considerable annual savings in administrative costs.

Benefit #2

The time previously needed to produce reports is now spent on analyzing the information.

Download PDF Version

Overview

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

Operational Impact

Quantitative Benefit