Basic T-SQL (Scripts, Joins, Functions, SP, Views, CTE)
Moderate T-SQL (Index, Agent Job, Profiler, Performance Tuning)
Advanced T-SQL (Data cleansing, Bad Data handling, Pivot, Index tuning)
SSIS (Basic - Moderate)
Basic SSAS
Situation Based (T-SQL, SSIS)