David Stokes - Windowing Functions for Database Analytics
You have all this wonder data in your database but how do you get a moving average, find quartiles, or other simple analytics? Windowing Functions allow you to group rows (by department id, last month to current day, or other) and do analytics on those rows. This is a simple intro.
DataLove 2021: https://emamo.com/event/data-love-con...