The city of Copenhagen (Byen København) is the capital and most populous city of Denmark. Copenhagen has a population of almost 800,000, of whom more than 600,00 live in the Municipality of Copenhagen. The entire Copenhagen metropolitan area has over 2 million inhabitants. Copenhagen Municipality (København Kommune) is responsible for a wide variety of public services, including land-use planning, environmental planning, public housing, management and maintenance of local roads, and social security.
With TARGIT, we now have one official version of the elements in our world, and that makes it far easier for us to see different problems from new angles, but always based on the same data set. This is an enormous advantage which we expect will make us even better at utilizing the budget to the absolute advantage for the citizens.
- Peter Bogh, Former Finance Manager, Copenhagen Municipality
39,706 light fixtures, 11,585 signs, 7,252 garbage cans, 44 bridges, and 759 kilometers of road. These are just a few of the many areas for which the City of Copenhagen's Road and Park Unit is financially responsible. The unit is tasked with ensuring citizens of Copenhagen and visitors have the best possible impression of the city space and doing so with fiscal responsibility and sensitivity to the citizen taxes that fund the ongoing project. Municipality employees knew that they needed a software solution that could deliver them comprehensive oversight and digestible analyses of the vast amount of municipality data.
Multiple city units within Copenhagen Municipality had already implemented TARGIT Decision Suite and were thrilled with their streamlined processes and easy access to data. The choice of TARGIT was a no-brainer.
“Previously, we had a wealth of management tools and spreadsheets that each had their individual way of seeing and handling data," says Peter Bogh, former Finance Manager at Copenhagen Municipality. "With TARGIT, we now have one official version of the elements in our world, and that makes it far easier for us to see different problems from new angles, but always based on the same data set. This is an enormous advantage which we expect will make us even better at utilizing the budget to the absolute advantage for the citizens.”
With TARGIT Decision Suite's analytics for municipalities, employees now have a single, comprehensive portal for municipality management and decision-making, and helps the Road and Park Unit focus on areas where they can become more effective.
“The ease of accessing a large amount of data makes it easier for administrative employees to answer questions from citizens and to retrieve data for various reporting purposes," says Bogh. "Before, it would take three days to create a special report. Now it only takes a few hours. We save time on each report, obtain a consistent basis for decision making, and we have fewer manual errors.”
Through an SQL data warehouse, TARGIT gathers data from Microsoft Dynamics NAV and the city’s area as well as personnel data. From the TARGIT user interface, employees can then access exactly the information they need. TARGIT Decision Suite is also used for running statistics on the Road and Park yearly user satisfaction survey, where 3,000 citizens answer 200 questions about their experience of the city space.
”The survey results enable us to compare the technically evaluated quality of the roads to citizens’ personal experience," says Bogh. "If we find great differences, we can dig even further into the figures and seek explanation in the numbers. In this way, we use business intelligence as a very concrete means to focus on areas that are important to the citizens."