Boost your Productivity with an Automated Tool for the Creation of Supply Chain Operational PowerPoint Reports with Python
In this Article, we will build a solution to automatically create PowerPoint slides with visuals and comments.
You are part of the distribution planning team of an international clothing retailer with stores on all continents.
Your distribution network includes several local warehouses that replenish the stores.
On a regular basis, you have to share warehouse operational indicators with your management.
This is a manual process in which you need to
- Extract data from the Warehouse Management System (WMS)
- Process data and built visuals with Excel
- Send a short report by email with the visuals and comments
To be efficient, you would like to automate the process of PowerPoint deck creation.
Your solution will be fully automated
- Extract order lines of the last month from the WMS SQL database
- Process the data and compute KPIs with key insights by week
- Automatically put the visuals and insights in a PowerPoint presentation
This repository code you will find all the code used to explain the concepts presented in the article.
Senior Supply Chain Engineer with an international experience working on Logistics and Transportation operations.
Have a look at my portfolio: Data Science for Supply Chain Portfolio
Data Science for Warehousing📦, Transportation 🚚 and Demand Forecasting 📈