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. Q015 Very Hard Group EBITDA, 2025
  2. Q016 Very Hard Change in group EBITDA margin
  3. Q017 Very Hard Bahrain EBITDA in SAR, 2025
  4. Q018 Very Hard Store contribution of S-111, 2025
  5. Q019 Very Hard Grocery stores losing more than SAR 50,000, 2025
  6. Q020 Very Hard Group net profit, 2025
  7. Q021 Very Hard Grocery EBITDA against budget, 2025
  8. Q022 Very Hard Grocery staff costs in distribution, 2024
  9. Q023 Very Hard Group operating expense ratio, 2025
  10. 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