Home
/
Credit Risk & Banking
/
Mission 21
caseSQL
Credit Risk & Banking Path · Mission 21 of 30
Expert
PSI — score distribution vs baseline
CTE + bucketing + natural-log math to compute the Population Stability Index
Unlock with Pro
→
Back to Credit Risk & Banking
The Brief
You'll practice
CTE
Bucketing
Population stability
← Previous
Mission 20
Next →
Mission 22
All 30 missions in Credit Risk & Banking Path
↓
1.
Peek at the customer book
2.
What products do we book?
3.
Open accounts right now
4.
Active deposit customers by state
5.
Customer vs account — know the grain
6.
Reversals and chargebacks — clean the spend total
7.
Delinquency bucket snapshot
8.
FICO band distribution at origination
9.
Approval rate by FICO band
10.
Joint accounts — who’s the primary?
11.
Monthly net charge-off rate by product
12.
Vintage originations pacing
13.
Velocity feature — auths in 1 hour
14.
Structuring flag — sub-$10K cash deposits
15.
Dormant account audit
16.
Vintage curve — 90+ DPD by MOB
17.
Roll-rate transition matrix
18.
Rolling velocity — ≥5 auths in 10 minutes
19.
Same-day amount-swing flag
20.
Quarter-end balance snapshot (Y-9C style)
21.
PSI — score distribution vs baseline
22.
KS statistic on PD model scores
23.
CECL lifetime loss projection by vintage
24.
Champion–challenger collections backtest
25.
Portfolio risk scorecard capstone
26.
Charge-off rate by product — FICO band heatmap
27.
Vintage delinquency drift YoY (12-MOB)
28.
Chargeback risk score by merchant category
29.
Product portfolio risk summary
30.
CRO board scorecard capstone