Sales Performance Dashboard - good use of excel slicers and charts

Created by: karivaan

 

About Dashboard:

Sales Performance: - Every company has a product which they need to sell increase the returns. Ultimately if sales improve, the company will grow

Sales performance dashboard is a useful tool to analyze the performance of sales. By using the sales performance dashboard we can see individual performance and make improvements in the performance on the basis of data. It helps us to forecast the next vision of targets and achievements and managing things like improving the sales and how to generate more revenue etc.

Below shown dashboard is useful to analyze sales performance in every field.

img1

Tabs

img2

In the above shown image we have tabs related to Person, Customer and Product. When we select any tab the analysis will change and represent the report for the selected tab.

Chart:- Top Ten Customers 

img3

In the above image a bar chart is used to represent the performance about the customer’s score and we can analyze and take the idea who is having the highest score.

Chart:- Product Performance

img4

In the above image a Column chart is used to represent the performance and numbers of every product. We can analyze which product is selling more. In this chart we can see that Product 11 sale is very good compared toother products.

Chart:- Sales Per Month

img5

In the above image Line chart is used to represent the per month sales. In this chart we can see that the month of July’12 had very good sales.

Table:- Region Sales

img6

In this table Region wise sales are represented to analyze and inform that which regions are top sales, which regions are in the bottom and which regions are doing average sales.

In this table we can see that Region 17 is in the Top sales, and Region 8 is in the bottom sales.

Download Dashboard

Comments

  1. Your site is really nice and unique. This is one of the best idea that you had come up for the children and I do hope that they can have better future. 

Leave a Reply

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

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.