Kpiloom
Power BI version coming soon. We are testing every Power BI file before we sell it. The Excel and Google Sheets versions of each dashboard are ready to download now.

Power BI Inventory Dashboard Templates

A inventory dashboard shows what is in stock, what is about to run out and where money is stuck in slow stock. Pick your industry below to see a live preview of the Power BI version.

Choose your industry

KPIs in every inventory dashboard

KPIWhat it tells youFormula
Stock valueValue of all stock on hand at cost.SUM of (Quantity × Unit cost)
Stock turnoverHow many times stock is sold and replaced in a year.Cost of goods sold ÷ Average stock value
Out-of-stock itemsItems with zero quantity on hand.COUNT of items where Quantity = 0
Reorder alertsItems at or below their reorder level.COUNT of items where Quantity ≤ Reorder level
Days of inventoryHow many days current stock would last.Stock value ÷ Average daily cost of sales
Fill rateShare of order lines shipped complete from stock.Lines filled ÷ Lines ordered
Dead stock valueValue of items with no sales in 90+ days.SUM of stock value where Last sale > 90 days
ShrinkageStock lost to damage, theft or errors.(Book stock − Physical stock) ÷ Book stock