In this demo, I’m going to show you data from a global chain of retail bike stores. This data set is from a hypothetical store chain, and was sourced from Microsoft’s database of sample data.
See an overview of the chain’s sales plus some geographic and demographic segmentation. Clicking through these charts lets you drill down and automatically filter the rest of the charts on this page.
Stock and Inventory
The bar graphs will show us the top 10 products sold on a given day within the date range above as well as the available inventory in the warehouse. They will want to keep good inventory of their top selling items, so we can see they should be concerned about jerseys, gloves, and helmets, etc.
We can see the what the warehouse has received in, or restocked, and what has been shipped out, to either their retails locations or direct to customers.
The section on the right shows the total value of product in stock per product category. With this, the store can see where they are investing the heaviest in inventory.
The last page shows orders placed by customers. We can drill down by month, by country or by the top ten products sold. This also gives us insight into what types of products are most popular in different regions and give indications as to where to spend marketing efforts.