Our Client is a Managing Agent at Lloyds with a global specialty lines platform underwriting a diversified portfolio of specialty lines business from its operations at Lloyd's and around the world.


The Vision

The Client wanted to develop a specific dashboard for the existing management information and analytics suite to help claims teams analyze the effect of catastrophes’ claims profiles on the business. The majority of data would come from the existing company Data Warehouse and data from Lloyds of London.

Delivering the Vision

Catastrophe claims impact the business over the long term, and in many cases pay-outs are spread over 20 to 30 years. It is important for the Claims Teams to keep abreast of claims and settlements while assessing the impact on the future as well as comparing the company standpoint with the rest of the industry. Thorogood developed a QlikView dashboard which draws directly from the Data Warehouse and gives insight to the Claims Team on how catastrophes have affected the company. The Claims Team can track the development of catastrophe claims and settlements. QlikView allows for interactive data discovery and enables them to compare catastrophes and filter the data based on the internal business hierarchy all the while comparing the company with the Lloyds market averages.

Approach Taken

During development, an agile, iterative approach was taken. Business users were involved throughout the design and development process to ensure that the dashboard was intuitive, easy-to-use and also provided clear and obvious answers to their business questions. This approach meant the project went from an initial wireframe design to live in three months.

Want to know more?

If you would like to know more about what can be achieved with BI and Analytics would like to discuss your options with an independent Business Intelligence specialist, please get in touch with Evelyn Heyes in the UK (evelyn.heyes@thorogood.com) or Trevor Jones in the US (trevor.jones@thorogood.com).