Normalization transforms values into a consistent scale, unit, or representation so that data can be compared or combined appropriately. In data preparation, currency normalization must account for duplicates and produce aggregates that remain plausible against external revenue figures. section 6.6.2 section 8.3.2
Use normalization as an explicit data-quality and evaluation task:
- Check whether conversions and normalized values align with reported business revenues. section 6.6.2
- Separate deduplication from normalization, then inspect aggregate results after both treatments. section 6.6.2
- Question whether normalization makes populations or tests genuinely comparable before combining their information. section 8.3.2
Currency-normalized sales
A naïve normalization produced implausible aggregate sales. After deduplication and a well-designed currency-normalization process, the totals closely matched published revenue figures, with deltas around 0.1%. section 6.6.2
Figure 6.8 The same data treated for duplicates with a well-designed currency normalization process
Compare naïve normalization with a duplicate-treated dataset using a well-designed currency-normalization process. section 6.6.2
