1.Financial Reconciliation and Outlier Detection
KPIs and scatter plot · 2026
A banking audit team utilized a dashboard featuring KPIs, a bar chart, and a scatter plot to track $15.28B in total deposits across 100 institutions against $19.64B in total assets. The analysis highlighted a portfolio median deposit-to-asset ratio of 80.7% and a leverage reference of 7.77x, while isolating 2 outlier institutions representing $119.6M in deposits. By replacing manual Excel formula calculations, the user automatically surfaced anomalous institutions—including top deposit holders like JPMorgan Chase Bank NA at $2.49B and Bank of America NA at $2.02B—that might have been missed in a dense spreadsheet.
What it shows:
How to automate the detection of financial anomalies across large asset portfolios.




