Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hi!
This is a tool for underwriters and finance department. This helps very quickly to find out the minimum rate and the minimum insurance premium. The data is based on insurance statistics for 2 years. This is the data of one large insurance company.
The Average sum insured = 100% valid (insurance) cost of the car.
The Combined Ratio = Loss Ratio + % of acquisitions. Check 85% - an acceptable level of loss.
Quality data = data providing a large percentage of the sample. "GOOD" is qualitative data, "BAD" - Incorrect data and small statistics.
MIN Rate - minimum rate with average sum insured.
MIN Premium - minimum insurance premium total.
Other brand, model - brand and model with small statistics.
*by Alexey Malashenko
eyJrIjoiZDQzYjg0OGItYjFjNC00OTE5LThhODAtOWVmZDdlYjJmYzM1IiwidCI6IjJkNzIwNGFjLWMxNDEtNDc3MC1iZGIxLTQ2ZDQ1OTQxNDYyYiIsImMiOjF9