top of page

My Projects

YouTube-Analytics.png

01 Youtube video analysis

In this project using python I have shown how to extract channel and video related data from YouTube using the API feature and doing some manipulation on the given data. Click on the image to go to the code for the project.

6554783.jpg

Basics

02 Sql basic project

In this project I have shown people basic SQL concepts like group by, where, having and some date functions to answer business data questions.

Screenshot (596)_edited.jpg

Window Function 

03 Sql window functions

In this playlist, I have explained using queries how to leverage window functions like RANK,LAG,LEAD and others to make some insights from the data.

LInkedi.jpg

04 Linkedin job scraper

I have built a simple LinkedIn scraper using selenium in python to extract company name, position and job link data based on a given url. 

bottom of page