Icon

To-Do - Stockout Monitoring

<p><strong>Inventory Stockout Monitoring</strong></p><p>This Data App helps businesses monitor monthly stockout trends for different item categories and across different warehouses. Effective stockout monitoring ensures consistent product availability, protects revenue, optimizes operations, and strengthens customer loyalty by enhancing convenience and trust.<strong><br></strong><br>The workflow processes fictitious stockout data about different item categories and across different warehouses in the US, for the years 2022 and 2023. Next, it visualizes the monthly stockout trend for selected warehouse locations in respective item categories and returns stockout predictions for the current month.</p>

URL: Discover more data apps https://www.knime.com/data-app-examples
URL: Avoid empty shelves with stockout analysis in KNIME https://www.knime.com/blog/avoid-empty-shelves-with-stockout-analysis

Predictor model
Model Reader
Highlight Widget
Stockouts line plot
Line Plot
Get aggregate for all towns for each month
GroupBy
lag previous months
Lag Column
Current Month prediction
Regression Predictor
Concatenate with actual data
Concatenate
Get unique set of locations
Duplicate Row Filter
Get towns as set in variable
Table Column to Variable
Abbreviate monthnames
Expression
Row Filter
Get set of all warehouses
GroupBy
Prediction for currentmonth
Text View
Filter on WarehouseSub-Location
Row Filter
GroupBy
Variable Expressions (legacy)
Space between plots
Text View
green message
Text View
Concatenate
Variable Expressions (legacy)
Extract Year and Month
Date&Time Part Extractor
yellow message
Text View
Read Stockoutdata
Excel Reader
Table Creator
Convert year to string
Number to String
Column Auto Type Cast
Number Rounder
Keep only current month
Row Filter
Rule Engine Variable
Color Manager
Lookup warehouselocation
Value Lookup
Header
Workflow Application Header
Add category "All"
Constant Value Column Appender
Select WHS-Category
Single Selection Widget
Select WHS-Location
Single Selection Widget
Split name of warehouse location
Cell Splitter
Stockouts by category
Bar Chart
Color Manager
Get set of available warehouse locations for selected city
Table Row to Variable
Selected data statistics
GroupBy
Group by on WarehouseLocation to createset
GroupBy
Table Row to Variable
selection
Text View
Pivot Table on Year
Pivot
CASE Switch Start
Column Appender
Stockout views
Text View
Column Filter

Nodes

Extensions

Links