This dashboard showscompany salestrend sorted by region, customer type, product, month& year.
The aim of this dashboard is to provide business insights about important areas of the sales process. With this dashboard, you’ll be able to identify the strengths and weaknesses in the sales process. The key focus of this dashboard is on showing sales credibility& management visibility.
There are several ways in which you can visualize sales data in order to understand the market trends and sales performance. In the month ofOctober, ExcelForumteamhas launched a dashboard competing in which you are asked to visualize data using sample data. The challenge has generated a huge thrill around the community and has fetched 118 incredible entries.
Thanks everyone for participating and making ita huge learning experience for everyone. ExcelForum team has learned several useful dashboard and charting tricks.
In this article, we will elaborate the method of creating this dashboard.
Let us see how the Dashboard made by tjulianna88 looks:
We have divided this dashboard into 8 sections of information. Let us take a look at each one separately.
This section provides flexibility to the end user of selectingsingle or multiple regions at thesame time, and also the related information links will get updated automatically.
The above snapshot shows the highest as well as thelowest sales month of the selected region.
This section provides information on sales trend on the basis of month and year for the selected region.
The following picture shows region sales by customer type.
This section highlights regional sales on thebasis ofsales person,using column chart.
This section contains performance analysis by product, month and the customer type.The map will be dynamically updated, region wise, in percentage.
If we select product 1 & product 12, then these products will be highlighted, and the information will be updated in map and rank table.
In performance analysis, there is this table that provides information about rank of sales person, yearly. We can find the topmostas well as thebottommost sales person.There is a scrollbar technique that is used to dynamically update the tablein order to see the entire sales person on a yearly basis & difference in percentage. This table can be sorted in both ascending & descending order.
Using this dashboard, you can get a clear view of the Sales industry and the information from various points of view.