Stock dashboard in Power BI
Every night, we record stock by item and location in a Power BI model. For Fokker Services Group, we built a KPI dashboard system.
A modern dashboard system for tracking KPIs helped Fokker Services Group run its operations with greater focus
Fokker Services Group wanted the BACE-next dashboard to display all key KPIs in a central web application, providing a clear view of its operations so that bottlenecks could be spotted and addressed sooner. We used Python and Dash to build the dashboard system.
How much money is tied up in our stock, and how much of it hasn’t moved in a long time?
The ERP system knows today’s stock value, the WMS knows where it is, and the till records sales. Last quarter’s figures are often only available in an old export. A nightly snapshot lets you track stock value, turnover and slow-moving stock by location over time.
An inventory dashboard shows value, turnover, coverage, non-moving stock and outstanding purchases by location
Stock value by location
Quantity multiplied by cost price for each item, warehouse and branch, as at any reporting date, so you can see where your money is tied up in stock.
Stock turnover and coverage
How often stock turns over and how long current stock will last at the current rate of consumption, by product group. The latter is a calculation, not a promise.
Non-moving stock and losses
Items with no movement since a reporting date you choose, and stock written off due to breakage, spoilage or loss, including its value.
Outstanding purchases alongside current stock
What has been ordered but has not yet arrived, alongside current stock and consumption. For Fokker Services Group, we connected data streams to inventory management, among other areas.
The cost price and locations to include are agreed before the first snapshot is generated
-
Cost price and reference date
Which cost price you use, when an item is considered slow-moving, and which warehouses and branches are included.
-
Build snapshots
Record stock levels by item and location from the ERP or WMS each night, including stock movements and outstanding purchase orders.
-
Reconcile and roll out
Reconcile the total value with finance’s inventory valuation, then set permissions by location and a fixed refresh schedule.
Does our ERP show enough about our stock, or would a separate dashboard be worthwhile?
A good fit if
Your stock data is spread across ERP, WMS and point-of-sale systems, or across multiple locations, and you want to see how stock value and slow-moving stock change over time, not just today's stock levels.
Not a good fit if
You have one warehouse, your ERP shows stock levels and value per item, and nobody needs to track changes over time. In that case, a dashboard mainly gives you a second place to find the same figures.
What determines the scope
The number of locations and data sources, whether item numbers are consistent across systems, how much historical data you want to build up, how often you record stock levels and who will manage the dashboard afterwards.
Does the value match finance's figures?
Only if you use the same cost basis. We establish whether you use a fixed standard cost, the average purchase price or the latest purchase price, then reconcile the total with the accounts.
ERP reports, Power BI snapshots or a data platform across all locations?
Your ERP inventory reports
Choose this if the current stock level and value per item are enough. You don’t need to build anything, but you often can’t look back at an earlier stock level.
Power BI with your own snapshots
Choose this if you’re working with one or two sources. Our advice: record a snapshot every night from the start, because you can’t recover a missed reporting date later.
A data platform underneath it all
Choose this if you need to bring together ERP, WMS and point-of-sale data from multiple locations and retain years of history. Read about the data and AI platform.
We’ve already brought inventory, ERP and KPI data together for Fokker Services Group
Data Science Lab has worked with data and AI since 2016 and is a Microsoft Partner for Fabric. For Fokker Services Group, we built a KPI dashboard system, a data platform and a dashboard that connects its ERP system to external marketplaces.

In our first conversation, we’ll discuss your warehouses, your ERP or WMS and the inventory list you currently maintain
Stef Stoelwinder
Business DevelopmentStef is your first point of contact. In our first conversation, we’ll discuss your locations, your ERP or WMS and which stock figure needs to be accurate first.
E-mail info@datasciencelab.nl
Phone +31 (0)20 3636 724
Which stock figure would you like to see for each location?
Tell us which ERP, WMS or point-of-sale system you use and how many locations you have. We’ll reply by email, or we can arrange an initial conversation.
Message sent
Thanks for your message. We’ll be in touch as soon as possible.
Frequently asked questions
An inventory dashboard shows what is in stock and what it costs: the value by location, stock turnover, obsolete stock, write-offs and outstanding orders. A Power BI inventory dashboard calculates these figures in one model, so purchasing, logistics and finance all see the same numbers.
An inventory management dashboard is one of our Power BI dashboards, which we build around the decisions they support.
Many systems store the current stock level, but not last month’s. If you want to track changes over time, you need to record those levels yourself. Microsoft calls this a periodic snapshot: an inventory table that records the closing stock level for each product every day.
That lets you look back without adding up every transaction again. Start early, because you cannot recover a stock level you never recorded.
A stock level is semi-additive: you can add it up across locations at a given point in time, but not across time. Add the levels for January, February and March, and you count the same box three times. Microsoft also advises against adding up units of different products; you can add up their monetary value.
In DAX, you therefore use the stock level on the last date in the period. Microsoft gives CLOSINGBALANCEMONTH as an example for calculating inventory value at the end of the month.
Stock turnover is the cost of the goods you sold or used, divided by the average inventory value over the same period. Coverage is the current stock level divided by average consumption per period.
Both calculations use past data. Low coverage tells you stock will be tight if consumption stays the same, not when the next delivery will arrive.
Stock is obsolete if it has not been sold or used since a cut-off date chosen by the business for each product group. A spare part can sit in stock longer than a fresh product. Define that cut-off, and the model calculates the value of stock that exceeds it.
You can identify stock losses from write-offs with a recorded reason, such as damage, spoilage or loss. Without a reason code, you can only see that something is gone.
For each order line, you take the quantity ordered, the quantity already received and the expected delivery date from the ERP system. The difference is the outstanding order quantity, which you display alongside the stock level and consumption for each product.
If you also want to see how long orders take to move through the process, you can use what Microsoft calls an accumulating snapshot: one row per order line, with a date for each step.
Typically, stock levels, costs and purchase orders come from the ERP system; locations and stock movements come from the WMS; and store inventory comes from the point-of-sale system. We have separate pages for specific software, such as Picqer and Lightspeed Retail. With row-level security, a branch manager sees only their own location.
The inventory value on the balance sheet appears on the financial dashboard.
If you have one location, your ERP system shows stock levels and value by product, and no one needs to track changes over time. Or if product numbers differ between systems: in that case, start with data quality.
If you want to know when and how much to order for each product, you need a model rather than a report. Read more about inventory optimisation.
When to reorder, the warehouse or all your dashboards: what do you put alongside your inventory figures?
- Power BI dashboardsEvery dashboard we build is centred on the decision you make with it.
- Inventory optimisation with data and AISafety stock and reorder points for each item, based on demand and lead times.
- Picqer Power BI dashboardOrders, pick lists, inventory by location and returns from Picqer in Power BI.