2 min readfrom Machine Learning

[D] Building a demand forecasting system for multi-location retail with no POS integration, architecture feedback wanted

We’re building a lightweight demand forecasting engine on top of manually entered operational data. No POS integration, no external feeds. Deliberately constrained by design.

The setup: operators log 4 to 5 signals daily (revenue, covers, waste, category mix, contextual flags like weather or local events). The engine outputs a weekly forward-looking directive. What to expect, what to prep, what to order. With a stated confidence level.

Current architecture thinking:

Days 1 to 30: statistical baseline only (day-of-week decomposition + trend). No ML.

Day 30+: light global model across entities (similar venues train together, predict individually)

Outlier flagging before training, not after. Corrupted signal days excluded from the model entirely.

Confidence scoring surfaced to the end user, not hidden.

Three specific questions:

  1. Global vs local model at small N With under 10 venues and under 90 days of history per venue, is a global model (train on all, predict per entity) actually better than fitting a local statistical model per venue? Intuition says global wins due to shared day-of-week patterns, but unclear at this data volume.
  2. Outlier handling in sparse series Best practice for flagging and excluding anomalous days before training, especially when you can’t distinguish a real demand spike from a data entry error without external validation. Do you model outliers explicitly or mask and interpolate?
  3. Confidence intervals that operators will trust Looking for a lightweight implementation that produces calibrated prediction intervals on short tabular time series. Considering conformal prediction or quantile regression. Open to alternatives.

Context: output is consumed by non-technical operators. Confidence needs to be interpretable as “high confidence” vs “low confidence”, not a probability distribution.

submitted by /u/Automation_storm
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#real-time data collaboration
#big data management in spreadsheets
#conversational data analysis
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#real-time collaboration
#rows.com
#spreadsheet API integration
#enterprise-level spreadsheet solutions
#Excel alternatives
#demand forecasting
#global model