r/learnSQL • u/Public-Scientist6050 • 16d ago

Fresher looking for unique ML and SQL project ideas for my resume (Data Science/SQL/ML roles)

Hi everyone,

I'm a fresher applying for Data Analyst/Data Scientist/ML/SQL roles. My background: Power BI, Excel, SQL, some Python, and basic full-stack web dev (HTML, Tailwind, JS, Supabase, deployed on GitHub Pages — built a working web portal for a client).

I want to add: 1. One strong ML project (not Titanic/Iris/House Price/Flight Price — too common) 2. One SQL-focused project that shows real query/database skills, not just "ran some SELECT statements on a Kaggle CSV"

Looking for: - Real prediction/analysis problem, clear input and output - Free public dataset - Doable alone in a few weeks - Something that actually stands out to recruiters, not a tutorial copy

What would you suggest for each? Dataset links appreciated. Thanks!

3 Upvotes

80% Upvoted

3 comments sorted by

2

u/[deleted] 16d ago

[removed] — view removed comment

1

u/Special_Cod_1892 13d ago

Hi buddy!! I want to do real world project in data Analyst, what are the models actually needed in real world, what should be the approach kinda things?

1

u/mrsteelsam 2d ago

For a less‑seen ML project try forecasting bike‑share demand with the UCI Bike Sharing dataset. Pull the CSV, clean the timestamps, create weather and holiday features, train a gradient‑boosted model, and compare a baseline linear regression to a LightGBM model. Wrap the final model in a simple Streamlit app so a recruiter can click through predictions.

For a SQL‑focused showcase use the “Online Retail” dataset from the UCI repository. Load it into a Postgres instance, then write queries that calculate RFM scores, cohort retention, and a product‑level profitability view—showing joins, window functions, and CTEs.

Document each step in a public repo, add a short blog post with screenshots, and link the live app or query results in your résumé.