Skip to main content
Data Dare consolidation L2 sticker: the findi360 mascot analysing Group Consolidation: Subsidiaries, NCI & Intercompany.

DD-CON-002

Group Consolidation: Subsidiaries, NCI & Intercompany

Three companies, 24 monthly trial balances each, one shared chart of accounts and a mapping to the group reporting lines. No date table: build the calendar in DAX. Forty questions from group revenue to the retained-earnings roll-forward.

  • Consolidation
  • L2 · CSV
  • ~55,012 rows
  • 8 tables
  • 40 questions
Get the data 40 questions
Free account: download the data, check your answers and earn a certificate. Create it → More Consolidation: L3 · L4 Next in the story: Data Transformation →

Get the data

v1.0 · 6 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-002_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-CON-002_Data_Dictionary.xlsx 12.1 KB · v1.0
  • Business Introduction PDF DD-CON-002_Business_Introduction.pdf 616.5 KB · v1.0
  • Relationship Diagram PDF DD-CON-002_Relationship_Model.pdf 614.1 KB · v1.0
  • Raw fact data DD-CON-002_FactTrialBalance.csv 4 MB · v1.0
  • Dimension / supporting data DD-CON-002_Dimensions.zip 17.1 KB · v1.0

Questions

Open one to discuss it
  1. Q001 Easy Stores trading at the end of 2024
  2. Q002 Easy Hypermarkets in the store estate
  3. Q003 Easy Mizan Retail revenue, 2025
  4. Q004 Easy Mizan Manufacturing revenue, 2024
  5. Q005 Easy Mizan Retail revenue in March 2025
  6. Q006 Easy Logistics revenue billed to group companies, 2025
  7. Q007 Easy Group cash at 31 December 2025
  8. Q008 Easy Manufacturing trade receivables, end of 2024
  9. Q009 Easy Store staff salaries, 2025
  10. Q010 Easy Group bank borrowings at 31 December 2025
  11. Q011 Easy Mizan Retail depreciation, 2024
  12. Q012 Easy Mizan Manufacturing gross profit, 2025
  13. Q013 Easy Mizan Retail utilities, 2025
  14. Q014 Easy Mizan Retail income tax, 2025
  15. Q015 Easy Mizan Retail revenue budget, 2025
  16. Q016 Easy Logistics fuel cost, 2025
  17. Q017 Medium Group revenue after eliminations, 2025
  18. Q018 Medium Group gross profit, 2024
  19. Q019 Medium Group EBITDA, 2025
  20. Q020 Medium Group profit for 2025
  21. Q021 Medium Minority share of profit, 2025
  22. Q022 Medium Profit attributable to owners, 2024
  23. Q023 Medium Intercompany differences in group profit, 2025
  24. Q024 Medium Intercompany suspense at 31 December 2025
  25. Q025 Medium Group revenue growth, 2025 vs 2024
  26. Q026 Medium Peak month for group revenue, 2025
  27. Q027 Medium Rolling 12-month group revenue to June 2025
  28. Q028 Medium Months Mizan Retail beat its revenue budget, 2025
  29. Q029 Medium Retail region with the highest store sales, 2025
  30. Q030 Medium Group retained earnings at 31 December 2024
  31. Q031 Medium Non-controlling interests at 31 December 2025
  32. Q032 Medium Dividend declared by Mizan Retail, 2025
  33. Q033 Medium Mizan Logistics EBITDA margin, 2025
  34. Q034 Medium Weakest quarter for Mizan Retail gross margin, 2025
  35. Q035 Medium Group net debt at 31 December 2025
  36. Q036 Medium Group selling and distribution expenses, 2025
  37. Q037 Hard Worst month for group EBITDA against budget, 2025
  38. Q038 Hard Like-for-like store sales growth, 2025
  39. Q039 Very Hard Group retained earnings at 31 December 2025
  40. Q040 Very Hard Month ends with a large intercompany timing gap

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