Data Transformation, Functions, Views, Sql Server Development, SSDT DACPAC, Power BI-ready serving views, Dimensional modelling, Log parsing, Advanced T-SQL, Error handling, Indexing, Stored procedures, Auditability, Duplicate prevention, Historisation patterns, Event correlation, Logical and physical data modelling, Query optimisation, Git source-control, Safe rerun design