OBT One Big Table Consulting
Credit Risk

TransUnion — Alternative Data Credit Model

Alt-data underwriting model that lifts approval rates on thin-file consumers while holding loss rates flat — backed by a full analytics dashboard and executive deck.

Dashboard

Interactive KPI dashboard — the live working version embedded below.

Sample Data

A live preview of the raw sample data used in this analysis. Use the download tab for the full file.

Sheet Model Performance · showing 16 rows.
TransUnion — Rent Payment Data as Alternative Credit Signal
Model Performance Summary | Bureau-Only (Baseline) vs. Bureau + Rent Data (Enhanced)
MetricBaseline (Bureau Only)Enhanced (Bureau + Rent)Improvement% ChangeBusiness Interpretation
AUC Score0.720.79+0.07+9.7%Model correctly ranks borrowers 7% more often
KS Statistic4049+9 pts+22.5%Risk separation improved by 22.5%
True Positive Rate @ 20% FPR52%61%+9 pts+17.3%9% more bad borrowers caught at same approval rate
Thin-File Coverage56%74%+18 pts+32.1%74% of credit-invisible consumers now scoreable
Population Scoreable75%93.5%+18.5 pts+24.7%18.5M new consumers enter the credit market
Default Rate (model top decile)2.1%1.4%-0.7 pts-33.3%Top tier applicants 33% less likely to default
Default Rate (model bottom decile)24.8%28.3%+3.5 pts+14.1%Riskiest segment identified more precisely
Gini Coefficient0.440.58+0.14+31.8%Overall discriminatory power up 32%
ModelAUC Score
Baseline0.72
Enhanced0.79
Sheet ROC Curve Data · showing 18 rows.
ROC Curve — False Positive Rate vs. True Positive Rate
Score ThresholdFPR — Baseline (Bureau Only)TPR — Baseline (Bureau Only)FPR — Enhanced (Bureau + Rent)TPR — Enhanced (Bureau + Rent)
10000
20.050.220.050.3
30.10.350.10.44
40.150.440.150.54
50.20.520.20.61
60.250.580.250.67
70.30.630.30.72
80.350.680.350.76
90.40.720.40.8
100.450.760.450.84
110.50.790.50.86
120.60.840.60.9
130.70.890.70.93
140.80.930.80.96
150.90.970.90.98
161111
Sheet KS Distribution · showing 13 rows.
KS Statistic — Cumulative Distribution of Good vs. Bad Borrowers
Score DecileGood Borrowers Cumulative %Bad Borrowers Cumulative %KS Gap (Bad − Good)
0000
100.010.030.02
200.020.070.05
300.040.130.09
400.070.20.13
500.110.280.17
600.160.370.21
700.220.460.24
800.290.550.26
900.370.63← Max KS = 26 pts
1000.460.70.24
Sheet Applicant Portfolio (500 Record · showing 100 rows of many (truncated).
Applicant IDSegmentBureau ScoreRent Payment ScoreBaseline Risk ScoreEnhanced Risk ScoreThin File FlagActual OutcomeBaseline DecisionEnhanced DecisionCorrect BaselineCorrect EnhancedModel Improvement
APP-00001Thin-File PrimeN/A750.1270.107YesPaidApproveApproveCorrectCorrectSame
APP-00002Prime746910.0640.028NoPaidApproveApproveCorrectCorrectSame
APP-00003Near-Prime624550.0890.089NoPaidApproveApproveCorrectCorrectSame
APP-00004Thin-File PrimeN/A920.0780.041YesPaidApproveApproveCorrectCorrectSame
APP-00005Near-Prime648690.1390.125NoPaidApproveApproveCorrectCorrectSame
APP-00006Prime760920.0450.01NoPaidApproveApproveCorrectCorrectSame
APP-00007Prime806730.0260.01NoPaidApproveApproveCorrectCorrectSame
APP-00008Thin-File SubprimeN/A490.2530.259YesDefaultDeclineDeclineCorrectCorrectSame
APP-00009Near-Prime635670.0880.076NoPaidApproveApproveCorrectCorrectSame
APP-00010Thin-File PrimeN/A860.1120.081YesPaidApproveApproveCorrectCorrectSame
APP-00011Prime778940.0370.01NoPaidApproveApproveCorrectCorrectSame
APP-00012Prime745820.0370.01NoPaidApproveApproveCorrectCorrectSame
APP-00013Near-Prime667660.1010.09NoPaidApproveApproveCorrectCorrectSame
APP-00014Subprime582240.3440.375NoDefaultDeclineDeclineCorrectCorrectSame
APP-00015Thin-File PrimeN/A800.1020.077YesPaidApproveApproveCorrectCorrectSame
APP-00016Subprime588550.2390.239NoPaidDeclineDeclineIncorrectIncorrectSame
APP-00017Thin-File SubprimeN/A310.2460.27YesDefaultDeclineDeclineCorrectCorrectSame
APP-00018Prime788720.0330.016NoPaidApproveApproveCorrectCorrectSame
APP-00019Subprime540330.3570.379NoPaidDeclineDeclineIncorrectIncorrectSame
APP-00020Subprime558290.2520.278NoDefaultDeclineDeclineCorrectCorrectSame
APP-00021Near-Prime653780.1380.115NoPaidApproveApproveCorrectCorrectSame
APP-00022Near-Prime648590.1310.127NoDefaultApproveApproveIncorrectIncorrectSame
APP-00023Prime748740.0580.039NoPaidApproveApproveCorrectCorrectSame
APP-00024Near-Prime628670.1180.106NoPaidApproveApproveCorrectCorrectSame
APP-00025Near-Prime690550.1480.148NoDefaultApproveApproveIncorrectIncorrectSame
APP-00026Subprime596370.3880.406NoPaidDeclineDeclineIncorrectIncorrectSame
APP-00027Prime760840.020.01NoPaidApproveApproveCorrectCorrectSame
APP-00028Thin-File PrimeN/A910.1290.093YesPaidApproveApproveCorrectCorrectSame
APP-00029Prime796900.050.015NoPaidApproveApproveCorrectCorrectSame
APP-00030Near-Prime640720.1750.158NoPaidDeclineDeclineIncorrectIncorrectSame
APP-00031Subprime576400.3120.327NoDefaultDeclineDeclineCorrectCorrectSame
APP-00032Near-Prime659620.0860.079NoPaidApproveApproveCorrectCorrectSame
APP-00033Subprime510510.40.404NoPaidDeclineDeclineIncorrectIncorrectSame
APP-00034Near-Prime636590.1460.142NoPaidApproveApproveCorrectCorrectSame
APP-00035Prime828760.0760.055NoPaidApproveApproveCorrectCorrectSame
APP-00036Thin-File PrimeN/A840.0960.067YesPaidApproveApproveCorrectCorrectSame
APP-00037Near-Prime686690.0920.078NoPaidApproveApproveCorrectCorrectSame
APP-00038Prime778880.0330.01NoPaidApproveApproveCorrectCorrectSame
APP-00039Thin-File PrimeN/A820.0660.039YesDefaultApproveApproveIncorrectIncorrectSame
APP-00040Prime780780.060.037NoPaidApproveApproveCorrectCorrectSame
APP-00041Prime841770.0670.045NoPaidApproveApproveCorrectCorrectSame
APP-00042Prime744910.0460.01NoPaidApproveApproveCorrectCorrectSame
APP-00043Near-Prime713560.1470.146NoPaidApproveApproveCorrectCorrectSame
APP-00044Prime823930.040.01NoPaidApproveApproveCorrectCorrectSame
APP-00045Prime768870.0470.015NoPaidApproveApproveCorrectCorrectSame
APP-00046Prime783720.0470.03NoPaidApproveApproveCorrectCorrectSame
APP-00047Near-Prime626750.180.16NoPaidDeclineDeclineIncorrectIncorrectSame
APP-00048Subprime618350.2250.245NoPaidDeclineDeclineIncorrectIncorrectSame
APP-00049Prime822710.030.014NoDefaultApproveApproveIncorrectIncorrectSame
APP-00050Near-Prime678640.1220.113NoPaidApproveApproveCorrectCorrectSame
APP-00051Subprime571510.2220.226NoPaidDeclineDeclineIncorrectIncorrectSame
APP-00052Subprime574540.1960.197NoPaidDeclineDeclineIncorrectIncorrectSame
APP-00053Prime842860.0750.044NoPaidApproveApproveCorrectCorrectSame
APP-00054Prime850720.0710.054NoPaidApproveApproveCorrectCorrectSame
APP-00055Prime780820.0270.01NoPaidApproveApproveCorrectCorrectSame
APP-00056Prime730890.0250.01NoPaidApproveApproveCorrectCorrectSame
APP-00057Near-Prime660630.10.092NoPaidApproveApproveCorrectCorrectSame
APP-00058Prime821740.060.041NoPaidApproveApproveCorrectCorrectSame
APP-00059Prime738700.0470.032NoPaidApproveApproveCorrectCorrectSame
APP-00060Subprime509540.2380.239NoPaidDeclineDeclineIncorrectIncorrectSame
APP-00061Subprime612240.4170.448NoPaidDeclineDeclineIncorrectIncorrectSame
APP-00062Prime797890.0790.045NoPaidApproveApproveCorrectCorrectSame
APP-00063Near-Prime705720.110.093NoPaidApproveApproveCorrectCorrectSame
APP-00064Subprime517360.2110.23NoDefaultDeclineDeclineCorrectCorrectSame
APP-00065Near-Prime654640.140.131NoPaidApproveApproveCorrectCorrectSame
APP-00066Prime787860.0490.018NoPaidApproveApproveCorrectCorrectSame
APP-00067Thin-File SubprimeN/A320.3270.35YesPaidDeclineDeclineIncorrectIncorrectSame
APP-00068Prime805940.0280.01NoPaidApproveApproveCorrectCorrectSame
APP-00069Prime833870.0620.03NoPaidApproveApproveCorrectCorrectSame
APP-00070Prime758870.0220.01NoPaidApproveApproveCorrectCorrectSame
APP-00071Near-Prime675590.0840.08NoPaidApproveApproveCorrectCorrectSame
APP-00072Subprime610220.4230.456NoDefaultDeclineDeclineCorrectCorrectSame
APP-00073Prime746810.0670.041NoPaidApproveApproveCorrectCorrectSame
APP-00074Near-Prime699780.0950.072NoPaidApproveApproveCorrectCorrectSame
APP-00075Subprime602310.4180.442NoDefaultDeclineDeclineCorrectCorrectSame
APP-00076Thin-File PrimeN/A850.130.1YesPaidApproveApproveCorrectCorrectSame
APP-00077Thin-File PrimeN/A820.0840.057YesPaidApproveApproveCorrectCorrectSame
APP-00078Prime729850.0330.01NoPaidApproveApproveCorrectCorrectSame
APP-00079Near-Prime659620.1020.095NoPaidApproveApproveCorrectCorrectSame
APP-00080Near-Prime655570.1770.175NoPaidDeclineDeclineIncorrectIncorrectSame
APP-00081Thin-File PrimeN/A870.1210.089YesPaidApproveApproveCorrectCorrectSame
APP-00082Prime727730.0730.055NoPaidApproveApproveCorrectCorrectSame
APP-00083Near-Prime653560.0910.09NoPaidApproveApproveCorrectCorrectSame
APP-00084Thin-File PrimeN/A850.0990.069YesPaidApproveApproveCorrectCorrectSame
APP-00085Prime768780.0230.01NoPaidApproveApproveCorrectCorrectSame
APP-00086Near-Prime688760.1520.131NoPaidDeclineApproveIncorrectCorrectBetter
APP-00087Thin-File PrimeN/A860.0990.068YesPaidApproveApproveCorrectCorrectSame
APP-00088Subprime579400.3590.374NoDefaultDeclineDeclineCorrectCorrectSame
APP-00089Subprime564390.360.376NoPaidDeclineDeclineIncorrectIncorrectSame
APP-00090Thin-File PrimeN/A920.0710.034YesPaidApproveApproveCorrectCorrectSame
APP-00091Subprime586310.3460.37NoPaidDeclineDeclineIncorrectIncorrectSame
APP-00092Near-Prime620640.1090.1NoPaidApproveApproveCorrectCorrectSame
APP-00093Near-Prime703650.1260.116NoPaidApproveApproveCorrectCorrectSame
APP-00094Prime841950.0740.034NoPaidApproveApproveCorrectCorrectSame
APP-00095Prime741790.0510.027NoPaidApproveApproveCorrectCorrectSame
APP-00096Prime780910.0390.01NoPaidApproveApproveCorrectCorrectSame
APP-00097Prime731770.0790.057NoPaidApproveApproveCorrectCorrectSame
APP-00098Thin-File SubprimeN/A440.2830.294YesPaidDeclineDeclineIncorrectIncorrectSame
APP-00099Prime818850.0440.014NoPaidApproveApproveCorrectCorrectSame
APP-00100Thin-File PrimeN/A780.130.107YesPaidApproveApproveCorrectCorrectSame
Sheet Business Impact · showing 12 rows.
Business Impact Calculator — Rent Payment Data Adoption
INPUT ASSUMPTIONSPROJECTED RESULTS
Annual Loan Applications500000MetricValue
Baseline Default Rate0.08Baseline Defaults40000
Average Loss Per Default ($)8000Defaults (with Rent Data)#VALUE!
AUC Lift from Rent Data0.07Defaults Avoided#VALUE!
Thin-File Share of Portfolio0.25Gross Loss Reduction ($)#VALUE!
% Thin-Files Newly Scoreable0.74Data Acquisition Cost ($)1200000
Data Acquisition Cost (annual $)1200000Net Annual ROI ($)#VALUE!
ROI Multiple#VALUE!
New Scoreable Consumers92500
Default Rate Improvement#VALUE!
Sheet Global Market Feasibility · showing 7 rows.
Global Market Prioritization — Rent Payment Alternative Data
FlagMarketAUC LiftData DensityRegulatory PathPredictive Strength (0-100)Data Density ScoreRegulatory ScoreFeasibility ScoreDecision & Rationale
🇺🇸United States+0.0735%FCRA — Established93829088✅ LAUNCH — Clear FCRA framework, 35% PropTech density, largest thin-file market (~62M)
🇬🇧United Kingdom+0.0528%GDPR — Consent achiev.78717374🚀 PILOT — FCA supportive of alt data; GDPR consent model achievable via tenancy sign-up
🇧🇷Brazil+0.0422%LGPD — Obtainable64605861📋 ASSESS Q3 — Nubank ecosystem + Cadastro Positivo precedent; local legal required
🇲🇽Mexico+0.0212%Mixed / Fragmented41324238⏳ MONITOR — Cash-heavy rental market; re-assess when digital density > 20%
🇮🇳India+0.018%PDPB — Pending28182022🚫 DEFER 18–24M — PDPB not enacted; 8% density insufficient; monitor PDPB progress
Sheet Score Decile Analysis · showing 13 rows.
Score Decile Analysis — Default Rate Comparison by Risk Band
Score DecileScore Range# Applicants% of PortfolioDefault Rate (Baseline)Default Rate (Enhanced)LiftDefaults AvoidedLost Revenue Prevented ($)
1900-8505000010%0.0080.005-0.0031501200000
2849-8005000010%0.0140.01-0.0042001600000
3799-7505000010%0.0240.018-0.0063002400000
4749-7005000010%0.0380.029-0.0094503600000
5699-6505000010%0.0620.049-0.0136505200000
6649-6005000010%0.0930.075-0.0189007200000
7599-5505000010%0.1380.112-0.026130010400000
8549-5005000010%0.1970.163-0.034170013600000
9499-4505000010%0.2710.228-0.043215017200000
10<4505000010%0.3580.305-0.053265021200000
TOTAL / WEIGHTED AVG0.12030.0994-0.0208999999999999951045083600000

Downloads

Source artefacts behind this analysis — case study writeups, raw data, and deliverable templates.

XLSX
TU_AltData_DemoData.xlsx Excel Data · ~67 KB Download →
DOCX
TU_AltData_ExecutiveReport.docx Word Document · ~47 KB Download →
PPTX
TU_AltData_ExecutivePresentation.pptx Slide Deck · ~59 KB Download →
IPYNB
TU_AltData_ProofOfConcept.ipynb Jupyter Notebook · ~1,161 KB Download →