Feedback on my first data analytics dashboard / portfolio project

[u/Accurate_Data4642]

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.

[u/DataDaria]

Solid first project - the Key Insights box alone puts you ahead of most beginner dashboards: you're already trying to say something with the data, not just display it.

1. Decide who this dashboard is for and what they decide with it. A store manager deciding staffing? A category manager deciding stock? Right now it describes the business. The strongest portfolio move is to pick one user and make every chart answer their question - you'll cut half the elements yourself after that.

2. The payment donut is the first candidate to cut. Your own insight says "no dominant payment method", meaning the chart's answer is "nothing to see here", so that chart is pure decoration.

3. Small polish that reads as seniority: round the labels ($66,728.97 to $67K as cents add noise, not accuracy), and label only the first, last and extreme points on the line charts instead of every month - you already have an axis for the rest. Also check the screenshot state: "Revenue by Branch" is showing a single bar because the Brooklyn slicer is on - a comparison chart with nothing to compare. For the portfolio screenshot, show the full comparison.

4. The strongest analysis upgrade you can do with this same data: decompose the May–August decline. Revenue = orders × average order value - show which of the two drove the drop, and whether it hit all branches and categories equally. That turns "revenue declined" into "here's where the problem lives", and that's exactly what a portfolio reviewer wants to see.

Btw, a week for a first dashboard is completely normal! Speed later comes from reusing your own template.

[u/AutoModerator]

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.

[u/affanxkhan]

Excellent bro keep improving i would say KPIs u need still only would show the wholesome of performance

[u/Rough_Load3173]

Have you built this on your own or some tutorial?

[u/Accurate_Data4642 → u/Rough_Load3173]

no i have done it on my own i got the data set from kagle and just started working on it i didnt have a goal ijust wanted to see what i can find out on my own no youtube videos or tutorials

[u/NightRain3]

Looks like a report more like an analysis. Why did orders drop in august? Why is the brooklyn branch selling more? Which Actionable directives can we get from this?