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

Executive scorecard

Prepare a one-page scorecard: net sales, margin %, discount rate, return rate, stockout rate, top store, top category, promotion share and a next-month plan equal to the last three months' average uplifted by 8%.
Expected
Executive scorecard · Scorecard
Tables
FactSalesTransactions, DimDate, DimStore, DimProduct +1 · columns
  • FactSalesTransactions
  • DimDate
  • DimStore
  • DimProduct
  • DimPromotion
  • NetSalesSAR
  • GrossMarginSAR
  • DiscountSAR
  • ReturnFlag
  • StockoutFlag
  • TransactionDateKey

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.