Question

A retail analyst receives a flat file containing individual point-of-sale transactions, with one row per item sold including store ID, transaction timestamp, and sale amount. The finance team has requested a report showing total revenue per store per day. Which transformation should the analyst apply to prepare the data for this report?

Accepted Answer

Aggregate the data by grouping on store ID and transaction date, then sum the sale amount

Answer

Normalize the sale amount column using min-max scaling before delivering the report

Answer

Perform an inner join between the transaction table and itself on store ID

Answer

Pivot the data so each transaction timestamp becomes a separate column