A vital need for any insurance coverage business is keep track of declare losses over time by exhibiting them in what are named “loss triangles.” Commonly, this is a incredibly manual process hunting that requires searching at the money transactions about the final yr and when the assert transpired and updating an Excel spreadsheet. By leveraging Magic ETL and working with the pivot desk card, I have been ready to automate this procedure and enable our Finance crew to look at up to date triangles any time they want. I enhanced it even even further by using Variety Builder, which lets the consumer to find a specific evaluation date in case they never want the most the latest date, but want to look at as of a specified historical date. This will save our corporation innumerable hours each month and also enhances precision by employing this resolution. To develop the loss triangles, I leverage the team by tile and the rank and window tiles to make working totals. This lets me to exhibit losses for each individual year of a claim. I then use the pivot desk card and place the decline yr in the row and the transaction yr (or months of improvement) in the columns and the sum in the worth area. This will result in the data being displayed in the shape of a triangle.
Problem
Answer
Demo