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
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 filesFiles are for members. A free account takes a minute, and you come straight back here.
- Question Book PDF DD-CON-002_Question_Book.pdf
- Dataset Documentation / Data Dictionary XLSX DD-CON-002_Data_Dictionary.xlsx
- Business Introduction PDF DD-CON-002_Business_Introduction.pdf
- Relationship Diagram PDF DD-CON-002_Relationship_Model.pdf
- Raw fact data DD-CON-002_FactTrialBalance.csv
- Dimension / supporting data DD-CON-002_Dimensions.zip
Questions
Open one to discuss it- Q001 Easy Stores trading at the end of 2024
- Q002 Easy Hypermarkets in the store estate
- Q003 Easy Mizan Retail revenue, 2025
- Q004 Easy Mizan Manufacturing revenue, 2024
- Q005 Easy Mizan Retail revenue in March 2025
- Q006 Easy Logistics revenue billed to group companies, 2025
- Q007 Easy Group cash at 31 December 2025
- Q008 Easy Manufacturing trade receivables, end of 2024
- Q009 Easy Store staff salaries, 2025
- Q010 Easy Group bank borrowings at 31 December 2025
- Q011 Easy Mizan Retail depreciation, 2024
- Q012 Easy Mizan Manufacturing gross profit, 2025
- Q013 Easy Mizan Retail utilities, 2025
- Q014 Easy Mizan Retail income tax, 2025
- Q015 Easy Mizan Retail revenue budget, 2025
- Q016 Easy Logistics fuel cost, 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