ORIGINAL COMPANY-CONTEXT PRACTICE
Compare business-unit metrics without misleading totals
Original practice scenario: A hypothetical diversified group wants one dashboard comparing hospitals, food businesses and technology investments. How should an analyst structure the metrics?
Written for independent practice using company context; this is not a verified question from a company interview.
A REASONED APPROACH
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.