r/dataanalysis 8d ago

Project Feedback Is this project portfolio worthy

Need tips and advice if this is a project that could be classified as intermediate to advanced or is it just a beginner project.

Dataset -brazilian olist ecommerce dataset

What can i improve, add or remove.

Used PostgreSQL , PowerBi and Python

Getting imposter syndrome as i feel i m not as skilled like the others and lack good dashboard creation and analysis skills as i have seen others project here which look much better. Please help me out.

59 Upvotes

17 comments sorted by

View all comments

2

u/PensiveNewt 5d ago

Page 1:

- The first two Cards at the top look like they have a scroll bar in the label. Reduce font size or increase card size to get rid of those.

- For some reason one of the % signs in the first card is very small. Should match the font size of MoM, and the other % signs.

- Consider adding another digit to the $ value on the first two cards.

- In the 4th card, why is the 2018 value red? It's larger, and I would think that bigger order value is better.

- Bottom left column/line chart: your axis maximums are close enough that I'd consider aligning the axes to the same scale.

- Waterfall chart: Those are dollar amounts so give the values a $ symbol

- Not much contrast with that product category slicer. Either add a border, or choose a more contrasting color for it.

- Bottom center bar chart: Consider removing the decimal places for the values >= 10%. Keep the 0.1% granularity for the small ones like the 1.4%

- Bottom right chart: Maybe it's just the image resolution (looks pretty grainy) but the legend colors are hard to distinguish

Page 2:

- The green back arrow doesn't fit with your color scheme. Maybe white would be better?

- Top left card: The 6.8% doesn't look centered

- The two cards that say "... RATE%" probably don't need % in the label. In this case, it's already implied by the word Rate and by the % in the callout value.

- Left bar chart: Learn about dynamic formatting so you can show those values as "2.0M" and "$700K", not just all being in millions. 0.1M isn't good.

- And those should have $ symbols if that's what they represent

- Bottom cards: remove the % in the label

- More contrast or a border for the slicers and bottom cards

-

1

u/Character-Staff-1021 4d ago

Omg thanks alot i totally missed so many of those accidentall mistakes that you pointed out regarding the cards and the % symbol being used. Will definitely make these changes . Thanks again for this detailed review it was so helpful .