Inventory
The Inventory module of COSMO Analytics (BC on Fabric).
The Inventory module turns Dynamics 365 Business Central inventory transactions into an analytics-ready star schema. It gives a transparent view of on-hand quantities and inventory valuation, inbound and outbound movements, cost-price and adjustment developments, plus stock-health KPIs such as reach, turnover rate and out-of-stock items - with built-in time intelligence and multi-currency / multi-company support.
Key capabilities
- On-hand stock and inventory valuation analytics (quantity and cost amount)
- Inventory movement analysis (receipts vs. issues) and stock development trends
- Stock-health KPIs - reach (days), turnover rate, items on-hand and out-of-stock
- Cost-price development and inventory-value adjustment tracking
- Item- and location-level drill-down with time intelligence (PY, YoY, YoY %)
Who is it for
| Persona | Focus |
|---|---|
| Inventory / Warehouse Manager | Keep stock levels healthy - avoid overstocking and out-of-stock, and steer reach and turnover. |
| Supply Chain / Logistics Manager | Balance stock across locations and keep goods flowing through the supply chain. |
| Operations Manager | Ensure product availability while keeping capital tied up in stock under control. |
| Controller / CFO | Monitor the capital tied up in inventory, its valuation and cost-price effects. |
Navigate the module
- Key business questions: What can I analyze?
- Semantic model: Overview · Facts · Dimensions · KPIs
- Standard reports: Overview · Summary · By Location · By Item
At a glance, the inventory semantic model ships 106 measures, 22 dimensions and 1 fact table(s).
Tip
Have an ad-hoc inventory question? Build your own report on the shipped semantic model in Power BI in just a few clicks - the measures, dimensions and time intelligence are ready to use.