Implemented supply chain management scripting to optimize inventory classification and supplier management processes through the use of ABC segmentation and Kraljic Matrix.

Scripts and Notebooks used for the tutorial

Start with this folder to follow the tutorial: https://youtu.be/oJzNnHIusZs

The original dataset is a year's worth of electronics sales transactions. It has around 185K records and 11 attributes. Business Objective: Identify the products which generated 80% of profit.

🏢 End-to-end Inventory Data Analysis project covering Demand Forecasting, ABC Analysis, EOQ, Inventory Turnover, Lead Time, and Carrying Cost Optimization.

University project provided by Alkemy. Market analysis and strategic consultancy for a possible client in the retail sector.

Unlock smarter inventory decisions by combining Generative AI and MongoDB Atlas Vector Search.

Warehouse picking performance analysis using SQL: storeman KPIs, rack zone efficiency, and ABC (Pareto) item classification

Цей проєкт демонструє комплексний аналіз продажів міжнародної компанії, яка працює на глобальному ринку через онлайн та офлайн канали. Основна мета — отримати практичні інсайти, визначити ключові фактори прибутковості та підтримати прийняття бізнес-рішень на основі даних.

End-to-end Retail Sales & Inventory Analytics project using SQL, Python, and Power BI featuring RFM segmentation, ABC inventory analysis, sales forecasting, and interactive dashboards.

供应链库存管理分析：基于Superstore数据集的ABC分类、EOQ、安全库存与再订货点策略

Warehouse analytics for state excise depots. Reads a stock spreadsheet in the browser and returns KPIs, a storage plan and ranked actions. No upload, no server, no account.

Power BI inventory & warehouse analytics — stock value, turnover, ABC classification and dead-stock analysis for a paint distributor. Built with Power Query & DAX.

Real-Time Pharmacy Inventory Management System using MySQL and Excel | Data Analytics Project

Experimental retail analytics workspace with deterministic ABC-XYZ recommendations and grounded LLM narratives.

End-to-end supply chain analysis identifying £351K revenue at stockout risk across 100 FMCG SKUs using Python, pandas, and matplotlib.

End-to-end sales analysis of a retail superstore dataset using Excel, covering data cleaning, EDA, business insights, customer segmentation (RFM), and dashboard visualization.

Аналіз продажів компанії, виконаний у Google Sheets. Містить зведені таблиці, АВС-аналіз та фінальний звіт.

Combined ABC-XYZ product segmentation

Sales analytics project | MySQL · Power BI | Contribution margin ranking & ABC analysis for a textile retail assortment (98 SKUs)