Skip to main content
DD-RSK-001-Q030 Very Hard

Where reality outruns the register

A risk score = Likelihood x Impact (1-5 each, so 1-25). Use the assessment dated on the latest quarter end in the data. For each RiskCategory, compare two shares: its share of the total residual score of all risks at the latest assessment, and its share of the total LossAmount over the whole window. Which category's loss share exceeds its score share by the most percentage points?
Expected
One RiskCategory · Scatter of score share vs loss share by category
Tables
FactRiskAssessment, FactIncidents, DimRisk · columns
  • FactRiskAssessment
  • FactIncidents
  • DimRisk
  • ResidualLikelihood
  • ResidualImpact
  • DateKey
  • LossAmount
  • RiskCategory

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