Skip to main content
DD-ECL-001-Q024 Medium

The riskiest segment on the books

The ECL allowance at a month end: a customer whose CreditImpairedDate is on or before that date is provided at 100% of its balance (the specific allowance); every other balance is multiplied by the LossRatePct for its customer's Segment and its Bucket, taken from the MatrixVersion in force on that date (the version with the latest EffectiveFrom on or before it) - the collective allowance. Which Segment has the highest coverage (total allowance / Balance) at the latest month end in the data (30 September 2026)?
Expected
One Segment · KPI card
Tables
FactAgeingSnapshot, DimCustomer, DimProvisionMatrix · columns
  • FactAgeingSnapshot
  • DimCustomer
  • DimProvisionMatrix
  • Balance
  • Segment
  • LossRatePct
  • CreditImpairedDate

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us