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

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.