Forum Discussion
Demand planning
Hi,
Can power bi do demand planning, including stock allocation.
5 Replies
- amitchandak
Super User
amjedashraf , The information to less to suggest some solution.
Ideally, Power BI is not a demand planning tool. But there are few Articles around the same, see if they can help
https://blog.enterprisedna.co/estimating-future-product-demand-in-power-bi-using-dax/
https://www.youtube.com/watch?v=G0zI6GEgEkk
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi Amit,
Below are few senarios.
Stock Allocation:
Below for exmaple stock received at Warehouse
Product Stocks Store a 34 Warehouse b 35 Warehouse c 36 Warehouse d 37 Warehouse a 38 Warehouse b 39 Warehouse c 40 Warehouse d 41 Warehouse a 42 Warehouse b 43 Warehouse c 44 Warehouse Below are the is the situtation at store, now system could use AI to idenfity which store is have low stocks and automatically creates a allocation/ distribution. like Product A QTY: 5 Store allocation : D
Store A Store B Store C Store D Product Stock Sales Stock Sales Stock Sales Stock Sales a 2 1 2 1 2 1 2 1 b 4 2 4 2 4 2 4 2 c 5 3 5 3 5 3 5 3 d 6 4 6 4 6 4 6 4 a 8 5 8 5 8 5 8 5 b 9 6 9 6 9 6 9 6 c 10 7 10 7 10 7 10 7 d 11 8 11 8 11 8 11 8 a 13 9 13 9 13 9 13 9 b 14 10 14 10 14 10 14 10 c 15 11 15 11 15 11 15 11 - Greg_Deckler
Community Champion
amjedashraf Are you looking for something like Days of Supply?
https://community.powerbi.com/t5/Quick-Measures-Gallery/Days-of-Supply/m-p/635656#M318
- karaoan
Kudo Kingpin
amjedashraf Power BI actually can be a fantastic platform for planning. You might want to look at Acterys https://www.acterys.com which offers extensive features (8 custom visuals, Acterys Power BI Sync for write-enbabling any Power BI model) for demand planning and has transformed planning process alongside significant cost savings at some of the biggest organizations in the world.
