nahid-rgb/EIC-Vehicle-Insurance-Dashboard

A Power BI dashboard analyzing vehicle insurance data (2014–2018) from the Ethiopian Insurance Corporation, focusing on trends in claims, premiums, vehicle types, and user behavior. # Ethiopian Vehicle Insurance Dashboard (2014–2018) ## Dashboard Preview ## Key Insights - Visualized multi-year trends in vehicle insurance premiums and claims using historical data from 2014 to 2018. - Identified top vehicle types and manufacturers purchasing policies, including motorcycles, trucks, and brands like Toyota and Bajaj. - Compared average premiums and claims across different vehicle usages such as agricultural, public transport, and commercial services. - Displayed claim frequency and volume with interactive visuals including heatmaps, area charts, and scatter plots. - Analyzed gender-based claim behavior and yearly shifts in insurance activity. - Enabled filtering and drill-down by year to track evolving risk profiles and policy patterns. ## Tools & Technologies - Power BI | Excel | DAX | Power Query ## Project Files - **Icons** (image assets) - **motor_data14-2018.xlsx** (raw dataset) - **EIC_insurance_dashboard.pbix** (Power BI dashboard) ## About This Project This dashboard project presents an end-to-end insurance analytics solution using real-world data from the Ethiopian Insurance Corporation. Built in Power BI, it helps visualize and analyze trends in vehicle insurance coverage, claim behavior, and risk distribution across multiple years and vehicle categories. The project demonstrates the ability to transform raw insurance data into actionable insights for operational and strategic decision-making.