TARGIT Business Intelligence - Copenhagen Office

39,706 light fixtures, 11,585 signs, 7,252 garbage cans, 44 bridges, and 759 kilometres of road. This is just a few of the many areas that the Road and Park divisions in the City of Copenhagen is financially responsible for. And to make sure that citizens and visitors have the best possible impression of the city space, it is essential to the City that tax payments are utilized in the best possible manner. Therefore, they started looking for a business intelligence solution that could create overview and provide easy access to the unit’s huge amounts of data.
Other units in the City of Copenhagen have already implemented TARGIT BI Suite, and after an assessment of several large business intelligence solutions, Road & Park also concluded that TARGIT BI Suite would provide the most benefit.

Optimal utilization of budgets

Today, TARGIT BI Suite frames a homogeneous basis for management and decision making and helps Road & Park focus in areas where they can become more effective.
“Previously, we had a wealth of management tools and spreadsheets that each had their individual way of seeing and handling data. With TARGIT BI Suite, 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 of the citizens”, says Peter Bogh, Finance manager in the Road and Park Unit of the City of Copenhagen.

Knowledge about citizens’ satisfaction

Through an SQL data warehouse, TARGIT BI Suite gathers data from Microsoft Dynamics NAV and the city’s area as well personnel data. From the TARGIT user interface, employees can then access exactly the information they need. The TARGIT solution is also used for running statistics on the Road & 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. 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.”

From few days to few hours

There is no doubt that the TARGIT solution is of great importance to the City of Copenhagen’s Road and Park unit: “The ease of accessing large amount of data also makes it easier for administrational employees to answer questions from citizens and to retrieve data for various reporting purposes. Before, it would take three days to create a special report. Now it is a question of a few hours”, says Peter Bogh, and concludes: “We save time on each report, obtain a consistent basis for decision making and have fewer manual errors”