
Will be covering:
Window functions (rank, lead, lag, partitions, etc.)
How to create product level base facts for acquisition funnels, payment funnels et al
How to optimise queries using CTEs, insertion instead of selection statements, etc.
Interview level used case samples and working sessions