A complete hands-on tutorial for processing retail sales data, generating KPIs, and creating Pareto & ABC visualizations.
Click the image below to open the full video tutorial on YouTube:
This tutorial walks you step-by-step through building a full Python notebook to process retail sales transactions and conduct an ABC Analysis.
Video Chapters
00:00 Introduction of the Python Tutorial
02:28 What is ABC Analysis?
10:51 Introduction of the Coding Part
13:34 Presentation of the LogiGreen App
15:32 Data Import and Processing
24:56 Pareto Analysis in Python
38:37 Creating the Pareto Chart
50:42 Create the ABC Chart
You can download the example datasets used in the tutorial here:
- Dataset β 100 Days: https://bit.ly/transactional-data-100
- Dataset β Light Version: https://bit.ly/transactional-data-light
Use these datasets directly or adapt them to your business scenario.
If you donβt have Python installed on your machine, you can run the entire notebook online using Google Colab β a free cloud environment with no setup required.
π Open Google Colab: https://colab.research.google.com/
Simply upload the notebook or import it from GitHub, and you're ready to run the analysis.
- LogiGreen Apps: https://bit.ly/logi-green-app
- LogiGreen Blog: https://bit.ly/logigreen-case-studies
- GitHub Repository (Source Code): https://github.com/samirsaci/tutorial-abc-analysis
- Reduce Warehouse Space with Pareto Analysis:
https://medium.com/towards-data-science/reduce-warehouse-space-with-the-pareto-principle-using-python-e722a6babe0e
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
