# Power BI Claims Dashboard Starter Blueprint

This starter blueprint pairs with `power-bi-claims-dashboard-sample.csv`. Use it to build a claims dashboard in Power BI Desktop or another BI tool.

## Suggested Pages

### Page 1: Executive Claims Overview
- KPI cards: total claims, open claims, total paid, total reserve, total incurred, average incurred
- Line chart: incurred by loss month
- Bar chart: incurred by line of business
- Table: top 10 claims by incurred

### Page 2: Frequency and Severity
- Claim count by month
- Average incurred by line of business
- Median incurred by line of business
- Scatter chart: paid vs reserve

### Page 3: Open Claims and Reserve Pressure
- Open claims by status
- Reserve by line of business
- Claims with reserve greater than paid
- Aging from reported date to today

### Page 4: Loss Drivers
- Cause of loss by claim count
- Cause of loss by incurred
- Country and region breakdown
- Large loss filter

## Starter DAX Measures

```DAX
Total Claims = COUNTROWS(Claims)

Open Claims =
CALCULATE(
    COUNTROWS(Claims),
    Claims[status] = "Open"
)

Closed Claims =
CALCULATE(
    COUNTROWS(Claims),
    Claims[status] = "Closed"
)

Total Paid = SUM(Claims[paid])

Total Reserve = SUM(Claims[reserve])

Total Incurred = SUM(Claims[incurred])

Average Incurred = AVERAGE(Claims[incurred])

Reserve to Incurred % =
DIVIDE([Total Reserve], [Total Incurred])

Large Loss Count =
CALCULATE(
    COUNTROWS(Claims),
    Claims[incurred] >= 50000
)
```

## Recommended Columns
- claim_reference
- policy_reference
- line_of_business
- loss_date
- reported_date
- status
- country
- region
- cause_of_loss
- paid
- reserve
- incurred

## Data Quality Checks
- Incurred should equal paid plus reserve unless recoveries or fees are handled separately.
- Loss date should not be after reported date.
- Open claims should usually have reserve reviewed.
- Claim references should be unique.
- Currency should be added if the portfolio includes multiple currencies.