Retail Inventory And Demand Forecasting

SQL Server | Power BI | Inventory Analysis | Demand Forecasting

Project Overview

This project analyze retail inventory and demand across sales performance, inventory availability, stock shortages and demand patterns.

The analysis explores the relationships between actual sales, expected demand, inventory levels, restocking.

The analysis shows (+7M) units sold, (+375M $) net revenue (85%) fill rate, (11K) inventory turnover and (11.75%) demand variability.

For full discription include (Executive Summary - Business Problem - Skills And Methodology - Results - Strategic Recommendations - Next Steps)

Please check my Readme Page GitHub

SQL Server • Power BI • DAX • Power Querey • Data Clinging

Interactive Power BI Dashboard

Power BI Dashboard

Interactive embedding will be added after the public Power BI publishing setup is completed.

Project Screenshots

Explore the inventory dashboard pages, performance analysis, calendar, data modeling and SQL views. Select any image to open the original screenshot in a new tab.

Inventory Overview
01 — Overview
Product Inventory Demand
02 — Product Inventory Demand
Product Sales Demand
03 — Product Sales Demand
Product Competitor Price
04 — Product Competitor Price
Performance Normal
05 — Performance (Normal)
Performance Risk
06 — Performance (Risk)
Calendar Date
07 — Calendar Date
Data Modeling
08 — Data Modeling
View Created 1
09 — View Created 1

Project Walkthrough

Watch the project walkthrough to explore the inventory data, demand analysis, and key dashboard insights.

← Back to Portfolio