01 / The brief
The question
Build a clear Power BI dashboard that helps users explore insurance claims and understand the main reasons behind claim amounts.
This project analyzes car insurance claim data using Power BI. It includes demographic analysis, insurance claim analysis, and financial analysis. The dashboard helps users quickly understand which customer groups, car models, car makers, income groups, and age groups are linked with higher claim amounts. The dashboard includes three report pages: demographic analysis, insurance and claim analysis, and financial analysis. It uses interactive filters, KPI cards, bar charts, donut charts, pie charts, and line charts to make the insurance data easy to explore.
Results & observations
- The final dashboard gives a clear view of total claim amount, claim frequency, customer count, income patterns, insurance type, car model performance, and demographic claim trends.
- Users can quickly compare claim patterns across customer groups, vehicles, and financial segments.
Challenges
- Combining customer, vehicle, and financial data into one dashboard
- Making claim patterns easy to understand
- Designing clear filters for different user questions
- Showing large claim values in a simple format
Approach
- I cleaned and prepared the insurance data.
- I created useful measures in Power BI.
- I designed three dashboard pages for demographic, claim, and financial analysis.
- I added filters so users can explore the data by customer and vehicle details.
Implementation details
Data Preparation
Cleaned and prepared the insurance claims data.
Data Modeling
Created the Power BI data model and connected the main fields.
DAX Development
Built measures for claim amount, claim frequency, income, and customer totals.
Dashboard Design
Designed demographic, insurance claim, and financial analysis pages.
Interactive Filters
Added slicers for gender, marital status, car model, car maker, age group, income range, and coverage zone.
Visual Formatting
Formatted charts and KPI cards so business users can read the dashboard easily.
Explore the report
Select a screenshot for a larger view.