Transforming sales data for analysis