Skip to main content
DD-RSK-001-Q028 Hard

The risk the register got wrong

A risk score = Likelihood x Impact (1-5 each, so 1-25). Use the assessment dated on the latest quarter end in the data. Among the risks whose residual score at that assessment is 2 or less (the bottom of the register), which one (RiskCode) has the highest total LossAmount over the whole window?
Expected
One RiskCode · KPI card
Tables
FactRiskAssessment, FactIncidents, DimRisk · columns
  • FactRiskAssessment
  • FactIncidents
  • DimRisk
  • ResidualLikelihood
  • ResidualImpact
  • DateKey
  • LossAmount
  • RiskCode

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