πŸš€ Projects

In this section, you can find several projects of visualization tools, and web applications for supply chain optimization or logistics process improvement.

ABC Analysis & Product Segmentation πŸ“ˆ

πŸ’‘
A statistical methodology to segment your products based on turnover and demand variability using an automated solution with a web application designed with the framework Streamlit.
User Interface of the Web Application

πŸŽ“ Topic

Product segmentation refers to the activity of grouping products that have similar characteristics and serve a similar market. It is usually related to marketing (Sales Categories) or manufacturing (Production Processes).

The objective is to understand the sales volumes distribution (fast/slow movers) and demand variability to optimize your production, storage and delivery operations to ensure the best service level by considering:

  • The highest contribution to your total volume: ABC Analysis
  • The most unstable demand: Demand Variability

I have designed this Streamlit App to provide a tool to Supply Chain Engineers for Product Segmentation, with a focus on retail products, of their portfolio considering the complexity of the demand and the volume's contribution of each item.

πŸ“œ Understand the Theory

Product Segmentation for Retail with Python | Samir Saci
A statistical methodology to segment your products based on turnover and demand variability

πŸ“‰ Access the Application

You can access the application here: link

πŸ–₯️ Source Code

The entire source code with explanations is available in this Github repository: Code.


Improve Warehouse Productivity πŸ“¦

πŸ’‘
In a Distribution Center (DC), walking time from one location to another during the picking route can account for 60% to 70% of the operator’s working time.

Reducing this walking time is the most effective way to increase your DC overall productivity.

πŸŽ“ Topic

In a Distribution Center (DC), walking time from one location to another during the picking route can account for 60% to 70% of the operator’s working time. Reducing this walking time is the most effective way to increase your DC overall productivity.

I have published a series of articles that propose an approach to designing a model to simulate the impact of several picking processes and routing methods to find optimal order picking by using the Single Picker Routing Problem (SPRP) for a two-dimensional warehouse model (axis-x, axis-y).

SPRP is a specific application of the general Traveling Salesman Problem (TSP) answering the question:

β€œGiven a list of storage locations and the distances between each pair of locations, what is the shortest possible route that visits each storage location and returns to the depot ?”

πŸ“œ Understand the Theory

Improve Warehouse Productivity using Order Batching with Python | Samir Saci
Design a simulation model to estimate the impact of several Single Picker Routing Problem strategies in your Picking Productivity

πŸ–₯️ Source Code

The entire source code with explanations is available in this Github repository: Code.


Vaccination Centers Availability in Paris using Google Maps Visualization Tool πŸ—ΊοΈ

πŸ’‘
Visualize available slots for vaccination in Paris with additional information like vaccine type, booking contact, address

πŸ“œ Understand the Theory

A Python Flask Web Application that extracts information from the health authority's official website and creates visuals using Google Maps API.

The application is hosted in Heroku using the free tier plan, you can face a short loading lead time of 5 seconds for your first connection.

πŸ“‰ Access the Application

You can access the application here: link


Interactive Visualization using D3.js πŸ“ˆ

πŸ’¬
Examples of visualization built using the javascript library D3.js

Luxury Brands E-Commerce Sales Matrix

πŸ’‘
Smart visuals using matrix charts of cosmetics sales with color coding to understand customer behavior

πŸ“‰ Access the Visual

You can access the application here: link

Cosmetics Product Sales Sankey Chart

πŸ’‘
Analyze cosmetics sales using a responsive Sankey Chart by sales channel, brand or category

πŸ“‰ Access the Visual

You can access the application here: link

Violin Plot Chart for Pareto Analysis

πŸ’‘
Pareto analysis of sales by item using violin plot and color mapping

πŸ“‰ Access the Visual

You can access the application here: link

Post Offices in France

πŸ’‘
France map divided in hexagons to measure the density of Post Offices per zone

πŸ“‰ Access the Visual

You can access the application here: link


Telegram Bot for Shipment Tracking πŸ“ˆ

πŸ’‘
Design a Telegram Bot that will interact with truck drivers to track your shipments and provide real-time visibility of your transportation performance

πŸŽ“ Topic

Implement a simple, cheap and easy-to-implement solution to track your shipments that

  • Does not require additional IT development for your carriers
  • Easily integrates into the current transportation processes
  • Reduces admin workload for your logistics team
  • Does not impact drivers’ productivity
  • Does not require additional equipment
  • Provides visibility, real-time tracking and transparency

How does it work?

Scenario Your shipment has been unloaded in your store. DRIVER wants to send delivery confirmation before leaving for his next destination.\

Step 1: DRIVER opens telegram and starts a discussion with BOT

This is an image

Step2: DRIVER shares its GPS Location (= Store Location)

This is an image

Step 3: DRIVER shares a delivery number

This is an image

Step 4: DRIVER shares a picture of the shipment

This is an image

Step 5: Your logistics teams receive a shipment confirmation

This is an image

πŸ“œ Understand the Theory

Build a Shipment Tracking Tool using a Telegram Bot
Design a Telegram Bot that will interact with truck drivers to track your shipments and provide real-time visibility of your transportation performance

πŸ–₯️ Source Code

The entire source code with explanations is available in this Github repository: Code.