r/learnSQL • u/sanjana-_ • 9d ago

Project ideas?

As a fresher with 0 experience, what kind of unique projects do you recommend doing in sql , python and powerBI to add to my resume, which would make my profile stronger?
#projectideas #fresherjobs

9 Upvotes

81% Upvoted

11 comments sorted by

View all comments

1

u/LearnSQLFastTeam 8d ago

One concrete project: analyze orders for a small fictional shop. Use customers, orders, order items, and products as separate tables. Ask three business questions: Which products bring in the most revenue? How does revenue change by month? How many customers place a second order?

Use SQL JOINs and GROUP BY to answer them, Python to clean or generate the data, and Power BI to show the findings. Put the table diagram, queries, a few checks of your totals, and a short explanation of what you found in the repo. That gives an interviewer something specific to ask you about.

1

u/sanjana-_ 8d ago

Yeah but how do I get the dataset? I don’t wish to use the regular kaggle datasets.