inventory-analysis

Automated management reporting solution that streamlines sales reporting, inventory monitoring and operational KPI tracking using Excel.

SQL analysis of Zepto's product inventory (3,732 rows) — pricing, stock & category insights using MySQL.

Retail analytics and BA portfolio project using SQL Server, Power BI, Jira, Confluence, and Draw.io to analyze sales, profitability, store performance, and inventory risk.

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.

Operational supply chain analytics project using SQL and Python to analyze demand trends, procurement activity, delivery performance, inventory classification, and operational KPIs.

Find the best Cardmarket sellers for your Magic: The Gathering buylist. Cardmarket Seller Finder analyzes carts, seller inventories, prices, shipping, and seller reliability to help MTG buyers optimize purchases faster

End-to-end SQL and Power BI project analysing product performance, inventory demand, customer segmentation, geographic markets and historical customer lifetime value, with interactive dashboards and acquisition investment scenarios to support data-driven business decisions.

SQL-based business analytics project using Google BigQuery on the AdventureWorks2019 dataset, delivering insights across Sales, Production, and Purchasing, including YoY growth, territory ranking, customer retention, inventory trends, and stock efficiency.

End-to-end retail analytics project analyzing sales performance, inventory health, and product profitability using Python and Power BI.

SQL analysis of Zepto's product catalogue — data cleaning, exploration & business insights using PostgreSQL.

SQL-based analysis of Zepto e-commerce inventory data using PostgreSQL, covering data cleaning, pricing, discounts, inventory and revenue insights.

End-to-End Supply Chain Analytics Dashboard using SQL, Python, and Power BI. Analyzed inventory, supplier performance, logistics costs, shipping efficiency, and profitability KPIs through interactive business intelligence dashboards.

SKU-level profitability and payback model across 74 assets and 3 years. Power BI, DAX, Power Query.

OReillyAuto product data scraper

End-to-end inventory analysis project using PostgreSQL, SQL data cleaning, analytics modeling, and Power BI dashboard to identify overstock, stock risk, and inventory inefficiencies.

SQL-based inventory and sales analysis project on Zepto product data

Inventory analysis case study for WarmeHands Inc. — Revenue, COGS, Profit, ABC Analysis, and Inventory Turnover dashboards built in Power BI. DataCamp certified.

End-to-end analysis of retail vendor performance using Python to identify profitability, optimize procurement, and improve inventory efficiency.

End-to-end SQL and Power BI analytics project for revenue, pricing, inventory allocation, and ROI decision support using the Sakila DVD rental database.

SQL-based acquisition due diligence case study analyzing revenue stability, inventory capital risk, and customer lifetime value in a two-store retail business.