1.Analyzing Financial Gaps in Portfolios
text summary, table, and scatter plot · 2026
This dashboard enables an insurance claims analyst to investigate systemic underpayment across a portfolio of flood and water-damage claims. The text highlights a cumulative payout gap of $33.1M, with payouts covering only 93.9% of assessed damage, affecting 79.8% of claims with a typical shortfall of $2.0K, while Deductible E shows a 100% shortfall frequency across 24 claims, averaging a $79.0K gap per claim (average damage $265.2K vs. average paid $186.2K), and Deductible D averages a $39.5K gap. A scatter plot plots a sample of 1,200 claims against a diagonal parity line to visually separate underpaid claims, and Cause 2 has the highest average shortfall ($6.1K) while Cause 4 drives volume (4,754 claims).
What it shows:
How to quantify structural financial discrepancies for compliance reporting.




