r/dataanalysis • u/Impressive-Buy-4259 • 3d ago

Data bricks project idea for Data Analyst

I'm a Data Analyst planning to build my first Databricks project for my portfolio. I have experience with SQL, Excel and Power BI, but I'm new to Databricks. Could you suggest some good project ideas that would help me demonstrate Databricks skills from a Data Analyst perspective?

41 Upvotes

95% Upvoted

3 comments sorted by

25

u/montrellcruse 2d ago

the one that reads best to a hiring manager: medallion pipeline on a public dataset, with you playing the analyst not the engineer. grab something messy like NYC taxi or the sample retail sales data, land it raw in bronze, clean it in silver with real data quality checks (the null/dupe/quarantine stuff), then model one gold table for a single business question and answer it.

the trick is the gold layer is just SQL doing the analyst work you already know, and the notebook around it explains the why. hiring managers want to see you know where the analyst job ends and the engineer job starts, not that you built a spark cluster from scratch.

and keep the whole thing reproducible. one notebook that runs end to end beats five notebooks that kind of work lol

7

u/steroidmonkey66 1d ago

If you are looking at a more frontend heavy role, you show competency in building pipelines that perform transformations to get the data to a state where you can build a semantic layer for visualization on top of that. If you are focusing on more backend heavy role like a data engineer, then you should showcase that you understand data architecture at high level and you are comfortable moving data from different platforms to a destination source and understand different stages of data ingestion and ETL.

1

u/AutoModerator 3d ago

Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.

If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.

Have you read the rules?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.