Sales Effectiveness Dashboard

I would like to offer my dashboard for purchase. You can use it as a training material or portfolio.

The objective of this dashboard was to determine the overall sales scenario of the company and factors driving their sales for product lines such as accessories, clothing, bikes and components.

1. The page is divided into three segments; sales overview, demographics and financial analysis.

1) SALES OVERVIEW PAGE:

The following page displays sales achieved in order quantity and by value showcased through KPI'S such as

1.1) Sales volume by category

1.2) Sales Amount by Territory

1.3) Order Quantity by Category

1.4) Sales Breakdown by Category and subcategory: A drill down feature is given to show how that particular amount is being computed.

An year slicer is given to filter out data as per selected year.

An additional feature is also given as bookmark to change language from english to French. Additionally, filters such as year, product category and subcategory both in english and french are given as separate filters.

ANALYSIS:

1. Most of the sales arrive to the company from accessories category followed by bikes

2. United states tops the lead in terms of purchase.

2) DEMOGRAPHICS:-

The following page shows how location, commute distance and choice plays a crucial role in sales.

A donut chart is used to show close the distance, more is the accessibility to consumer for purchase, hence more sales.

A chart is given for maximum sales by clothing sizes bought by customers.

This table shows the customer order ID, customer name, yearly income, commute distance, order quantity and sales.

3) FINANCIAL ANALYSIS:-

This is the final page of the dashboard which focuses on profitability done through sales.

3.1) Year on year change % change is being shown in terms of sales

3.2) The category wise profitability and in different years in terms of % is being shown

3.3) There have been sales of accessories and bikes but which accessories gave the maximum revenue to the company is being shown using treemap visual

3.4) A sales information table was given to show how much profit was generated after deducting cost and taxes.

3.5) A cost to analysis field is calculated to show how much was the % increase or decrease there was when purchase cost was incurred and sales recovered it.