End User

MS Amlin - Case Study

ms amlin logo

MS Amlin are part of the Top 10 global insurance group MS&AD. As providers of insurance in Property & Casualty, Marine & Aviation, and Reinsurance for other insurers, they are experts in underwriting and claims, with both technical capability and deep knowledge of the areas they insure. They currently have more than 2,400 people in 26 locations worldwide.

The company had invested in a large data warehousing project with the aim of enabling everyone in the business to have a common view of data and to align the information systems to the strategic objectives of the business.


The installation of a new data warehouse allowed the company to store data effectively but reporting on this data was taking too long and the process of creating these reports was very manual.

Staff were producing reports in an old fashioned style – getting data out of Microsoft Reporting Services, downloading the information into Excel and then manipulating the spreadsheet to present their version as the truth, so behaviour was driven by an individual’s interpretation of the data at any one point in time.

It was labour intensive and expensive to maintain.


Due to the manual nature of their reporting practices, it was difficult to trust the data and make business decisions on the back of it. With reports taking so long to compile, the data was already out of date by the time they were finished.

MS Amlin also didn’t have one point of access for everyone in the business to see data relevant to their department. There was no ‘single version of the truth’ throughout the business, with reporting being done by siloed teams.


MS Amlin integrated the dashboard technology with their data warehouse to create a common view of data trends to facilitate analysis, decisions, and the ability to drill down for more detail if needed.

Previously, information had been difficult to interpret and explore. The Panintelligence dashboard gave MS Amlin increased visibility of key data, with different views of the data available. The Panintelligence dashboard did not require any movement of data, so data was stored securely and shared easily. 

MS Amlin created a dedicated Project Team to improve customer outcomes who were able to use dashboards to make better decisions. A key return on investment which resulted from the dashboard implementation, came from identifying and releasing reserves back into the business.

MS Amlin Thumbnail 2

Case studies