SQL Portfolio: 5 Real Analyses
Build a SQL-only portfolio of 5 increasingly complex analyses on real public datasets. The strongest entry-level data analyst signal.
About this project
Strong SQL portfolios beat any certificate for entry-level data analyst hiring. This project teaches the breadth: 5 distinct analyses covering joins, aggregations, window functions, CTEs, and the writing skill of explaining what you found. Use public datasets — NYC Taxi, Chinook, IMDb, Stack Overflow public dump, GitHub Archive.
Why build this in 2026?
SQL fluency is the floor for data analyst roles. A strong portfolio replaces having "1 year experience" on most filters.
What you'll ship
- 5 published analyses (Mode / Hex / GitHub)
Sign up to see the full project brief
Full deliverables, success criteria, and AI Career Tutor support — free.
You'll unlock:Complete project brief, AI tutor that knows this project, and progress tracking when you start.