You can transform the data as required after it is retrieved from data source with following features:
Join tables
Formatting columns
Query filter
Data set parameter
Query parameter
Configure expression columns