I worked closely with my colleagues in the Claims Fraud team and we wanted to find repeat offenders that we could report to the police. However, we were struggling to analyze the vast quantity of data in our claims systems to find similar cases. Ideally, we wanted to find a collection of rear-end shunt claims with the same third-party driver, but this was proving to be a challenge. The third-parties often used a different name at the scene of the accident. Excel couldn’t cope with our data volumes and with our standard claims fraud systems, so it took weeks to change the search criteria and receive results.
So when I joined Qlik I wondered if the Qlik associative engine could help to solve this problem. The fact that Qlik Sense could compress the data and load all the fields into memory gave me the ability to analyze my data extremely quickly. I found that by combining the Qlik Sense bar chart with the feature called “Alternative Dimensions and Measures,” I could easily analyze my claims data and identify unique customer indicators such as the mobile phone number for the third-party. The interesting side-effect of this analysis was that I was also able to identify some minor data quality issues as well as some large and unusual claims transactions.
If you would like to see this in action take a look at this post on the Qlik Community website…
Here you can find the Insurance Claims App and a link to the associated video. Try it for yourself and let us know what you think!