Skip to content
All projects
  • Data Science
  • Machine Learning / AI
  • Business Intelligence

AI Sales & Inventory Advisor

Forecast product demand and catch inventory shortages before they happen.

An inventory analytics application that uses historical sales data and forecasting models to estimate product demand and flag potential inventory shortages.

  • Python
  • Pandas
  • NeuralProphet
  • Dash

01

Project overview

What it does
A forecasting dashboard that projects product demand from sales history and highlights where stock is likely to run short.
Why I built it
Stockouts lose sales and overstock ties up cash. A forecast tied to current inventory turns a spreadsheet into an early-warning system.
What it solves
Reordering based on last month's numbers misses seasonality and trend.
Who it's for
Retail and e-commerce operators managing replenishment.

02

The problem

Teams often reorder by habit or from last period's totals, which misses trend and seasonality and leads to stockouts on the products that matter most.

03

The solution

Historical sales are cleaned and aggregated with Pandas, NeuralProphet models forecast demand per product, and forecasts are compared with inventory levels to flag likely shortages. Results are presented in an interactive Dash dashboard.

04

Architecture & workflow

  1. STEP 01

    Sales history

    Historical transactions

  2. STEP 02

    Prep

    Clean and aggregate

    • Pandas
  3. STEP 03

    Forecast

    Per-product demand

    • NeuralProphet
  4. STEP 04

    Shortage check

    Forecast vs. inventory

  5. STEP 05

    Dashboard

    Interactive views

    • Dash
Data flow · source to decision

05

Technology stack

Languages

  • Python

Data Engineering

  • Pandas

Machine Learning

  • NeuralProphet

Visualization

  • Dash

06

Project demonstration

Forecasting demand and spotting a shortage.

07

Key features

Demand forecasts

Product-level forecasts that capture trend and seasonality.

Shortage alerts

Flags products whose forecast demand outpaces inventory.

Interactive dashboard

Explore products and forecasts in Dash.