SQLBits 2023

How to pick the best Data transformation strategy

Combining data from multiple sources can be performed using a number of different tools including Azure Synapse Integration/Azure Data Factory, Spark and Power BI Data Flows. We will explore which tool or combination of tools to select to best match your data environment.
While the technologies used for transforming data have changed, the goals have not. Companies need data from multiple sources combined to provide the single version of the truth. What tools can be used to accomplish this? Azure data factory/Azure Synapse integration, SQL, Spark and Power BI Data flows can all be used to transform and model data. Which one should you use? This session will examine the different elements in your environment which can be used to determine which solution would be the best fit based upon elements such as data types, maintenance, cost, and skill levels.