Inventory and margin dashboards for a pharmacy chain
Daily dashboards for stock, turnover and margin across every pharmacy in the chain, with automatic reorder suggestions for purchasing.
- Client
- Pharmacy chain (NDA)
- Services
- Data & reporting
- Duration
- 7 weeks · 2025
- Location
- Turkmenistan, 3 cities
Too much of one thing, none of another.
Each pharmacy ordered stock on its own judgement. Some products expired on the shelf while others ran out, and purchasing had no single view of stock and sales across the chain.
- Frequent stock-outs of fast-moving products
- Expired stock written off every month
- No chain-wide view of margin by product
- Reorders based on guesswork
Stock and margin, visible every morning.
We built a data model on top of the chain’s ERP and point-of-sale data, with Power BI dashboards for purchasing, branch managers and owners, and a daily reorder suggestion for each pharmacy.
Daily data model
Sales and stock from every branch loaded into one SQL model each night.
Stock dashboards
Stock, cover days and expiry risk by branch and product.
Reorder suggestions
Suggested order quantities based on sales speed and cover targets.
Margin view
Margin by product group, supplier and branch for management.
Two quarters after launch.
Do you know what is on every shelf?
Tell us how you track stock today. We will suggest a first dashboard within one working day.