A essential want for any insurance coverage firm is the flexibility to trace declare losses over time by displaying them in what are known as “loss triangles.” Sometimes, this can be a very guide course of that includes taking a look at monetary transactions over the past yr, figuring out when the claims occurred, and updating an Excel spreadsheet accordingly. By leveraging Magic ETL and utilizing the pivot desk card, I’ve been in a position to automate this course of and permit members of our finance group to view up to date triangles any time they need. I enhanced it even additional by utilizing Type Builder, which permits the person to pick a selected analysis date in case they don’t need the newest date however do wish to have a look at a sure historic date. This protects our firm numerous hours every month and likewise improves accuracy. To supply the loss triangles, I leverage the group by tile and the rank and window tiles to create operating totals. This permits me to point out losses for annually of a declare. I then use the pivot desk card and place the loss yr within the row, the transaction yr (or months of improvement) within the columns, and the quantity within the worth subject. This ends in the knowledge being displayed within the form of a triangle:
Drawback
Answer
Demo
