Published On May 20, 2023
TRY LATITUDE FOR FREE 👉 https://bit.ly/3o9iGlX
┋Resources to take your data analytics skills to the next level┋
Ultimate Data Roadmap: The MOST comprehensive data roadmap âž¡ https://mochen.info/product/ultimate-...
Ultimate Data Portfolio: Publish your entire data portfolio to the web with ZERO coding âž¡ https://mochen.info/product/ultimate-...
Ultimate Resume Template: Literally the resumes that I use for my OWN JOB APPLICATIONS âž¡ https://mochen.info/product/ultimate-...
1:1 Mentorship: Significantly accelerate your professional GROWTH âž¡ https://mochen.info/1-1-mentorship/
Career Compass: My completely FREE weekly data newsletter with actionable tips and insights âž¡ https://mochen.beehiiv.com/subscribe/
CourseCareers: Start the FREE Data Analytics Introduction Course Now âž¡ https://coursecareers.com/a/mochen?co...
Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau and Python âž¡    • Portfolio Projects Â
Data Portfolio Guide: Over 80 actionable tips on how you can build your dream data portfolio. For completely FREE âž¡ https://mochen.beehiiv.com/c/data-por...
┋Community & Socials┋
  / discord  ⬅ Join our Discord Data Community
  / mo_chen1  ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well
  / mo-chen1  ⬅ Daily tips & advice on how to enhance your data analysis skills
  / mo_chen_1  ⬅ Figuring out what I want to do in this space...
┋Professional Certificates┋
CourseCareers âž¡ https://coursecareers.com/a/mochen
Google Data Analytics Professional Certificate âž¡ https://www.coursera.org/google-certi...
Google Advanced Data Analytics Professional Certificate âž¡ https://www.coursera.org/google-certi...
Tableau Business Intelligence Professional Certificate âž¡ https://imp.i384100.net/TableauBIAnalyst
Microsoft Power BI Data Analyst Professional Certificate âž¡ https://www.coursera.org/professional...
IBM Data Science Professional Certificate âž¡ https://imp.i384100.net/IBMdataScience
Google Project Management Professional Certificate âž¡ https://imp.i384100.net/GoogleProject...
┋Timestamps┋
00:00 Intro
01:50 Import csv files
03:06 CREATE TABLE
04:18 psql command line tool
08:02 OVER
11:12 PARTITION BY
14:56 ROW_NUMBER
18:00 RANK and DENSE_RANK
20:38 LAG and LEAD
24:20 Bonus
25:23 Outro
┋The project┋
Github repo for code âž¡ https://github.com/mochen862/window-f...
New York City Airbnb Open Data âž¡ https://www.kaggle.com/datasets/dgomo...
Thanks so much for taking a little time out of your day to watch this!