Question

An analyst is preparing a global sales dataset for reporting. The 'amount' column contains transaction values recorded in different currencies, and a separate 'currency_code' column identifies each one (USD, EUR, GBP, etc.). Management requires all figures expressed in USD for accurate comparison and aggregation. Which transformation step best addresses this requirement?

Accepted Answer

Join the dataset to an exchange-rate reference table on 'currency_code' and multiply each amount by its rate to derive a standardized USD value

Answer

Apply min-max normalization to the 'amount' column so all values fall between 0 and 1

Answer

Standardize the 'amount' column using z-scores so values are comparable across records

Answer

Remove all non-USD transactions so only comparable values remain in the dataset