Gwent Police has significantly reduced the time that its sergeants spend measuring officers’ performance after implementing a business intelligence tool from QlikTech.

Since the police force started using QlikTech’s QlikView web-based software in 2008, it has been able to compile monthly staff performance reports within minutes – as opposed to a whole day.

Detective Inspector Paul Evans at Gwent Police said that traditionally, sergeants would use the paper-based five-bar gate tallying method to measure how many incidents a police officer attended.

The sergeants had to go into individual applications in the force’s crime system, called Command and Control, to view information such as which incidents were attended, what crimes were dealt with, what crimes were detected, arrests made and the tickets officers issued.

“They had to manually pull out of that the information for their particular team, and tally up the figures. The sergeant could take one day each month [on the task].

“Now, [with QlikView] the sergeant logs in, clicks on the month, clicks on the team and they have the information instantly. It’s making us more efficient,” said Evans.

Furthermore, the data is updated automatically every two hours.

As well as measuring staff performance, Gwent Police uses QlikView to provide an overview of the geographical spread of crimes and incidents, which can also be analysed at a more granular level to give a picture of what is going in the whole Gwent area, the amount of crime at the police station level, and then even further down to what is happening in the neighbourhood wards. The data can also be linked to a calendar.

“We used other reporting tools [before] but we have never been able to delve into police performance,” Evans said.

Now, the police force can use QlikView to inform its daily management meetings. The officers look at what and where incidents occurred the previous day, and then based on that information, decides where to set up patrol strategies.

Evans said that all staff, from crime intelligence staff to performance analysts, can use the software, which the force accesses via Internet Explorer. However, a password secures the staff performance section of the tool so that officers can only see information such as their own performance and their rank in their peer group.

Gwent Police has started to look at using QlikView for HR data, in areas such as sickness, and it also plans to use the tool locally as an intelligence tool so that even further analysis of crime can be made.

“We will put in more sensitive data in a new intelligence app [such as those relating to offenders and incident profiling] and plot crime trends over a map dynamically, instead of seeing it in tables,” said Evans.

Gwent Police deploys the tool on Windows XP and Windows 7, and plans to deploy it on Windows 7 using Citrix in the future.