You are designing a data pipeline that requires the transformation of data from various sources into a unified format for analysis. Which Azure service would you use to create a custom data transformation logic and why?