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. Q007 Hard Accounts mapped to revenue lines
  2. Q008 Hard Shrinkage moved into cost of sales
  3. Q009 Hard Grocery gross margin, 2025
  4. Q010 Hard Grocery loyalty redemptions, 2024
  5. Q011 Hard Grocery like-for-like sales growth
  6. Q012 Hard Bahrain best quarter for EBITDA, 2025
  7. Q013 Hard Intercompany recharges eliminated, 2025
  8. Q014 Hard Grocery suspense balance at year end

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