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.

Partenaire de contact Voir la vidéo
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. 

Vous souhaitez devenir un partenaire Power BI ?

Les partenaires certifiés constituent une partie importante de l’équipe ! Trouvez de nouvelles opportunités commerciales, établissez de nouvelles relations, et partagez les talents et l’expérience de votre entreprise avec des utilisateurs Power BI dans le monde entier.

S’inscrire

Vous avez besoin d’aide pour vous inscrire ?
Contactez pbiptnr@microsoft.com.

Request demo