/ Creating a loss triangle

Table of Contents


A critical need for any insurance company is track claim losses over time by displaying them in what are called “loss triangles.” Typically, this is a very manual process looking that involves looking at the financial transactions over the last year and when the claim occurred and updating an Excel spreadsheet. 


By leveraging Magic ETL and using the pivot table card, I have been able to automate this process and allow our Finance team to view updated triangles any time they want. I enhanced it even further by using Form Builder, which allows the user to select a specific evaluation date in case they don’t want the most recent date, but want to look at as of a certain historical date. This saves our company countless hours each month and also improves accuracy by implementing this solution.


To produce the loss triangles, I leverage the group by tile and the rank and window tiles to create running totals. This allows me to show losses for each year of a claim. I then use the pivot table card and place the loss year in the row and the transaction year (or months of development) in the columns and the amount in the value field. This will result in the information being displayed in the shape of a triangle.


Source link