• Votes for this article no votes for this yet
  • Dashboard Insight Newsletter Sign Up

QlikView Used To Track Down Alleged Serial Killer in Sweden

Tuesday, February 15, 2011

QlikTech, a leader in Business Discovery – user-driven Business Intelligence, today announced that police analysts in Sweden have used QlikView to assist with a high profile crime case which lasted more than a year. QlikView has enabled the police to analyze data and reports that would have taken one police officer in excess of 43 years.

“Speed is of essence in any police work all over the world,” said Police analyst Berth Simonsson. “With this ground breaking technology, we can save lives, predict crime and target anti-social behavior.”

The crimes took place in the Swedish city of Malmö where people were shot at while they stood at bus stops, sat in their cars, and moved about indoors. One person has died and several others have been wounded in the attacks. The Skåne (southern Sweden) police department currently has approximately 100 QlikView applications, rolled out over the past 3 years.   Malmö police analyst Berth Simonsson is part of a team of two who support 3,500 people in the police force, including about 50 analysts.  Although the Malmö police department is a long-time customer of QlikView, it had never been used to analyze criminal activity.

For this case, the analysts loaded 10 years’ worth of crime reports (two million reports, comprising two billion rows of data) into an existing QlikView application. It took three hours to load the data and configure interactive reports, and then police analysts could immediately begin investigating the data. Because of the power of QlikView to analyze multiple data streams from any source, the police department was also able to add in and cross reference information from the “tip line” submitted from vigilant citizens.

Simonsson commented, "QlikView has been a labor-saving tool for the police. Police analysts ask questions and QlikView delivers answers instantly. Instead of 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."

Nine months of work in one minute. Without QlikView, police analysts would have had to read every crime report manually to search for clues that might lead them to a suspect. Simonsson estimated that it would have taken three people three months to read through just one year of reports.  With the additional 10 years' worth of historical data for this serial killer case, analyzing the entire set could have taken 43 years for one officer to analyze.

Instant analysis as powerful investigative tool. If police analysts have an idea about a case, they can use QlikView to test clues. They can search for any city, time of day, reported behavior, or other details. The QlikView associative experience enables them to explore trends in the data. If they find something of interest (e.g., red car or red truck), they can click a button to view the entire crime report immediately. 

Expanding Use to Fight Crime
Now that the police analysts have experienced the power of QlikView for solving crimes, they are planning to use it more broadly. The department checks about 10,000 people every year in Skåne and they can use QlikView to analyze who has been checked and when.  Applications for car theft and street crimes like assaults are in the plan and the department has goals of using QlikView to reduce crimes in specific areas.

About QlikTech

QlikTech is a leader in Business Discovery -- user-driven Business Intelligence (BI). QlikTech’s powerful, accessible Business Discovery solution bridges the gap between traditional business intelligence solutions and standalone office productivity applications.  Its QlikView Business Discovery platform enables intuitive user-driven analysis that can be implemented in days or weeks rather than months, years, or not at all. The in-memory associative search technology it pioneered allows users to explore information freely rather than being confined to a predefined path of questions. QlikView Business Discovery works with existing BI applications and adds new capabilities: insight for everyone, zero-wait analysis, mobility, an app–like model, remixability and reassembly, and a social and collaborative experience.  Headquartered in Radnor, Pennsylvania, QlikTech has offices around the world serving more than 16,000 customers in over 100 countries. 

Tweet article    Stumble article    Digg article    Buzz article    Delicious bookmark      Dashboard Insight RSS Feed
 
Other articles by this author

Discussion:

No comments have been posted yet.

Site Map | Contribute | Privacy Policy | Contact Us | Dashboard Insight © 2017