DATA & DECISIONS / INVENTORY & BUSINESS INTELLIGENCE
Stock & Inventory Analytics.
An inventory analytics platform turning ERP exports into clearer stock decisions through KPI dashboards, explainable SKU scoring and management reports.
THE CONNECTIONS
Stock, sales and purchasing in one view.
- 01
Prepare ERP data
- 02
Validate & calculate KPIs
- 03
Score SKU health
- 04
Review actions & reports
Workflow illustration. Project scope and limitations are described below.
01 / THE BUSINESS CHALLENGE
Where the friction was.
Identify slow-moving, end-of-life and excess stock, then separate actionable findings from decisions that need business review or better data.
02 / THE CONNECTED SOLUTION
How the pieces connect.
A Python data pipeline standardizes ERP exports and checks the data required for each KPI. Explainable SKU scoring combines weighted stock-health dimensions with strategic and new-product rules. Interactive dashboards and Excel management packs help review replenishment priorities, dead stock and overstock while flagging missing or unreliable inputs.
Built with / focus areas
- Python
- pandas
- DuckDB
- Streamlit
- Plotly
YOUR NEXT CONNECTION
Facing a similar challenge?
Let’s connect the business problem to a practical solution.