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
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.
Get the data
v1.0 · 8 filesFiles are for members. A free account takes a minute, and you come straight back here.
- Question Book PDF DD-RET-005_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-RET-005_Data_Dictionary.xlsx
- Business Introduction PDF DD-RET-005_Business_Introduction.pdf
- Group Accounting Manual PDF DD-RET-005_Group_Accounting_Manual.pdf
- Management Accounts Summary PDF DD-RET-005_Management_Accounts_Summary.pdf
- Relationship Diagram PDF DD-RET-005_Relationship_Model.pdf
- Raw fact data DD-RET-005_FactGLLines.parquet
- Dimension / supporting data DD-RET-005_Supporting_Tables.zip
Questions
Open one to discuss itGeneral 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