# Stock & Inventory Analytics

Stock, sales and purchasing in one view.

- Author: [Konstantinos Toulis](https://ktoulis.com/#about)
- Role: Business Technology & AI Solutions Architect
- Category: Data & decisions
- Project type: Inventory & business intelligence
- Canonical page: https://ktoulis.com/work/inventory-analytics.html

## Overview

An inventory analytics platform turning ERP exports into clearer stock decisions through KPI dashboards, explainable SKU scoring and management reports.

## The business challenge

Identify slow-moving, end-of-life and excess stock, then separate actionable findings from decisions that need business review or better data.

## The connected solution

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.

## The workflow

1. Prepare ERP data
2. Validate & calculate KPIs
3. Score SKU health
4. Review actions & reports

The workflow is an illustration. Project scope and limitations are described below.

## Built with / focus areas

- Python
- pandas
- DuckDB
- Streamlit
- Plotly

## Focus

- Inventory intelligence
- Explainable SKU scoring
- Management reporting

## Scope and disclosure

Private business dashboard, presented as an anonymous case study.

## Contact

[Discuss a similar project by email](mailto:kt@ktoulis.com).

[All selected work](https://ktoulis.com/#work) · [Professional profile](https://ktoulis.com/index.md)