Question

An analyst receives a sales table in 'long' format where each row contains a StoreID, a Month column (values like 'Jan', 'Feb', 'Mar'), and a Revenue value. The finance team wants a report where each store appears on a single row with separate columns for each month's revenue. Which data transformation should the analyst apply?

Accepted Answer

Pivot the data, using Month as the new column headers and Revenue as the values, grouped by StoreID

Answer

Perform an inner join between the sales table and itself on StoreID

Answer

Normalize the Revenue column to a 0-1 scale before exporting the report

Answer

Aggregate the data with a SUM of Revenue grouped only by Month