Data load: SQL Server Integration Services and SQL Server Linked Server objects for on-prem data sources, Azure Data Factory for online sources (e.g. Dynamics365). Using OData queries where necessary to limit the amount of columns and rows of data transferred.

Transformations and data warehouse: TSQL and Microsoft SQL Server

Reporting and data models: PowerBI including several complex measures implemented in DAX.

Research data analysis and visualization