Optimus Information - Retail Store Sales and Inventory

This demo shows data with a retail focus. The data set shows inventory and sales for a chain of bicycle stores and the relationship between orders, stock control and sales. These dashboards offer the relevant high-level metrics needed to run a retail location smoothly and effectively.

Kontakt zu Partner aufnehmen Video ansehen
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. 

Overview

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. 

Sales

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. 

Sie möchten ein Power BI-Partner werden?

Zertifizierte Partner sind ein wichtiger Teil des Teams! Ermitteln Sie neue Geschäftschancen, vernetzen Sie sich, und teilen Sie die Talente und Erfahrungen Ihres Unternehmens mit Power BI-Benutzern auf der ganzen Welt.

Registrieren

Benötigen Sie Hilfe bei der Registrierung?
Wenden Sie sich an pbiptnr@microsoft.com.

Request demo