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 itGeneral 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