Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |