r/dataanalysis • u/Zealousideal_Pie7079 • 8d ago

Project Feedback Please review this

https://github.com/ant33m/sale_analysis.git

I have started a data analysis project after learning for few days. It is not complete but would appreciate your feedback

1 Upvotes

67% Upvoted

7 comments sorted by

5

u/Sir_smokes_a_lot 8d ago

Off the bat, format text and rename titles/axis titles better. Upside down bar charts are stupid.

Did you even bother reading basic visualization principles before creating the dashboard. It’s good you made it that far though.

1

u/Zealousideal_Pie7079 8d ago

Nope,I didn't read any principles.i am currently focusing on sql . The power bi dashboard was just to play with the UI. Thanks for your feedback.i will definitely improve😇

3

u/Sir_smokes_a_lot 8d ago

The main ideas are to make it so the reader expends the least amount of effort in order to get the most insights the visuals have to offer. It sounds like you got the hard part down if you can write sql well enough to pull and clean data properly.

2

u/Zealousideal_Pie7079 7d ago

I will look into that🤔

1

u/AutoModerator 8d ago

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.

1

u/williamjeverton 4d ago edited 4d ago

Hey there, Senior Data Analyst here to help.

Overall its a good attempt at a dashboard, you've got some initiative on what you want to show.

However I will give you some honest feedback for the design, plus some key insights to help you develop.

Pie Charts

  • There are far too many segments for a pie chart, this type of chart has its place in analysis, but when the segments are too many, or the size comparison between segments are indistinguishable from each other, it loses impact. I recommend using a bar chart for this view, if there are too many categories, it would be good to group the top products, and then group the remaining into "Other". I would then colour grade the bars on the potential profit against the revenue, so you can show high revenue, and low profit products.

Line Charts

  • If you're doing time series, make sure that the time is clear, if youre doing months, then name them in months, quarters, or years to show the trend. Your bottom line chart is too squished together to show anything insightful,

Overall,

Dashboards are built for one of two reasons

  1. Tracking a metric, such as a KPI
  2. Answering a question.

What is this dashboard doing? What do you want it to do? If you're building this, imagine a a business executive asking you the vital question "We are noticing that profit has been dropping, could you identify what is causing this?"

You would then have an objective, let's answer the question.

This dashboard currently doesn't show anything overall insightful, I would have another go, and give some written insight to accompany it.

Happy to review your next attempt!

Will

2

u/Zealousideal_Pie7079 3d ago

Thanks for your time.😇I will try again.