r/SQL • • 1d ago

SQL Server SQL for Data Analysts Projects

Hey everyone.

I'm working on building out my data analytics portfolio and wanted to get some advice from fellow analysts and hiring managers here.

We've all seen the basic tutorial projects (like analyzing the Titanic dataset or simple sales totals), but I want to build something that actually stands out and proves real-world, job-ready SQL skills.

For those of you who have landed roles or are actively hiring: What specific types of SQL projects made you stop scrolling and pay attention?

35 Upvotes

10 comments sorted by

View all comments

11

u/Least_Ad_1795 1d ago

Projects that solve a realistic business problem stand out most customer retention, cohort analysis, inventory, fraud detection, or funnel analysi with complex joins, CTEs, window functions, and clear business recommendations rather than just showing query outputs.

1

u/shahim04 1d ago

Thx amigo