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

Create a free account Sign in
  • 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. Q001 Easy Total net sales for the period
  2. Q002 Easy Gross sales before promotions
  3. Q003 Easy Returned transactions
  4. Q004 Easy Average basket value per transaction
  5. Q005 Easy Online share of net sales
  6. Q006 Easy Active customers
  7. Q007 Medium Peak sales month
  8. Q008 Medium Weakest sales month
  9. Q009 Medium Channel with the highest return rate
  10. Q010 Medium Top supplier by sales
  11. Q011 Medium Returns by return month
  12. Q012 Medium Same-day fulfilment rate
  13. Q013 Medium Payment method with the highest decline rate
  14. Q014 Medium Processing fees paid
  15. Q015 Medium Top customer by spend
  16. Q016 Medium Loyalty tier with the highest spend per transaction
  17. Q017 Medium Inventory shrinkage value
  18. Q018 Medium Region with the highest margin rate
  19. Q019 Medium Supplier on-time delivery rate
  20. Q020 Medium Net sales versus budget
  21. Q021 Medium Busiest distribution centre
  22. Q022 Hard Categories driving 2025 growth
  23. Q023 Hard Return-rate exception categories
  24. Q024 Hard Fulfilment lag for non-store channels
  25. Q025 Hard Repeat-customer rate
  26. Q026 Hard Customer retention into the final year
  27. Q027 Hard Decline-rate trend
  28. Q028 Hard Shrinkage as a share of sales by category
  29. Q029 Hard Fastest-growing region
  30. Q030 Hard Online share trend
  31. Q031 Hard Worst supplier on OTIF
  32. Q032 Hard Largest adverse budget variance by category
  33. Q033 Hard Distribution centre with the worst on-time inbound
  34. Q034 Hard Late deliveries by promised month
  35. Q035 Hard Single-sourced product exposure
  36. Q036 Hard Cost centre furthest below budget
  37. Q037 Hard Department margin comparison
  38. Q038 Hard Stockouts by supplying warehouse
  39. Q039 Hard Slip by supplier lead-time band
  40. Q040 Very Hard Choose a forecast method for next month
  41. Q041 Very Hard Outlier months in net sales
  42. Q042 Very Hard Executive scorecard
  43. Q043 Very Hard Acquisition cohort value
  44. Q044 Very Hard Cost to serve by payment method
  45. Q045 Very Hard Channel-category margin matrix
  46. Q046 Very Hard Return behaviour by loyalty tier
  47. Q047 Very Hard Slowest inventory turn by category
  48. Q048 Very Hard Budget variance decomposition
  49. Q049 Very Hard Worst month against budget
  50. Q050 Very Hard Critical supplier risk
  51. Q051 Very Hard Warehouse throughput versus capacity
  52. Q052 Very Hard Five-year margin CAGR by category
  53. Q053 Very Hard Most seasonal category
  54. Q054 Very Hard Department margin versus budget
  55. Q055 Very Hard Chronic stockout products
  56. Q056 Very Hard Cost centre margin league
  57. Q057 Very Hard Online return-rate trend
  58. Q058 Very Hard Promotion return on discount
  59. Q059 Very Hard Store budget attainment league
  60. Q060 Very Hard Supplier concentration risk

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