Skip to main content
Data Dare consolidation L4 sticker: the findi360 mascot analysing Diversified Group Close: Acquisition, Goodwill & Multi-ERP Consolidation.

DD-CON-004

Diversified Group Close: Acquisition, Goodwill & Multi-ERP Consolidation

The Level 4 consolidation case behind the Group Consolidation Accountant role. Seven companies, ~6.9M journal lines, three charts of accounts, no mapping table and no date table. Sixty questions.

  • Consolidation
  • L4 · PARQUET
  • ~6,884,744 rows
  • 18 tables
  • 60 questions
Get the data 60 questions
Free account: download the data, check your answers and earn a certificate. Create it → More Consolidation: L2 · L3 Next in the story: Data Transformation →

Profile Challenge · L4

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-CON-004_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-CON-004_Data_Dictionary.xlsx 15.9 KB · v1.0
  • Business Introduction PDF DD-CON-004_Business_Introduction.pdf 616.2 KB · v1.0
  • Group Accounting Manual PDF DD-CON-004_Group_Accounting_Manual.pdf 627.1 KB · v1.0
  • Management Accounts Summary PDF DD-CON-004_Management_Accounts_Summary.pdf 616.8 KB · v1.0
  • Relationship Diagram PDF DD-CON-004_Relationship_Model.pdf 616.7 KB · v1.0
  • Raw fact data DD-CON-004_FactGLLines.parquet 81.5 MB · v1.0
  • Dimension / supporting data DD-CON-004_Supporting_Tables.zip 10 MB · v1.0

Questions

Open one to discuss it
  1. Q007 Medium Group revenue after eliminations, 2025
  2. Q008 Medium Mizan Retail revenue, 2025
  3. Q009 Medium Goodwill at the acquisition date
  4. Q010 Medium Book net assets acquired
  5. Q011 Medium Pakistan revenue in August 2024 before the acquisition
  6. Q012 Medium Pakistan profit consolidated in 2024
  7. Q013 Medium Amortisation of the fair-value uplift, 2025
  8. Q014 Medium Unrealised profit in group stock at 31 December 2025
  9. Q015 Medium Group EBITDA, 2025
  10. Q016 Medium Management fees charged by Holding, 2025
  11. Q017 Medium Intercompany differences in group profit, 2025
  12. Q018 Medium Group revenue growth, 2025 vs 2024
  13. Q019 Medium Peak month for group revenue, 2025
  14. Q020 Medium Mizan Retail's busiest trading day, 2025
  15. Q021 Medium Pakistan revenue for calendar 2025

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