Skip to main content
Data Dare retail L5 sticker: the findi360 mascot analysing Group Reporting: Mapping, Reconciliation and Store Profitability.

DD-RET-005

Group Reporting: Mapping, Reconciliation and Store Profitability

Level 5 challenge. 14 million general-ledger lines from SAP, NetSuite and a legacy ledger with no mapping table: the rules are in the manual - rebates, loyalty, leases, intercompany recharges, cost centres re-used by new stores, dated exceptions and two contradictions. Reconcile to the control totals, then answer 24 questions.

  • Retail
  • L5 · PARQUET
  • ~14,431,784 rows
  • 15 tables
  • 24 questions
Get the data 24 questions
Free account: download the data, check your answers and earn a certificate. Create it → More Retail: L1 · L2 · L3 · L4

Profile Challenge · L5

Solve this and get a verified profile report

Build the model in Power BI (Python welcome), answer the questions, submit your file. findi360 reviews the work and publishes a report with a QR code — employers scan it and see what you can do, not only what you have done. The real potential lies at L4 and above — that is where employers look first.

Start my Profile Challenge See a sample report

Get the data

v1.0 · 8 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-005_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-RET-005_Data_Dictionary.xlsx 13.5 KB · v1.0
  • Business Introduction PDF DD-RET-005_Business_Introduction.pdf 614 KB · v1.0
  • Group Accounting Manual PDF DD-RET-005_Group_Accounting_Manual.pdf 628.8 KB · v1.0
  • Management Accounts Summary PDF DD-RET-005_Management_Accounts_Summary.pdf 611.6 KB · v1.0
  • Relationship Diagram PDF DD-RET-005_Relationship_Model.pdf 616.1 KB · v1.0
  • Raw fact data DD-RET-005_FactGLLines.parquet 344.1 MB · v1.0
  • Dimension / supporting data DD-RET-005_Supporting_Tables.zip 16.2 MB · v1.0

Questions

Open one to discuss it
  1. Q001 Easy Stores trading at the end of 2025
  2. Q002 Easy Grocery till sales in the sales feed, 2025
  3. Q003 Medium Ledger accounts missing from the charts
  4. Q004 Medium Grocery peak month for store sales, 2025
  5. Q005 Medium Bahrain store rent, 2024
  6. Q006 Medium Online delivery costs, 2025
  7. Q007 Hard Accounts mapped to revenue lines
  8. Q008 Hard Shrinkage moved into cost of sales
  9. Q009 Hard Grocery gross margin, 2025
  10. Q010 Hard Grocery loyalty redemptions, 2024
  11. Q011 Hard Grocery like-for-like sales growth
  12. Q012 Hard Bahrain best quarter for EBITDA, 2025
  13. Q013 Hard Intercompany recharges eliminated, 2025
  14. Q014 Hard Grocery suspense balance at year end
  15. Q015 Very Hard Group EBITDA, 2025
  16. Q016 Very Hard Change in group EBITDA margin
  17. Q017 Very Hard Bahrain EBITDA in SAR, 2025
  18. Q018 Very Hard Store contribution of S-111, 2025
  19. Q019 Very Hard Grocery stores losing more than SAR 50,000, 2025
  20. Q020 Very Hard Group net profit, 2025
  21. Q021 Very Hard Grocery EBITDA against budget, 2025
  22. Q022 Very Hard Grocery staff costs in distribution, 2024
  23. Q023 Very Hard Group operating expense ratio, 2025
  24. Q024 Very Hard Best Grocery store by contribution per sqm

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. Need help? Message us

Create a free account Sign in