Car Insuance KPI Report

The Car Shield Power BI KPI report provides a comprehensive overview of the company’s car insurance operations. The dashboard is divided into three sections: Customer Demographics, Claims and Insurance, and Finance.

The Customer Demographics section provides information on the company’s customer base, including age group, average age, marital status, parental status, education level, and gender. This information can help the company better understand their customers and tailor their services accordingly.

The Claims and Insurance section displays data on claims filed, claims paid, and other insurance-related metrics. This includes information on the top 10 car models with the highest average insurance claims, average insurance claims, total insurance claims, average claims by coverage zone, and average age of customers by insurance claim frequency (1-4). This information can help the company identify trends and patterns in claims and improve their risk management strategies.

The Finance section provides financial information such as average insurance claim amount, average household income, distribution of customers by income group, average claim amount by coverage zone and income group, and a decomposition tree analyzing average household income by coverage zone and age group. This information can help the company better understand their financial performance and make informed decisions.

Overall, this dashboard is designed to provide valuable insights to both the company and their agents, allowing them to make informed decisions and improve their operations.