inventory-analytics

Built an interactive Excel-based inventory dashboard using PivotTables, charts, slicers, and conditional formatting to monitor stock levels, reorder status, and supplier-wise performance across warehouses. Enabled 30% faster analysis and reporting through real-time, data-driven visualizations for supply chain decisions.

AI-powered Retail Intelligence & Demand Forecasting Platform. Predicts 30-day unit sales velocity, stockout risks, and capital-locked inventory using XGBoost & Machine Learning.

End-to-end E-Commerce Sales, Inventory & Business Analytics platform using Python, Pandas, SQL, MySQL, Pytest, Matplotlib & GitHub Actions.

Supply Chain & Inventory Analytics — pipeline end-to-end (40 SKUs, 5 WH, 8 suppliers): turnover, DIO, stockout, lead time & Inventory Health Score. Streamlit + Plotly. No ML.

Visualizing retail revenue, customer segmentation, and seasonal trends through SQL-driven analysis and Tableau.

Heavy Warehouse Intelligence — CadetX Virtual Work Experience (team of 3): 12-sprint analytics framework on a heavy-equipment spare-parts supply chain — 6 branches, 30 SKUs, 8 suppliers, 500 customers, 2019–2024; KPI framework, data-quality report, notebooks, Excel control book.

Retail demand and inventory analytics pipeline using Python, SQL, DuckDB, and pandas, with replenishment scenarios, automated tests, and Power BI-ready reporting datasets.

Retail inventory analytics · Python → PostgreSQL · 3,732 Zepto SKUs · 14 SQL queries · stock health & revenue insights

Senior/Lead Power BI control-tower case study for inventory decisions, governed metrics, reliability, and operating model.

Standalone, runnable reconstruction of a production inventory-intelligence pipeline — demand classification, IQR outlier cleaning, inventory turnover & aging-stock analytics — on synthetic data. Python · DuckDB · pandas · Streamlit.

Inventory management and dead stock risk prediction system using Python, MariaDB, Pandas, Matplotlib, and Tkinter.

Production-style pharmacy category management analytics portfolio using SQL Server, Python, Power BI/DAX, inventory, supplier, assortment and commercial analytics.

Pharmacy inventory analytics portfolio covering stock value, expiry risk, dead stock, slow-moving items, reorder candidates, SQL analysis, and an interactive dashboard.

Inventory planning decision studio: forecast bake-offs, replenishment, ABC-XYZ policy, transfer economics, working capital, governed actions, Power BI and a reviewable BA case.