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. Q001 Easy Accounts across the three charts
  2. Q002 Easy Dubai journals in FY2024
  3. Q003 Medium Ledger accounts missing from the charts
  4. Q004 Medium Riyadh peak month for gross sales, 2024
  5. Q005 Medium Dubai operating expenses, FY2025
  6. Q006 Medium Riyadh selling expenses, FY2025
  7. Q007 Hard Accounts mapped to direct material
  8. Q008 Hard Inbound freight moved into cost of sales
  9. Q009 Hard Dubai scrap and rework, FY2023
  10. Q010 Hard Lahore administration expenses, FY2024
  11. Q011 Hard Group gross margin, FY2025
  12. Q012 Hard Favourable variance months, Riyadh 2025
  13. Q013 Hard Dubai IT and software, FY2025
  14. Q014 Hard Riyadh suspense balance at year end
  15. Q015 Very Hard Group EBITDA, FY2025
  16. Q016 Very Hard Change in group EBITDA margin
  17. Q017 Very Hard Lahore revenue growth in SAR
  18. Q018 Very Hard Riyadh full cost per good pump, FY2025
  19. Q019 Very Hard Weakest product line by gross margin
  20. Q020 Very Hard Group net profit, FY2025
  21. Q021 Very Hard Riyadh EBITDA against budget, FY2025
  22. Q022 Very Hard Lahore staff costs charged to selling, FY2023
  23. Q023 Very Hard Lahore EBITDA in SAR, FY2023
  24. Q024 Very Hard Product cost of steel fabrications, FY2025

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