Inventory Cockpit W.png Inventory Cockpit D.png
8 required attributes
  • Date
  • Warehouse / Store
  • Item Family
  • Item
  • Quantity in Stock
  • Unit Value
  • Target Stock Min
  • Target Stock Max
14 KPIs
  • On-Hand Quantity (SKU)
  • Inventory Value
  • Items in Inventory
  • Out-of-Stock Items
  • Under-Stock Items
  • At-Stock Items
  • Over-Stock Items
  • Under-Stock Value
  • Over-Stock Value
  • Out-of-Stock Items %
  • Under-Stock Items %
  • At-Stock Items %
  • Over-Stock Items %
  • Under-Stock Value %

Detailed presentation of the INVENTORY dashboard

KPi Your INVENTORY dashboard will contain 14 KPIs:

  • On-Hand Quantity (SKU)Quantity in Stock
  • Inventory ValueValue of Stock (currency)
  • Items in InventoryNumber of Items referenced in Stock
  • Out-of-Stock ItemsNumber of Items with no stock
  • Under-Stock ItemsNumber of Items below minimal stock limit
  • At-Stock ItemsNumber of Items within stock target
  • Over-Stock ItemsNumber of Items over maximal stock limit
  • Under-Stock ValueTotal Value of the missing stock (currency)
  • Over-Stock ValueTotal Value of the overstock (currency)
  • Out-of-Stock Items %Share of of Items with over stock
  • Under-Stock Items %Share of of Items with under stock
  • At-Stock Items %Share of of Items within Stock target
  • Over-Stock Items %Share of Items with over stock
  • Under-Stock Value %Share of Items Value with under stock

Visualization and 13 dashboard pages

Inventory Home
Inventory Home Inventory Home
Get a Home Page for your Inventory Dashboard
Inventory Cockpit
Inventory Cockpit Inventory Cockpit
Get instant overview of your inventory KPIs: At-Stock Items%, Under and Over-Stock Items%, Out-of-Stock Items, Over-Stock Value...
Inventory KPIs
Inventory KPIs Inventory KPIs
Understand the contribution to the performance of your top Inventory KPIs
Inventory Historical Analysis
Inventory Historical Analysis Inventory Historical Analysis
Understand Stock status over time, highlight Out-of-Stock, Under-Stock and Over-Stock occurrences over time per Item.
Inventory Historical Performance
Inventory Historical Performance Inventory Historical Performance
Understand Stock status over time, highlight Out-of-Stock, Under-Stock, Over-Stock and Out-of-Stock occurrences over time per Item and Warehouse
New and Dereferenced Items
New and Dereferenced Items New and Dereferenced Items
Visualize new and dereferenced items over time.
Inventory by Items and Warehouses
Inventory by Items and Warehouses Inventory by Items and Warehouses
Analyze stock status per item and warehouse. Visualize Over-Stock, At-Stock, Under-Stock and Out-of-Stock at a glance!
Inventory Top KPIs Evolution
Inventory Top KPIs Evolution Inventory Top KPIs Evolution
Visualize how your Inventory Performance is evolving (Month-to-Date, Year-to-Date)
Inventory Evolution over years
Inventory Evolution over years Inventory Evolution over years
Visualize how your top Inventory KPIs are correlated and how this correlation evolved across years
Inventory Segmentation Analysis
Inventory Segmentation Analysis Inventory Segmentation Analysis
Visualize the value of the KPI you selected split by the dimension you selected (share analysis)
Inventory Pareto Analysis
Inventory Pareto Analysis Inventory Pareto Analysis
Flexible Pareto Analysis (80 / 20 analysis)
Inventory Trends Analysis
Inventory Trends Analysis Inventory Trends Analysis
Visualize the evolution of the KPI you selected: Trends, Performance & Year over Year
Inventory Trends Split Analysis
Inventory Trends Split Analysis Inventory Trends Split Analysis
Visualize the evolution of the KPI you selected, breakdown by the dimension you selected.

 

You want to get a clear understanding on your Inventory? You want to build a Tableau dashboard to improve your stock management?

Using LinPack-for-Tableau.com, you can generate a stunning Tableau Dashboard on Inventory data in less than 1 minute!

 

Inventory dashboard Live Demo

 

For this, just follow the instructions :-)

 

1st step: Create a Tableau workbook containing the connection definition to your Inventory/Stock data (whether it comes from SAP, SalesForce, Excel...)

You must retrieve at least the following attributes:

  • date
    Date Date of the inventory
  • string
    Warehouse / Store Warehouse / Store
  • string
    Item Family Item Family / Product Family
  • string
    Item Item / Product / By-Product / Ingredient
  • numeric
    Quantity in Stock On-hand Quantity of Product in inventory (at Stock Keeping Unit)
  • numeric
    Unit Value Value of Item per SKU
  • numeric
    Target Stock Min Target minimal stock for this item
  • numeric
    Target Stock Max Target maximal stock for this item

The attributes names do not have to match and the underlying data model could be one file or 5 tables, it does not matter :-).

 

2nd step: On LinPack-for-Tableau.com, select 'create dashboard from template: Inventory' and upload your Tableau workbook

 

 

3nd step: Map your attributes, click 'Confirm & Download'... you're done!!!

 

This dashboard will help you to better manage your Inventory: 

Just try it here :-)

 

Enjoy and share your feedbacks with us so we can improve the solution :-)