1.Identifying Systemic Gaps in Portfolio Payouts
gap analysis · 2026
An insurance claims analyst used a dashboard featuring a text summary, table, and scatter plot to investigate systemic underpayment across flood and water-damage claims. The portfolio readout identified a cumulative payout gap of $33.1M, noting that payouts covered only 93.9% of assessed damage and affected 79.8% of claims with a typical shortfall of $2.0K. The data table revealed that Deductible E had a 100% shortfall frequency across 24 claims, averaging a $79.0K gap per claim, while Deductible D showed a $39.5K average gap. A scatter plot compared a sample of 1,200 claims against a diagonal parity line to visually separate underpaid claims.
What it shows:
How to use scatter plots and data tables to isolate systemic financial discrepancies within a large portfolio.




