Dashboard Samples

Home/Dashboard Samples

Here’s a sample of sales dashboards included in our library of over 5,000 reports, dashboards and KPIs:

Top Performers

Shows top sales this year. We also have this for quarter and month.

top-sales-and-gp-this-year

Ship To – by Customer

The user searches/selects a customer from the drop down list, and query shows their sales in the same month in the last 2 years. Red colors indicate that there’s a sales decline comparing to last year. This can be helpful to address declining sales and see why certain regions are doing better than others. We have similar dashboards by product and salesperson.

customer-shiptos

Customer Trends 

  • Similar to the dashboard above. The rep can select a customer and:
    See sales trends by month
    See which products have declining sales from the same period last year. If the rep is in a call with the client, the rep can investigate reason for sales declines.

We have similar dashboards by product and salesperson.

customer-trends


Top Products and their ShipTos

Dashboard shows top products and their sales by ShipTo. User can change number of top products, as well as what period to look at.
This can be helpful addressing logistics and shipping methods for top products.

top-products-by-sales-shipto-sales


Sales of Top Products to Top Customers

Ideally, top customers should be buying lots of top products. If not, why not?
There are similar reports showing sales of top customers and top products by different dimensions such as salespeople, ship to, and cst address.

top-customers-and-top-products-sales


Company wide Monthly Sales Trends

Shows company wide sales trends (sales, accumulated sales, and growth). We also have this by year.

sales-trends-by-month-trends

QTD Sales and Year-over-Year Sales Growth – by Salesperson and Customer

A detailed report showing quarter-to-date sales this and last year by salesperson and customers. Why some of them (red fonts) are declining? Can you do something about it? We have similar dashboards by product, customer address, ship to and salesperson (also by company in multi-company systems).

sales-same-quarter-across-years-by-salesp-and-cst

QTD Sold, Sales and Year-over-Year Sales Growth – by Product and Salesperson

A detailed report showing quarter-to-date sales this and last year by product and salesperson. Why some reps are more/less successful than others pushing products out?

sales-same-quarter-across-years-by-prod-and-salesp

Top Sales Decline by Customer – Customers with no sales in last 360 days versus prior 360 days (361 to 720 days).

This report is usually useful to find out which major customers aren’t buying anymore (we have this for last 30, 90 and 360 days. It’s easy to change the time buckets).
We have similar dashboards by product, customer address, ship to and salesperson.

sales-decline-by-customer-no-sales-this-360-days

Top Sales Decline by Product – Products with no sales in last 90 days versus prior 90 days (91 to 180 days).

This report is usually useful to find out which major selling items aren’t selling anymore (we have this for last 30, 90 and 360 days. It’s easy to change the time buckets).

We have similar dashboards by customer, customer address, ship to and salesperson.

sales-decline-by-product-no-sales-this-90-days

Sales and Sales Growth from the Same Period in prior Year(s) by Customer

A detailed report showing monthly sales and growth from the same period prior year(s). Amounts in red means decline from the same period in the prior year.
We have similar dashboards by product, customer address, ship to, and salesperson (also by company in multi-company systems).

customer-sales-yoy

Sales and Sales Growth from the Same Period in prior Year(s) by Product

A detailed report showing monthly sales and growth from the same period prior year. Amounts in red means decline from the same period in the prior year.
We have similar dashboards by customer, customer address, ship to, and salesperson (also by company in multi-company systems).

product-sales-yoy

Invoice Trends

Is it important for your organization to monitor average amount per invoice, invoice count, average items per invoice, and average days between invoices? Our dashboards and reports will provide you with a great starting point.
The example below shows average invoice amount and invoice counts over time. As shown, there’s a clear pattern of average invoice amounts to decrease from Jan to Dec.

sales-trends-by-invoice

What-If Forecast

This is an example of what-if scenarios where the forecast is calculated by applying user-defined growth and churn rate to actuals from period periods. Forecast can be calculated in a variety of ways or imported from other data sources (such as Excel or dedicated forecast systems).

what-if-forecast

Actual versus Budget

This is an example of actual versus budget where the budget is calculated by applying a user-defined growth to actuals from period periods. Budget can be calculated in a variety of ways or imported from other data sources (such as Excel or budgeting systems).

actual-versus-budget

Top YTD Sales Increase and Decrease by Customer

It shows which clients are growing the most and declining the most since  last YTD  (also for QTD and MTD).
We have similar dashboards by product, customer address, ship to and salesperson.

top-ytd-sales-change-by-customer

Top QTD Sales Increase and Decrease by Product

It shows which products are growing the most and declining the most since  last QTD (also for MTD and YTD).
We have similar dashboards by customer, customer address, ship to and salesperson.

top-qtd-sales-change-by-product

Sales Ranking by Customer 

How are your most important customers ranking on a year basis? Are they going up or down on sales ranking? See example below where customer #9 from Total dropped to rank 44 in 2016.

sales-ranking-by-customer


Sales Ranking by Product

How are your most important products ranking on a year basis? Are they going up or down on sales ranking? See example for customer ranking above for ideas of how this insight can be valuable.

sales-ranking-by-product

Sales Projections by Customer

DataSelf Analytics has different ways to project your sales (expenses, etc) based on different parameters (such as past performance, outstanding orders, and other inputs – example CRM opportunities).

sales-projections-by-customer


Sales Projections by Product

DataSelf Analytics has different ways to project your sales (expenses, etc) based on different parameters (such as past performance, outstanding orders, and other inputs – example CRM opportunities).

sales-projections-by-product


Comparison of YTD vs PYTD Sales by Customer

A report showing customer sales this YTD, prior YTD, YTD variances and full last year. The cart quickly shows box sizes based on YTD variance, and color based on growth/decline.

sales-ytd-vs-pyd-by-customer


Comparison of YTD vs PYTD Sales by Product

A report showing product sales this YTD, prior YTD, YTD variances and full last year. The cart quickly shows box sizes based on YTD variance, and color based on growth/decline.

sales-ytd-vs-pyd-by-product


Sales Change this 90 days by ShipTo

If ShipTo is critical, this dashboard shows sales variances this 90 days (it’s easy to change the time buckets). You can see the data across all sales or filter it by customer and/or product.

sales-change-this-90-days-by-shipto


Moving Averages

Is it important to monitor moving averages? Dashboards like the one below will help you monitor moving averages in different parts of your business. It’s easy to change the period included in the report as well as the period to calculate the moving average (such as avg among 3, 6 and 12 months).

product-3-mo-moving-avg

Top Sales Last QTD vs This QTD

This allows the monitoring of how top performers in the last QTD are doing in this QTD. Ideally, they are doing better now. These dashboards cover dimensions such as Salesperson, Customer, Product and ShipTo.

top-sales-last-vs-this-qtd

Sales and Gross Profit Scatter Plots

These dashboards can show outliers or trends that might not be so obvious. In the example shown here, Salesperson=Ingrid has a profitability way below than everyone else.

sales-and-gp-scattered-plots