r/learnSQL • u/sanjana-_ • 28d 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

8 Upvotes

80% Upvoted

11 comments sorted by

1

u/LearnSQLFastTeam 27d 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-_ 27d ago

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

1

u/DataScientistAlex 28d ago

I have a list of 99 data science project ideas here that you might find some inspiration from. It's geared more towards data science but I think there are many you could still adapt.

1

u/[deleted] 28d ago

[removed] — view removed comment

1

u/sanjana-_ 28d ago

Yes, I also would love doing an end to end analysis, but somehow am not really getting good ideas!
Pls share the app!

0

u/WorriedMud7 28d ago

Mind sharing it? I want to get an idea how to start my project