/ Building a decline triangle

Trouble

A important want for any insurance policies business is monitor declare losses in excess of time by displaying them in what are referred to as “loss triangles.” Commonly, this is a incredibly handbook approach wanting that includes seeking at the economic transactions in excess of the past 12 months and when the claim occurred and updating an Excel spreadsheet. 

Remedy

By leveraging Magic ETL and using the pivot table card, I have been in a position to automate this course of action and let our Finance crew to perspective up to date triangles any time they want. I improved it even additional by applying Sort Builder, which lets the user to find a distinct evaluation day in circumstance they do not want the most new day, but want to seem at as of a specific historic day. This will save our enterprise numerous several hours each month and also enhances accuracy by utilizing this solution.

Demo

To develop the decline triangles, I leverage the group by tile and the rank and window tiles to make jogging totals. This permits me to present losses for each and every yr of a declare. I then use the pivot desk card and place the decline yr in the row and the transaction year (or months of development) in the columns and the sum in the price field. This will end result in the information and facts becoming displayed in the shape of a triangle.

See also  Victory Square Technologies Reports Full Year 2021 Financial Results & 2021 Recap

By info