Description:
Link to Datacamp: https://datacamp.pxf.io/1GrJLx
This video shows how to perform period-over-period comparisons in SQL using window functions, moving beyond complex Excel models. Learn the SQL query syntax for the lag function, and how to effectively use partition by and order by to calculate prior year sales. This is a crucial data analytics skill for any aspiring data professional.
Adam is a Business Systems Analyst at Google within the Finance Engineering department. His work focuses on maintaining and developing complex finance systems, involving heavy database management and global project coordination. On this channel, he shares the "efficiency over effort" workflows he uses to manage high scale data projects.
Connect with Adam:
YouTube: @analyticswithadam
LinkedIn: https://www.linkedin.com/in/adamwilliamgrant/
Share this link via
Or copy link
























