Python portfolio applied to Supply Chain & Operations: OTIF KPI, Inventory ABC/ROP, and report automation (Excel).

This dashboard was created at the request of the Trading House Director to provide a comprehensive view of business performance.

Interactive Excel logistics dashboard tracking OTIF, SLA compliance, delay trends and return rates across 200 shipments — revealing a 42.5% SLA breach rate and 235% increase in delays from January to July.

Creation a logistics and supply chain dashboard for OTIF Analysis

This project contains two PostgreSQL queries used to build widgets for an **OTIF (On-Time In-Full) dashboard**, which helps monitor supplier performance and delivery accuracy across clients and distribution centers.

[1] What if delays are not random - but predictable?

Análise de dados logísticos com o dataset DataCo Smart Supply Chain — OTIF, lead time e taxa de atraso por região, modal e categoria.

Dashboard Power BI para métricas OTIF (On-Time In-Full). Relatórios executivos e modelo semântico.

End-to-end supply-chain analytics control tower: SKU-level demand forecasting, safety stock & reorder optimization (OR-Tools), OTIF and vendor scorecards. Built with Airflow, dbt, DuckDB, and Streamlit.

📊 Analyze supply chain KPIs, manage inventory, and automate reporting using Python for data-driven operations and decision-making.