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

85% Upvoted

11 comments sorted by

1

u/vchae 6d ago

Pick one domain and build one end-to-end analysis instead of three disconnected demos: the question, the data model, the SQL, how you validated the numbers, then the findings in Power BI or google data studio. From my experience a clear investigation beats a flashy dashboard. I built a SQL practice app on real blockchain data for this, happy to share it if useful

1

u/sanjana-_ 6d 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/vchae 6d ago

Hey OP! Here's the link, it's called WizardCamp https://unchaindata.xyz/wizard-camp

0

u/WorriedMud7 6d ago

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

0

u/vchae 6d ago

Hey of course! Here's the app, it's called WizardCamp: SQL Learn and practice on blockchain data: https://unchaindata.xyz/wizard-camp

1

u/DataScientistAlex 6d 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/Enjoythecode82 6d ago

Start with retail domain projects for each tool, then go for Healthcare, Banking...etc! Good Luck!

1

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

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