Qlikview used to capture serial killer in Sweden

Johannesburg, 17 Apr 2013
Read time 3min 10sec

QlikTech, a leader in Business Discovery - user-driven business intelligence (BI), announced that police analysts in Sweden have used QlikView to assist with a high-profile murder investigation. QlikView has enabled the Skane police force (in southern Sweden) to analyse data and reports leading to the capture of a serial killer.

Over a period of seven years, Malm"o was a city in fear of a serial killer that fired on residents of foreign origin. Police investigations around the case were extensive and time-consuming. After deploying QlikView, police in Skane worked through half a million interviews in less than a second. Evidence that would have normally taken three police analysts three months to read through was analysed in three minutes, scanning all notifications issued since 1998.

"Speed is of essence in any police investigation," said Police analyst Berth Simonsson. "QlikView has been a labour-saving tool. Police analysts ask questions and QlikView delivers answers instantly. Rather than going through the reports manually, we have been able to go through lots of information quickly to find the link that otherwise would have been hard to detect."

The Skane police are one of the first police forces in the world to use QlikView to help solve crimes. The ability to search through millions of interrogation records in less than a second helped lead to the capture of one of the time most high-profile investigations, the serial killer in Malm"o. The police force also took advantage of QlikView when several buses were shot at in central Malm"o. The collection of evidence and background information was expedited using QlikView. Data showed the shootings would take place in a particular area at a particular time. When the shooting occurred to their calculations, the police could protect them. With QlikView, police in Skane can conduct this type of forecast in four seconds, a task that previously took four hours.

The police force has built a number of apps using QlikView to analyse communication behaviours, using data from phone masts. Regarding criminal behaviour, they track phone call activity before the actual crime is committed and very shortly after. Skane police use QlikView to focus on the actual analysis instead of searching for information. By analysing crime statistics along with lots of other information, such as weather, day of week, and large events, the police have created models to predict crime.

The Skane police force continues to expand its use of QlikView to clearly visualise when and where different types of crimes occur, optimise staffing, increased crime reduction and security for citizens. Skane isSweden's third-largest police department, with 3 500 employees, of which about 2 600 are police officers and about 900 are civilian employees. QlikView is used in both the operational and administrative activities. All Skane police have access to QlikView - uses for the tool vary depending on the type of information needed.

QlikView has helped improve the following aspects of Skane police work:

* Shortened 'seek' time for entries - from nine months to three minutes
* 6.7 million krone were moved from administration to law enforcement
* Faster crime forecasts - forecasts can now be made in four seconds instead of four hours
* 500 000 interrogations scanned in one second
* Better cost control
* Easier access to information
* Faster overview image
* Updated police
* Satisfied staff


QlikTech (NASDAQ: QLIK) is a leader in Business Discovery - user-driven business intelligence (BI). Its QlikView Business Discovery solution bridges the gap between traditional BI solutions and inadequate spreadsheet applications. The in-memory associative search technology QlikTech pioneered created the self-service BI category, allowing users to explore information freely rather than being confined to a predefined path of questions. Appropriate from SME to the largest global enterprise, QlikView's self-service analysis can be deployed with data governance in days or weeks. The QlikView Business Discovery platform's app-driven model works with existing BI solutions, offering an immersive mobile and social, collaborative experience. Headquartered in Radnor, Pennsylvania, QlikTech has offices around the world, serving approximately 27 000 customers in over 100 countries.

Editorial contacts
DUO Marketing + Communications Estelle Nagel (021) 683 8223
See also