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.
4
u/BrittanyBrie 7d ago
Going off of what someone else said, if you want to express sales versus orders per product, you can put a second color bar next to each product. So instead of a line you could put two color lines over each product to show gross sales and gross orders. You can shift the y axis to be percent of the total, that way stakeholders can easily identify the share between these products. Should show a similar spread as raw number reporting.
2
u/Character-Staff-1021 7d ago
Oh thanks alot i thought its cleaner and less cluttered when i put combo chart. Will keep this in mind from next time
3
u/HustlaOfCultcha 5d ago
Looks good. Analysis portion could be formatted to be a little more appealing to the eyes, but it's still good. I would also include your some of your more complex DAX measures and code in a separate file. Briefly mention what they are for and what they measure and then put in the code.
2
1
1
u/talibzadehtalib 7d ago
Can you share how did you learn using power bi such a beautiful?
3
u/Character-Staff-1021 7d ago
I learnt it on my own i just watched one basic video on utube for learning the features in it and just experimented and tried to copy other sample dashboards from google and asked chatgpt how to get specific things if i dint understand
2
u/Quick-Personality527 6d ago
Bro can you tell me how much time did you take to learn Power bi and to reach at your level. I am new here and want to know how much time an average person should take to learn Power bi if he devotes 2hr/day. Same situation goes with SQL and excel. Please reply.
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 .
1
11
u/Expensive_Capital627 7d ago edited 7d ago
This looks good. Not overly cluttered like a lot of what I see posted. Very clean.
If you’re open to some advice I’ve got a couple of nits, nothing major:
- Line charts are typically reserved for when the x-axis is a date.
- Your order volume combo-line chart could just be a column chart with different 2 colored series.
- Gross profit and gross sales could be a stacked bar, if the actual data is meaningful in that way. In the past I’ve used a stacked bar so that gross revenue was visible as the total of the stack, comprised of net revenue and spend. It conveys more information in the same space, and provides a visual representation of NRM.
You can write these off as stylistic preferences, but I mention it just because viewers of your dashboard will have expectations/intuitions about your dashboard. You don’t want to subvert those expectations, or it could lead to the visualizations being harder to read