There are more tools and approaches available to transform your data in Microsoft Fabric than you can shake a spear at. From low and no code through to multiple full code-based options, sometimes themselves with multiple syntaxes. Choosing the wrong one could lead to a comedy of errors, so how do you make sure you end up with your data as you like it?
In this session we will take the common task of building a table of person data for a data model and implement it multiple times with a different approach each time including using SQL, Data Flows, Data Wrangler, PySpark and, simply asking Copilot to do it for us.
By the end of the session, you will have an overview of the data transformation tools Fabric has in its belt, which ones suit which tasks and audiences best along with the strengths and weaknesses of each. This will help you to choose the right tool for the right job without causing a tempest.