Projects
The work behind the mentoring
Open projects and teaching material I use in analytics sessions, all free to explore.
PythonYouTube API
YouTube video analysis
Extract channel and video data from YouTube using the API, then manipulate and analyze it in Python.
View the code on GitHub
SQL
SQL basics for business questions
Core SQL concepts like GROUP BY, WHERE, HAVING and date functions, applied to answering real business data questions.
View the code on GitHub
SQLYouTube playlist
SQL window functions
A video playlist on leveraging window functions like RANK, LAG and LEAD to pull insights out of data.
Watch the playlist
PythonSelenium
LinkedIn job scraper
A scraper that extracts company name, position and job link data from LinkedIn job listings for a given URL.
View the code on GitHub
Want to build these skills?
Analytics mentorship starts with one call. CV, SQL and interview prep included.