← Yanchen Zhou

Project demo · synthetic data

Exception Pool Exits dashboard

This is one of the data analysis dashboards in the automated workflow I built for BBVA's Risk & Profitability team. The team monitors and optimises the bank's asset portfolio, and every month it has to answer one question: which contracts left the Exception Pool, and why. That used to mean reconciling spreadsheets from several markets by hand. The dashboard automates that step: filters apply everywhere, there are six tabs, and each chart carries a one-line summary that follows the filters. This page is a rebuild on synthetic data.

Disclaimer. Every number, client, market and product on this page is generated by an algorithm. No bank data, code or branding is used; layout and features are rebuilt for demonstration.

Track 1 Deterministic computation layer

Source sheets per market→Script layer: config-driven readers, unit normalisation, reconciliation checks→Web dashboard

Every number comes from this layer. Same input, same output, auditable cell by cell.

Track 2 AI agent interface

Request in plain language→Agent: asks for the exact structure, flags every assumption, never guesses a cell→Triggers or extends Track 1

The agent handles intent and workflow. It never does the arithmetic.

Exception Pool Exits 2026

DEMO · simulated data

EP Waterfall

€ thousands

Start-of-range stock, less each exit reason and other changes, plus entries, equals end-of-range stock. Follows the From, To, Market and Term filters.

Market detail

Aggregated over the filtered period

Monthly trend by reason

Sum of selected markets

Total share by reason

Filtered period, selected markets

Reason mix per month

Stacked column: composition changes month over month

Stock: LT vs ST € bn

Stacked area, RWA, monthly

Pool entries: LT vs ST € bn

Stacked area, RWA, monthly

Exits: LT vs ST € bn

Stacked area, RWA, monthly

LT share of stock RWA, by market

Latest month in range. Market C is not split by term at source and is excluded here.

Client concentration € bn

Bars: client RWA, top 20 shown, plus the rest of the pool. Line: cumulative share of the pool. Based on the Jun'26 pool, top 20 clients per market.

Top 10 vs pool € bn

Selected markets

Top 10 clients by RWA € bn

Across selected markets

Top clients (Jun'26 pool, top 20)

Top 20 clients per market from the Jun'26 pool, ranked by RWA. Not affected by the date range. Click a row for product-level detail.