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 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.

Create a free account Sign in
  • 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. Q001 Easy Total net sales for the period
  2. Q002 Easy Gross sales before promotions
  3. Q003 Easy Total discount given away
  4. Q004 Easy Cost of goods sold
  5. Q005 Easy Gross margin earned
  6. Q006 Easy Gross margin percentage
  7. Q007 Easy Units sold
  8. Q008 Easy Discount rate on gross sales
  9. Q009 Easy Store count in the network
  10. Q010 Easy Product range size
  11. Q011 Easy Top store by net sales
  12. Q012 Easy Top category by net sales
  13. Q013 Easy Fastest-moving product
  14. Q014 Easy Stockout pressure rate
  15. Q015 Easy Returned transactions
  16. Q016 Easy Average basket value per transaction
  17. Q017 Medium Peak sales month
  18. Q018 Medium Weakest sales month
  19. Q019 Medium Year-on-year net sales growth
  20. Q020 Medium Best margin month
  21. Q021 Medium Highest stockout month
  22. Q022 Medium Strongest quarter
  23. Q023 Medium Cumulative net sales to period end
  24. Q024 Medium Store with the best margin rate
  25. Q025 Medium Store with the worst stockout rate
  26. Q026 Medium Category with the weakest margin rate
  27. Q027 Medium Top-five product concentration
  28. Q028 Medium Promotion margin dilution
  29. Q029 Medium Private label versus national brand
  30. Q030 Medium Channel with the highest return rate
  31. Q031 Medium Top supplier by sales
  32. Q032 Medium Returns by return month
  33. Q033 Medium Same-day fulfilment rate
  34. Q034 Medium Latest inventory value
  35. Q035 Medium Lines below reorder point
  36. Q036 Medium Store with the lowest days of supply
  37. Q037 Hard Category inventory-profit action matrix
  38. Q038 Hard Return-rate exception categories
  39. Q039 Very Hard Executive scorecard
  40. Q040 Very Hard Working-capital view: inventory versus sales

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.

Create a free account Sign in