The picture above is today's goal. We want to create a dashboard providing
1. How much sales we generate through years by Category and Sub Category.
2. What segments purchase what. Sales and Profit Margin are shown.
Again, reference is here. I didn't mention how to download. See this video below.
Let's start with the table. This is simply showing what, when and how much category sell.
This dashboard is all about basics, so it will be easy to create this.
And about dot chart, this is also basics. However, I would like to show how to edit a text popping up when you mouse it over and how to add reference line.
Then, add some filters whatever you need. Today's post is not so hard.