Skip to main content
Data Dare retail L3 sticker: the findi360 mascot analysing Omnichannel Sales, Customer Behaviour and Commercial Risk.

DD-RET-003

Omnichannel Sales, Customer Behaviour and Commercial Risk

Decide how online is shifting the mix, which customers come back, where payments fail, and which categories bleed value through shrinkage.

  • Retail
  • L3 · PARQUET
  • ~500,000 rows
  • 12 tables
  • 50 questions
Get the data 50 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-003_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-RET-003_Data_Dictionary.xlsx 13.2 KB · v1.0
  • Business Introduction PDF DD-RET-003_Business_Introduction.pdf 613.9 KB · v1.0
  • Relationship Diagram PDF DD-RET-003_Relationship_Model.pdf 615.3 KB · v1.0
  • Raw fact data DD-RET-003_FactSalesTransactions.parquet 14.2 MB · v1.0
  • Dimension / supporting data DD-RET-003_Dimensions.zip 3.6 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 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 Returned transactions
  10. Q010 Easy Average basket value per transaction
  11. Q011 Easy Online share of net sales
  12. Q012 Easy Active customers
  13. Q013 Medium Peak sales month
  14. Q014 Medium Weakest sales month
  15. Q015 Medium Year-on-year net sales growth
  16. Q016 Medium Best margin month
  17. Q017 Medium Highest stockout month
  18. Q018 Medium Strongest quarter
  19. Q019 Medium Cumulative net sales to period end
  20. Q020 Medium Store with the best margin rate
  21. Q021 Medium Channel with the highest return rate
  22. Q022 Medium Top supplier by sales
  23. Q023 Medium Returns by return month
  24. Q024 Medium Same-day fulfilment rate
  25. Q025 Medium Payment method with the highest decline rate
  26. Q026 Medium Processing fees paid
  27. Q027 Medium Top customer by spend
  28. Q028 Medium Loyalty tier with the highest spend per transaction
  29. Q029 Medium Inventory shrinkage value
  30. Q030 Medium Region with the highest margin rate
  31. Q031 Hard Categories driving 2025 growth
  32. Q032 Hard Pareto categories for net sales
  33. Q033 Hard Store risk score
  34. Q034 Hard Margin change: rate versus mix
  35. Q035 Hard Return-rate exception categories
  36. Q036 Hard Fulfilment lag for non-store channels
  37. Q037 Hard Repeat-customer rate
  38. Q038 Hard Customer retention into the final year
  39. Q039 Hard Decline-rate trend
  40. Q040 Hard Shrinkage as a share of sales by category
  41. Q041 Hard Fastest-growing region
  42. Q042 Hard Online share trend
  43. Q043 Very Hard Choose a forecast method for next month
  44. Q044 Very Hard Outlier months in net sales
  45. Q045 Very Hard Executive scorecard
  46. Q046 Very Hard Acquisition cohort value
  47. Q047 Very Hard Cost to serve by payment method
  48. Q048 Very Hard Channel-category margin matrix
  49. Q049 Very Hard Return behaviour by loyalty tier
  50. Q050 Very Hard Slowest inventory turn by category

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