Data transformation

In the screenshot (source: https://powerapps.microsoft.com/en-us/blog/whats-new-in-dataflows-and-data-integration-september-2019) below you can see how Microsoft envisions data transformation.