Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Your file has been submitted successfully. We’re processing it now - please check back in a few minutes to view your report.
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