Sales Dashboard – Good Analysis through Charts

 

Created by: tjulianna88

 

About Dashboard:

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:
 
img1
 

We have divided this dashboard into 8 sections of information. Let us take a look at each one separately.

Section1:

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.
 
img2
 
The above snapshot shows the highest as well as thelowest sales month of the selected region.

Section 2:

This section provides information on sales trend on the basis of month and year for the selected region.
 
img3
 
Section 3:

The following picture shows region sales by customer type.
 
img4
 
Section 4:

This section highlights regional sales on thebasis ofsales person,using column chart.
 
img5
 
Section 5:

This section contains performance analysis by product, month and the customer type.The map will be dynamically updated, region wise, in percentage.
 
img6
 
If we select product 1 & product 12, then these products will be highlighted, and the information will be updated in map and rank table.
 
img7
 
Section 6:

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.
 
img8
 
Using this dashboard, you can get a clear view of the Sales industry and the information from various points of view.
 
Download Dashboard
 



9 thoughts on “Sales Dashboard – Good Analysis through Charts

  1. Hi tjulianna88. Great dashboard. I am trying to learn and perfect dashboards. Is it possible to see the worksheets associated with your finished product at all please?

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>