From source to risk mart
01 Portfolio risk analytics
Loan portfolio risk and concentration
How can a reviewer trace an exposure alert back to the segments behind it? I checked the source grain, defined risk flags and built reusable tables in BigQuery, then connected them to an interactive Looker monitoring layer.
- Delivered
- Documented SQL, validation outputs and a portfolio monitoring dashboard.
- Decision
- Connect the portfolio alert to loan status, geographic concentration, purpose and origination cohort.
Training dataset · Illustrative internal monitoring threshold
- SQL
- BigQuery
- Looker Enterprise
- Data modelling
Further evidence in the case study: CSV exports and PDF summary