Consider a scenario where you need to pivot a large dataset to transform rows into columns for better analysis. Which AWS service would you use to perform this operation efficiently, and what considerations would you need to take into account?