Skip to main content
DD-RET-004 Enterprise Retail Profitability and Inventory Optimisation Get the data →
DD-RET-004-Q042 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.

Create a free account Sign in