You are required to visualize a large dataset of sales transactions to identify trends over time. Which AWS service would you use for this purpose, and how would you prepare the data for effective visualization? Consider data cleansing and aggregation techniques.