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

WhatsApp LinkedIn

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

General discussion

Anything about this dataset that is not one question — loading the files, which tool, how you set it up.

Join the discussion

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us

Create a free account Sign in