1.Prioritizing Loan Portfolio Data Quality
Ranked List & Bar Chart · 2026
When managing complex capital stacks, including mezzanine debt, a loan portfolio analyst must ensure data integrity. This dashboard provides a prioritized remediation plan for data quality blockers stalling a reconciliation audit. The primary blocker is a logical mismatch where "Experience > (Age - 18)", accounting for $7.5M in gross blocked exposure across 380 records (76.3% of the total) with a priority score of 75.7. Subsequent priorities highlight missing values in Education ($897.6K, 47 records), Income ($747.4K, 42 records), and CreditScore ($661.9K, 37 records). Addressing the top issue and the $2.3M in missing-value checks resolves the bulk of the $9.9M total gross exposure at risk.
What it shows:
How to rank data anomalies by financial impact to protect loan portfolio integrity.




