Skip to main content
Data Dare retail L4 sticker: the findi360 mascot analysing Enterprise Retail Profitability and Inventory Optimisation.

DD-RET-004

Enterprise Retail Profitability and Inventory Optimisation

Decide where actuals miss budget and whether volume or price is to blame, which suppliers put availability at risk, and where inventory should sit.

  • Retail
  • L4 · PARQUET
  • ~6,000,000 rows
  • 18 tables
  • 60 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-004_Question_Book.pdf 1.3 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-RET-004_Data_Dictionary.xlsx 15.3 KB · v1.0
  • Business Introduction PDF DD-RET-004_Business_Introduction.pdf 614.1 KB · v1.0
  • Relationship Diagram PDF DD-RET-004_Relationship_Model.pdf 618.9 KB · v1.0
  • Raw fact data DD-RET-004_FactSalesTransactions.parquet 195.7 MB · v1.0
  • Dimension / supporting data DD-RET-004_Supporting_Tables.zip 42 MB · v1.0

Questions

Open one to discuss it
  1. Q007 Medium Peak sales month
  2. Q008 Medium Weakest sales month
  3. Q009 Medium Channel with the highest return rate
  4. Q010 Medium Top supplier by sales
  5. Q011 Medium Returns by return month
  6. Q012 Medium Same-day fulfilment rate
  7. Q013 Medium Payment method with the highest decline rate
  8. Q014 Medium Processing fees paid
  9. Q015 Medium Top customer by spend
  10. Q016 Medium Loyalty tier with the highest spend per transaction
  11. Q017 Medium Inventory shrinkage value
  12. Q018 Medium Region with the highest margin rate
  13. Q019 Medium Supplier on-time delivery rate
  14. Q020 Medium Net sales versus budget
  15. Q021 Medium Busiest distribution centre

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.