Automate PowerPoint Slides Creation with Python 📊

Boost your Productivity with an Automated Tool for the Creation of Supply Chain Operational PowerPoint Reports with Python

Article

In this Article, we will build a solution to create PowerPoint slides automatically with visuals and comments.

Youtube Video

Click on the image below to access a full tutorial to understand the concept behind this solution

Scenario

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

Code

In this repository, you will find all the code used to explain the concepts presented in the article.

About me 🤓

Senior Supply Chain and Data Science consultant with international experience working on Logistics and Transportation operations.\ For consulting or advising on analytics and sustainable supply chain transformation, feel free to contact me via Logigreen Consulting\ Please have a look at my personal blog: Personal Website