Skip to content
hollywoodstarshoney

hollywoodstarshoney

Long Life Business

Primary Menu
  • Business Management
  • Business Analysis
  • News Business
  • Investment
  • Insurance
  • Banking
  • About Us
    • Privacy Policy
    • Contact Us
    • Advertise Here
    • Sitemap
  • Home
  • Creating a loss triangle | Domo
  • Insurance

Creating a loss triangle | Domo

By Patricia A. Eldridge 12 months ago




 / Creating a loss triangle

















Problem

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. 

Solution

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.

Demo

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.













Tags: American Express Business Cards, Att Business Customer Service, Att Business Internet, Att Business Login, Bad Business Codes, Bank Of America Small Business, Buffalo Business First, Business Administration Jobs, Business Administration Salary, Business Analyst Jobs, Business Card Dimensions, Business Casual Female, Business Casual For Women, Business Casual Women Outfits, Business Ideas 2021, Business Letter Example, Business License California, Business Name Search, Business Process Reengineering, Business Proposal Template, Buy A Business, Card For Business, Chase For Business, Chase Ink Business Card, Columbia Business School, Costco Business Center San Jose, Emirates Business Class, Facebook Business Account, Fictitious Business Name, Florida Business Entity Search, Ga Sos Business Search, Georgia Business Search, Google Business Email, Houston Business Journal, Illinois Business Search, Instagram Business Account, Is Lularoe Still In Business, London Business School, Master Of Business Administration, Men'S Business Casual, Pittsburgh Business Times, Qualified Business Income Deduction, Sacramento Business Journal, Secured Business Credit Card, Standard Business Card Size, T Mobile Business, Texas Business Search, Tië³´o The Business, Top Business Schools In Us, Types Of Business

Continue Reading

Previous Universal Insurance: Fundamentally Sound In Challenging Conditions (NYSE:UVE)
Next 4 Surprising Things Home Insurance May Not Cover

Archives

  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • March 2020
  • November 2018
May 2023
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  
« Apr    

Recent Posts

  • China Investment Research: Pollution Weighing Down China’s Future
  • Bank Small Business Sales Strategies – 4 Steps to Address Branch Sales Time Challenges
  • How Social Media Can Help Your Business Grow
  • Free Methods To Make Money Online
  • Managerial Economics – Application of Economic Theory in Solving Business Problems!

BL

Tags

Amazon Business Credit Card American Airlines Business Class Att Business Login Austin Business Journal Best Bank For Small Business Best Business Bank Accounts Best Business Schools In Us Best Business To Start British Airways Business Class Business Business Attire Men Business Card Ideas Business Casual Shoes For Women Business Continuity Planning Business Entity Search Business Letter Template Business Management Degree Business Manager Facebook Business Plan Outline Business School Rankings Colorado Business Search Delaware Business Entity Search Drop Shipping Business Family Business Bet Fox Business Live Georgia Sos Business Search Google Business Account Harvest Small Business Finance How To Build Business Credit Is Saturday A Business Day Is Sears Still In Business Management Microsoft 365 Business My Business Google Name Generator Business None Of Your Business Ny Sos Business Search Open A Business Bank Account Pa Business Search Plus Size Business Casual Pnc Business Banking Sos Business Search Ca Sunbiz Business Search Taking Care Of Business The Business Of Being Born
hollywoodstarshoney.com | Magazine 7 by AF themes.

WhatsApp us