An Excel dashboard to show product level comparison for sales
Click to buy Sales Dashboard in Excel
Sales dashboard is very beautiful and informative dashboard. In the single page the maximum information has been covered. Product Level comparison section is very useful to analyze and compare month on month for different metrics. This dashboard has been designed specially for sales process. small pictures, sparks lines and dynamic chart make it more beautiful.
Key Functionalities of Sales Dashboard:
This dashboard can be divided in to 4 sections
- Slicers for Filter the data: Slice has been used to filter the data
- Summary : In this section Call Handled, Sales, AHT and Revenue metrics have been displayed, spark-lines also displayed for show the monthly trend for the particular metric.
- Location wise Sales Vs Revenue Chart : in this section a Combo chart ( a combination of line chart and column chart) has been displayed for Location wise Sales and Revenue.
- Product level comparison: This is very useful section. In this section there is metrics drop down list available. A line chart is available to compare month on month performance between two products (which have been selected in the left and right slicers) for the metric which has been select in the drop down list.
Click to buy Sales Dashboard in Excel
Raw Data of Sales Dashboard:
Below is the raw data snapshot which has been used to create the sales dashboard.
Click to buy Sales Dashboard in Excel
Support Sheet:
Below is the support sheet snapshot which has been used to create the this dashboard. In this sheet there some pivot tables and calculations.
Click to buy Sales Dashboard in Excel
Visit our YouTube channel to learn step-by-step video tutorials
Learn how to create this dashboard – Step by Step Video tutorials
Click to buy Sales Dashboard in Excel