// the find
AlexTheAnalyst/PortfolioProjects
A grab-bag of loose SQL scripts, Jupyter notebooks, and raw data files (Excel/CSV) from a data analytics YouTuber's tutorial series, covering things like Nashville housing data cleaning, COVID data exploration, and a movie/streaming dataset project. It's aimed at data analyst job seekers looking for portfolio project templates to copy and put their own name on.
Covers a genuinely useful spread of skills for a junior analyst portfolio: SQL data cleaning, joins, window functions in the COVID script, plus a web scraping notebook and an API extraction example that go beyond just querying flat files. The datasets are small and self-contained, so you can open a notebook and get output immediately without setting up infrastructure.
No project structure at all — everything sits flat in the repo root with spaces and inconsistent casing in filenames, and raw data files (xlsx, csv, even a zip) are committed alongside code instead of being downloaded or gitignored. There's no requirements.txt or environment setup for the Python notebooks, no documentation beyond a one-paragraph README, and the repo hasn't been touched since mid-2024. Because the whole point is 'copy this and claim it as your own,' the code you get is whatever quality it was for a tutorial video, not something reviewed or maintained as a library.