u/Accurate_Data4642

Hey everyone,

I’m relatively new to data analytics and I’m looking for an idea for my next portfolio project.

I don’t want to build a project just for the sake of building a dashboard. I want something based around a realistic business problem where I actually have to investigate the data and answer questions like:

What is going wrong? Why is it happening? How is it affecting the business? What should the business do about it?

Ideally, I’d like a project where the answer isn’t obvious from the beginning and where I can produce actual insights and recommendations, not just KPIs and charts.

I’m open to pretty much any area — marketing, finance, supply chain, inventory, e-commerce, operations, customer analytics, etc. I actually want to learn the business/domain while doing the analysis.

Tools I’m working with:
SQL
Excel
Power BI / another BI tool

If you work as an analyst, I’d especially love to hear about real types of problems you’ve been asked to solve at work that could be recreated as a portfolio project.

Dataset suggestions are also very welcome.

What would you build if you were starting your portfolio again today?

https://preview.redd.it/ntnfxvszivjh1.png?width=1305&format=png&auto=webp&s=4d3d35f66a28bd4629fc8fbb700e1e6ba6f87b1e

Hey everyone,

I've been learning data analysis for about a month now, and this is my first proper portfolio project.

It's a supermarket sales dashboard built entirely in Excel using a Kaggle dataset. The dataset isn't perfect, but I wanted to use it as a starting point to practice cleaning data, building KPIs, PivotTables, slicers and visualizing the results.

I'd really appreciate some feedback on it:

• Does the dashboard answer useful business questions?
• Are any of the charts or KPIs misleading/unnecessary?
• What would you improve about the layout or design?
• What analysis would you add to make this a stronger portfolio project?

It took me about a week to finish, which felt a bit long, but I'm still new so I'm assuming I'll get faster with practice.

I'm learning SQL now and planning to move into Power BI next, so eventually I'd like to build something similar using SQL + BI.

Hey everyone,

I've been learning data analysis for about a month now, and this is my first proper portfolio project.

It's a supermarket sales dashboard built entirely in Excel using a Kaggle dataset. The dataset isn't perfect, but I wanted to use it as a starting point to practice cleaning data, building KPIs, PivotTables, slicers and visualizing the results.

I'd really appreciate some feedback on it:

• Does the dashboard answer useful business questions?
• Are any of the charts or KPIs misleading/unnecessary?
• What would you improve about the layout or design?
• What analysis would you add to make this a stronger portfolio project?

It took me about a week to finish, which felt a bit long, but I'm still new so I'm assuming I'll get faster with practice.

I'm learning SQL now and planning to move into Power BI next, so eventually I'd like to build something similar using SQL + BI.