Northwind Products and Suppliers
Track sales by region, average revenue per unit, and more.
This sales dashboard lists orders placed with the fictitious supply company Northwind Traders. With this dashboard, we can answer the following questions:
Firstly, what is our overall sales number?
How much have we sold of each product?
Which products are our best and worst sellers?
Which of our clients order the most products? What do they order?
How do our sales look when broken down by region?
Analyze Trends to Meet Customer Needs
By reviewing metrics such as the product categories with the most and least sales, leaders can ensure that they have sufficient inventory to meet customer demand. These bar charts are especially useful because they use the multi-level drill down feature. Just click a category’s bar to view a detailed breakdown of the products that make up that category and the total dollar amount of sales for each product.
The bar charts tracking maximum and minimum customer orders also utilize this feature. For example, by clicking the bar representing Specialty Biscuits, Ltd., we can see that the company ordered marmalade, bread, chocolate biscuits, and scones.
This data allows the supplier to ensure that their inventory matches customer demand.
Finally, the map illustrating customers’ locations could help the company focus their marketing efforts. It could also help them estimate shipping costs for their products.
Filter Your Data
One key feature of this healthcare dashboard is its versatility. With the “Product Category” drop-down list box filter, viewers can display data for any combination of categories. Then, users can reset the filter by clicking the funnel-shaped icon in the upper right corner of the drop-down list box.
This feature is invaluable for users who would like to focus their analysis on a specific set of products.