Dashboards

Sales overview

The Sales dashboard gives us insights with a special focus on the sales. 

Location sales

This section is a table showing us the total sales in each location ranked according to the net sales. The first column is the location, the next column shows the net sales in the date range selected, the third column shows the sales a week prior to the selected date range and the final column shows the sales a year prior. 

Location

This section contains a pie chart displaying a visual representation of the location sales. The location with more sales has a larger percentage.

Category sales

This section features a table showing the total sales in each product category ranked according to the net sales. The first column represents the category, the second column shows the net sales for the selected date range, the third column shows the sales a week prior to the selected date range and the final column shows the sales a year prior. 

Categories 

This section contains a pie chart displaying a visual representations of the category sales. The category with more sales will have a larger percentage and will take up most of the chart area. 

Sales by day

This section includes a combined bar and line chart that represents the net sales realised on each day of the week in the selected date range. The bars show the actual net sales in the selected date range, the orange line chart shows the corresponding net sales in the week prior and the green line chart shows the net sales in the previous year for the same selected period. The x-axis shows the day of the week, while the y-axis shows the monetary values. 

Sales by hour

This section also features a combines bar and line chart. It shows the net sales realised every hour in the selected date range. The bar shows the net sales in every hour in the selected period, the orange line chart shows the corresponding net sales in the prior week while the green line chart shows the net sales in the previous year for the same selected period.  The x-axis shows the hour of the day while the y-axis represents the monetary values. 

Sales heat map

This section features a heatmap that shows the total number of items bought in a specific category for the specific period selected by month. The x-axis represents the categories, the y-axis represents the month and the z-axis represents the sales quantity. The colours in the heat map represent the total number of items sold in the respective categories for each month. The color intensity ranges from light to dark, indicating the number of items sold, with the darker hues indicating highest sales while lighter hues indicated lower sales. 

Quick sales analysis

This is a table that shows a quick analysis and sales performance in each location. It includes the total discounts offered in each location,  sales including tax, sales excluding tax, the cost of sales, the number of units sold, and the total profits realised in each of the locations.  

Interactive explorer

This is a link to a table, the Data Explorer, that  includes information on sales amounts (with and without tax), sales costs, the number of units sold, and end-of-period costs and quantities. 

Inventory Overview

The Inventory overview dashboard gives us insights with a special focus on the inventory. 

Inventory performance

This table provides a detailed analysis of the various product groups, highlighting key metrics such as average cost of inventory for the particular group, sales excluding tax, sales profit, GMROI (Gross Margin Return on Investment), DSI (Days Sales of Inventory), and inventory turn.

Inventory composition

This is a pie chart displaying a visual representation of the average cost of inventory for the specific product groups as seen in the inventory performance table. The groups with a higher average cost of inventory will have a larger percentage and will occupy most of the pie chart area. 

Cost vs Sales

This section features a combined bar and line chart that compares the average cost of inventory, sales excluding tax and sales profit for various product groups. The blue bars represent the average cost of inventory sorted in descending order, the orange lines indicate the sales excluding tax while the green line chart represents the corresponding sales profit for the specific product groups. The x-axis lists the different product groups, while the y-axis shows the corresponding monetary values. 

Interactive explorer

This is a link to a table, Group Performance, that includes information on the average cost of inventory, sales amounts without tax, sales costs, sales profit, DSI (Days Sales of Inventory), inventory turn and GMROI (Gross Margin Return on Investment) each product group. 

Profitability analysis 

This is a link to a table, Product profitability, that assesses the profitability of each product and classifies if as either Grade A, Grade B or Grade C. The table also includes other columns with more information such as the sales excluding tax,  sales profit, average cost of the stock, GMROI, DSI and inventory turn alongside the profitability grade and product name.  If the GMROI is greater than 80% then the product profitability is classified as Grade A, if it is less than 20% then the product profitability is Grade C, otherwise if it is in between 20%-80% it is classified as Grade B.