Skip to main content
DD-RET-003 Omnichannel Sales, Customer Behaviour and Commercial Risk Get the data →
DD-RET-003-Q033 Hard

Store risk score

Score every store on stockout rate, return rate and margin rate (rank each, lowest margin scores highest). Which store has the highest combined risk?
Expected
Store risk matrix; leading row · Risk matrix
Tables
FactSalesTransactions, DimStore · columns
  • FactSalesTransactions
  • DimStore
  • StockoutFlag
  • ReturnFlag
  • GrossMarginSAR
  • NetSalesSAR
  • StoreID

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.

Create a free account Sign in