Original practice scenario: A fictional holding company has subsidiaries, joint ventures and changing ownership percentages. Design a graph for historical consolidated reporting.
Read model answer +
Ownership, control and reporting scope are related but distinct concepts. Historical queries need effective dates and policy versions instead of treating today's hierarchy as timeless.
Work through it
Assign stable legal-entity identifiers and version ownership edges, control assessments and reporting-scope decisions independently with their supporting references.
Validate percentage ranges, overlapping effective intervals and cycles; allow explicit exceptions for legitimate complex structures rather than silently flattening them.
Query the graph at a specified date and policy version, testing acquisitions, disposals, minority interests and delayed corrections against known synthetic examples.
Tradeoffs to discuss
A graph expresses relationships naturally but aggregation still needs explicit elimination and consolidation rules.
Common pitfalls
Do not infer accounting control solely from one ownership percentage.
Keep the exercise's simplified reporting rules distinct from professional accounting conclusions.
Original practice scenario: A hypothetical diversified group wants one dashboard comparing hospitals, food businesses and technology investments. How should an analyst structure the metrics?
Read model answer +
Use a shared reporting vocabulary without pretending every operating metric is comparable. Financial measures, operational counts and rates require different aggregation and contextual interpretation.
Work through it
Document each metric's unit, grain, denominator, period and scope; retain business-specific measures beside a small set of genuinely comparable group metrics.
Aggregate additive measures after currency and period alignment, and recompute rates from compatible numerators and denominators rather than averaging percentages.
Test changes in business mix, acquisitions and missing submissions, showing like-for-like comparisons and separating scope changes from operating movements.
Tradeoffs to discuss
A compact group dashboard aids scanning but must link to underlying definitions and unit-specific explanations.
Common pitfalls
Do not rank unlike businesses using arbitrary normalized scores.
Avoid presenting missing data as zero performance or averaging ratios with incompatible denominators.
