Join to relational tables. Variables, subqueries, temporary tables. Transformation of data types, data cleaning. Summary with aggregation functions.
I develop queries to extract information and load them in power bi