Skip to main content
Data Dare retail L2 sticker: the findi360 mascot analysing Inventory, Promotions and Product Profitability.

DD-RET-002

Inventory, Promotions and Product Profitability

Decide which promotions dilute margin, which channels drive returns, and which categories are sitting on stock they cannot sell.

  • Retail
  • L2 · CSV
  • ~30,000 rows
  • 8 tables
  • 40 questions

Get the data

v1.0 · 6 files

Files are for members. A free account takes a minute, and you come straight back here.

  • Question Book PDF DD-RET-002_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-RET-002_Data_Dictionary.xlsx 12 KB · v1.0
  • Business Introduction PDF DD-RET-002_Business_Introduction.pdf 613.8 KB · v1.0
  • Relationship Diagram PDF DD-RET-002_Relationship_Model.pdf 614.3 KB · v1.0
  • Raw fact data DD-RET-002_FactSalesTransactions.csv 2.3 MB · v1.0
  • Dimension / supporting data DD-RET-002_Dimensions.zip 628.5 KB · v1.0

Questions

Open one to discuss it
  1. Q017 Medium Peak sales month
  2. Q018 Medium Weakest sales month
  3. Q019 Medium Year-on-year net sales growth
  4. Q020 Medium Best margin month
  5. Q021 Medium Highest stockout month
  6. Q022 Medium Strongest quarter
  7. Q023 Medium Cumulative net sales to period end
  8. Q024 Medium Store with the best margin rate
  9. Q025 Medium Store with the worst stockout rate
  10. Q026 Medium Category with the weakest margin rate
  11. Q027 Medium Top-five product concentration
  12. Q028 Medium Promotion margin dilution
  13. Q029 Medium Private label versus national brand
  14. Q030 Medium Channel with the highest return rate
  15. Q031 Medium Top supplier by sales
  16. Q032 Medium Returns by return month
  17. Q033 Medium Same-day fulfilment rate
  18. Q034 Medium Latest inventory value
  19. Q035 Medium Lines below reorder point
  20. Q036 Medium Store with the lowest days of supply

General discussion

Anything about this dataset that is not one question — loading the files, which tool, how you set it up.

A free account takes a minute. Your draft is kept while you sign in.