1.Identifying Systemic Financial Gaps
text summary, table, and scatter plot · 2026
This dashboard enables an insurance claims analyst to investigate systemic underpayment across a portfolio, illustrating a method useful for auditing financial discrepancies in commercial real estate leases. The portfolio readout summarizes a cumulative payout gap of $33.1M, with payouts covering only 93.9% of assessed damage and affecting 79.8% of claims with a typical shortfall of $2.0K. A data table reveals Deductible E has a 100% shortfall frequency across 24 claims, averaging a $79.0K gap per claim (average damage $265.2K vs. average paid $186.2K), while Deductible D shows a $39.5K average gap. A scatter plot plots a sample of 1,200 claims against a diagonal parity line.
What it shows:
How to visualize structural payout discrepancies and financial shortfalls across a large portfolio.




