If you can only pick one thing from this whole story, it should be the quote above. You’ll understand better as we move on.

So we have this poorly designed dashboard:

The goal for this article is to revamp this dashboard. Make it more presentable & aesthetically pleasing.

But first, let’s identify the things that are wrong with the dashboard:

• The first chart; _Profit by Product _could definitely be better presented & made cleaner. It contains too many data points that could be limited.
• The 2nd chart which is a time chart could’ve been displayed by a better one. Which one(s) do you think it can replaced by?
• The Scatter Chart could be cleaner with a more descriptive title
• Revenue & Profit by Country presented in percentage %? Not a good idea.

Taking it apart one after the other;

This is too noisy, first of all, it could be presented on a Bar chart so that the categorical labels are easier to view;

Now we don’t have to crane our neck to see what products are there.

2nd, we could limit the number of bars (products) in the chart because honestly, no one wants to see the profit generated by every single product. So what we’ll do is get the top 10 most profitable products & put that on the dashboard instead:

like this

Now this looks way better.

#data-science #data #data-analysis #power-bi #data-visualization