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. Q040 Very Hard Group retained earnings at 31 December 2025
  2. Q041 Very Hard Total group equity at 31 December 2025
  3. Q042 Very Hard Consolidated total assets at 31 December 2025
  4. Q043 Very Hard Technology services segment external revenue, 2025
  5. Q044 Very Hard Non-controlling interest in Mizan Services Pakistan at 31 December 2025
  6. Q045 Very Hard Identifiable net assets acquired
  7. Q046 Very Hard Owners' share of Pakistan's 2025 profit
  8. Q047 Very Hard Months the group beat its revenue budget, 2025
  9. Q048 Very Hard Best three months for group EBITDA margin, 2025
  10. Q049 Very Hard Movement in the translation reserve, 2025
  11. Q050 Very Hard Exchange difference on goodwill, 2025
  12. Q051 Very Hard Real Estate UAE net assets in USD at 31 December 2025
  13. Q052 Very Hard Group revenue growth per year, 2023-2025
  14. Q053 Very Hard Group retained earnings at 30 June 2025
  15. Q054 Very Hard Largest month-end intercompany suspense, 2025
  16. Q055 Very Hard Suspense not explained by goods in transit or the dispute
  17. Q056 Very Hard Dividends eliminated on consolidation, 2025
  18. Q057 Very Hard Pakistan profit for calendar 2025
  19. Q058 Very Hard Ramadan uplift in Mizan Retail, March 2025
  20. Q059 Very Hard Exchange-rate effect on subsidiaries' EBITDA, 2025
  21. Q060 Very Hard Change in owners' profit, 2025 vs 2024

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