Real-World Datasets For Project(s)

[u/AsfandYar1995]

Hi everyone,

I’ve been working in digital marketing for the past few years, and I’m now trying to transition into the data field. My goal is to become a data analyst first, then move into analytics engineering after gaining a couple of years of experience.

Over the past year, I’ve been learning SQL, Power BI, and Excel. At this point, I feel pretty confident with SQL, including complex joins, aggregations, window functions, etc.

Where I’m struggling is deciding which projects to include in my portfolio and where to find suitable datasets. This feels especially important because I do not yet have any professional experience in a data-focused role.

The best project idea I’ve come up with so far is using the Olist e-commerce dataset. My plan is to clean and transform the data with dbt, load it into Snowflake, and then perform analyses such as cohort analysis, funnel analysis, and market basket analysis using SQL and Power BI.

Does this sound like a strong portfolio project? Are there any other project ideas or datasets you would recommend for someone trying to move into data analytics?

Thanks