Claims bordereaux analysis: Are you making the most of your data?

Anna Burge
Anna Burge29 Jan 2020

Are you making the most of your data? Read our latest insight on claims bordereaux analysis.

artificial insights claims bordereaux analysis

We recently spoke with several insurers about how they use data within their Bordereaux claims files and, after a little digging, we discovered that they were sitting on a goldmine of claim information in their systems - all ignored because it was non-standardised, unstructured and basically, a mess.

This data is extremely valuable and often goes to waste because it’s usually in Excel spreadsheets in Lloyd’s and non-Lloyd’s formats. If insurers were able to standardise and make sense of this information it would allow them to understand where claims are coming from, better analyse how their business is performing and ultimately improve their underwriting decisions based on data that is available but not standardised.

We’re always interested in learning more about our client’s pain points and how they could be resolved, so we set out to create a solution to this problem.

What we did

We analysed thousands of Lloyd’s standard and non-Lloyd’s standard bordereau reports (as Excel files, in different formats and layouts with multiple tabs) from a number of insurers and identified relevant keywords and columns that we wanted to extract.

We used our data extraction tools to structure and standardise the reports, consolidating them into a master table which included hundreds of thousands of rows.

The results

We were able to extract numerous data points including (but not limited to) information related to claim information such as loss description, date of loss and total incurred losses.

On average, we were able to extract over 90% of the data related to key data points.

A generic data pipeline was then built in order to read, find, extract and load the relevant data into a structured database. Our optimised solution is highly scalable with the end-to-end process taking much less than a second per Excel file on a standard laptop.

Once the relevant data was extracted we were able to present this information back to the user, allowing them to analyse large amounts of data very quickly using tools like Tableau or Power BI. An example insight resulting from this process can be seen in the dashboard below:

If you would like to talk to us about creating a proof of concept with your data, please get in touch with Artificial's Oliver Fox

Visit our blog for more insights and the latest news.

Never miss an update

Sign up for the latest insurtech insights with our mailing list and receive only the most relevant articles delivered straight to your inbox.

By submitting your details, you agree to receive occasional marketing emails from us. We will never pass your details to any third parties. For further information on how we manage your personal data, visit our Privacy Policy.

We and selected third parties use cookies or similar technologies as specified in the cookie policy. Learn more