img10
Sales Dashboard – nice combination of 4 charts & 4 tables
Created by: lokesh_dc

About Dashboard:

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

There are 4 charts & 4 tables in this dashboard & all of them are linked with a single drop down menu.With this dashboard, we can view the report by month-wise.

This helps in tracking the overall sales performance of the organization. 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.

Thanks everyone for participating and making this a huge learning experience for everyone. Excel Forum team has learned several useful dashboard and charting tricks.

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

Let us see how the Dashboard made by Lokesh looks:

img1

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

Section1:

This is the drop down list of months, which is linked with all the 4 tables & 4 charts in this dashboard. If we select any month then the formulas will retrieve the data for that month &the previous month. This way we can compare the performance of sales for two months at the same time.

img2

Section2:

This section provides sales performance region-wise for the selected month & the previous month.

img3

Section3:

The following picture provides sales performance customer–wise,in detail for the selected month &the previous month.

img4

Section4:

The section will provide product-wise data for the selected month &the previous month.

img5

Section5:
This section covers person-wise sales report for the selected month & one month prior to the selected month. With this data, we can identify the top & bottom performer. This will surely help in taking new decisions to increase the total sales.

img6

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

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>

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