I will do inventory analysis and build an inventory dashboard with reorder point
Certified Data Scientist with skills in Python Excel SQL and ML
Level 2
Has met high performance criteria and has a proven track record for meeting client expectations.
About this Gig
Too much stock on some products, not enough on the ones that sell.
Most businesses only find out when a customer is already waiting.
I analyze your inventory data and show you, product by product, where you stand today.
What you get:
- Stockout risk: which products will run out soon, based on days of cover
- Dead stock: what isn't moving and how much cash is tied up in it
- ABC classification: the products that drive most of your sales
- Reorder points and safety stock (Premium)
- A clear Excel report: a one-page summary with your top risks, plus the full filterable table
Data quality issues (duplicates, name variants, negative stock) are flagged in the report, never silently changed.
Recent work: an inventory dashboard covering purchase orders, stock, shipments and KPIs, and a cleanup of 147,000 records.
Background: BBA in Supply Chain Management and 4+ years in data science.
I speak planner, not just Python.
Need to know how much you will sell next month? That is demand forecasting, see my other gig.
Send me a sample of your file (stock levels + sales history) and I will confirm what is possible before you order.
Expertise:
Classification
•
Anomaly detection
•
Predictive analysis
Programming language:
Python
•
SQL
Frameworks:
Scikit-learn
•
Panda
Tools:
Jupyter Notebook
•
Excel
•
Colab
My Portfolio
FAQ
Do I need to know Python to use this?
No. Basic and Standard come with a one-command script and written instructions, you run it, you get the report. Premium is a web app where you just upload a file. Nobody on your team needs to read code.
Why Python instead of Excel?
Excel breaks above a few hundred thousand rows and can't be automated reliably. Python handles millions of rows, re-runs on new data in seconds, and connects directly to your ERP or database. An Excel version of the output is available as an extra.
What files do you need from me?
Whatever you have: a stock export, sales history, or purchase order list. Excel, CSV, or a database connection. Messy is fine, cleaning is part of the job. I'll tell you within a day if something essential is missing.
Can I re-run it myself next month?
Yes, from Standard up. That's the point: you get a pipeline, not a one-off file. Drop in the new export, run one command, get the updated analysis.
How do you calculate reorder points?
From your own consumption history and supplier lead times, with a safety buffer set to the service level you want. No black box, the formula is documented so your team can check and adjust it.
Do you forecast future demand too?
That's a separate service of mine and my main specialty. This gig covers your current stock position. Message me if you want the forecasting package instead.
Is my data confidential?
Yes. Used only for your project, never shared or reused, and deleted on request after delivery.
2 reviews for this Gig
| (2) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
O 
oarabilemokgala

South Africa
Thanks for being available when i needed help. You are very good communicator and polite
$50
Price
2 days
Duration
Helpful?V vinceplayerr

Netherlands
Tarif un peu élévé mais travail rigoureux et complet
$100-$200
Price
5 days
Duration
Helpful?
2 reviews for this Gig
| (2) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
O 
oarabilemokgala

South Africa
Thanks for being available when i needed help. You are very good communicator and polite
$50
Price
2 days
Duration
Helpful?V vinceplayerr

Netherlands
Tarif un peu élévé mais travail rigoureux et complet
$100-$200
Price
5 days
Duration
Helpful?
