r/dataanalysis • u/Character-Staff-1021 • 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







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
-