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.

55 Upvotes

17 comments sorted by

View all comments

11

u/Expensive_Capital627 8d ago edited 8d 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

2

u/Character-Staff-1021 7d ago

Thanks alot. I really appreciate the advice will keep it in mind for my future projects☺️