img3

Sales Dashboard – sales by region, product & sales analysis month-wise

Created by: ashley21

About Dashboard:

This dashboard shows company’s sales by region, product & sales analysis month-wise.

There are 3 dynamic charts which will be dynamically updated as we select sales person from the drop down list & scroll bar one for product &another for month-wise.

If you want to track conversion rate by team, you’ll be able to identify the strengths and weaknesses in the sales process. The key focus of this dashboard is to show sales credibility& management visibility.

There are several ways in which you can visualize sales data to understand the market trends and sales performance. In October, ExcelForum team launched a dashboard competition in which you were asked to visualize sample data. The challenge has generated a huge thrill around the community and fetched 118 incredible entries.

In this article, we will show you the steps on how to create this dashboard.

Let us see how the Dashboard made by Ashley21 looks:
img1
We have divided this dashboard into 6 sections of information. Let us take a look at each one separately.

Section1:

In this section, we can select the sales person & all the related information will be updated in the dashboard.

img2
Section2:

The picture below shows sales trend, product-wise for year 2011 & 2012. We can easily track the total sales, average monthly sales for both the years as these are linked with the product selection.

img3

On the left-hand side, there is a scroll bar, which is currently showing data for product 1. We can change the product & all the related data will instantly get updated, say, if we select product 2 then the below picture will show us the data which is related to product 2.
img4
Section3:

The following picture will show the quarterly regional sales by product type. The total quarterly sales & average monthly sales will keep on updating as we select sales person from the drop down list shown in section 1.

img5
Section4:

The last section covers sales, region-wise for all the months. We can use scroll bar to change the months & all the related information will dynamically update.

img6

If we use scroll bar towards the right side, then it will show the sales for the next quarter; refer below screenshot.
img7
Using this dashboard we can get a clear view of the Sales industry;and thus we can get the information from various points of view.

Download Dashboard

Users are saying about us...

  1. Lovely dashboard, is there a way to do this, by having the dropdown menu as months instead? so when you change the month all of your charts change?

Leave a Reply to Oldmaster Cancel 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>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube