Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Can power bi do demand planning, including stock allocation.
@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.
@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 |
@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
Hi Greg,
Days of supply can be calucated with a formula, like current stocks/avg.per days sales.
But this need a AI algo to check some conditions, Like Sales & Stocks of a partiuclar store and then some future events then allocate a partcilar stock to the store.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |