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

DD-MFG-005

Group Reporting: Mapping, Reconciliation and Product Profitability

Level 5 challenge. 12 million general-ledger lines from SAP, Oracle and a legacy ledger, with no mapping table: the rules are in the manual - ranges, cross-references, dated exceptions and two contradictions. Your mapping must reconcile to the control totals before the 24 questions will come out right.

  • Manufacturing
  • L5 · PARQUET
  • ~12,039,646 rows
  • 14 tables
  • 24 questions
Get the data 24 questions
Free account: download the data, check your answers and earn a certificate. Create it → More Manufacturing: 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-MFG-005_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-MFG-005_Data_Dictionary.xlsx 13.3 KB · v1.0
  • Business Introduction PDF DD-MFG-005_Business_Introduction.pdf 614.2 KB · v1.0
  • Group Accounting Manual PDF DD-MFG-005_Group_Accounting_Manual.pdf 634.5 KB · v1.0
  • Management Accounts Summary PDF DD-MFG-005_Management_Accounts_Summary.pdf 611.7 KB · v1.0
  • Relationship Diagram PDF DD-MFG-005_Relationship_Model.pdf 616 KB · v1.0
  • Raw fact data DD-MFG-005_FactGLLines.parquet 350.5 MB · v1.0
  • Dimension / supporting data DD-MFG-005_Supporting_Tables.zip 297.3 KB · v1.0

Questions

Open one to discuss it
  1. Q007 Hard Accounts mapped to direct material
  2. Q008 Hard Inbound freight moved into cost of sales
  3. Q009 Hard Dubai scrap and rework, FY2023
  4. Q010 Hard Lahore administration expenses, FY2024
  5. Q011 Hard Group gross margin, FY2025
  6. Q012 Hard Favourable variance months, Riyadh 2025
  7. Q013 Hard Dubai IT and software, FY2025
  8. Q014 Hard Riyadh 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