AI-Powered Sales Forecasting System: Multi-Model Comparison and Business Scenario Simulation

This project is a Streamlit-based machine learning application that integrates 8 prediction models and intelligent scenario simulation functions, helping enterprises predict future trends using historical sales data and generate data-driven business insights. The system addresses the limitations of traditional sales forecasting that relies on linear extrapolation or empirical judgment, providing functions such as multi-model comparison, scenario simulation, and intelligent Q&A, covering the complete decision support process from data input to insight output.

In business decision-making, accurate sales trend forecasting is crucial for inventory management, production planning, and marketing strategies. Traditional forecasting methods rely on simple linear extrapolation or empirical judgment, making it difficult to capture complex patterns and seasonal changes in data. The AI-Sales-Forecasting-System project integrates multiple machine learning models and interactive tools, aiming to provide enterprises with a comprehensive sales forecasting solution.

The project is developed based on Python and Streamlit, including five core function modules: Data Upload and Preprocessing (supports CSV/Excel import, data cleaning, time granularity identification), Sales Data Analysis and Visualization (multi-dimensional insights, Plotly interactive charts), Prediction Model Comparison, Business Scenario Simulation, and Intelligent Q&A Robot. The technical architecture adopts a layered design: the app directory serves as the application entry and page modules, the services directory encapsulates business logic (prediction, evaluation, robot services, etc.), the data directory stores sample data, and the notebooks directory contains model experiment notebooks.

The system integrates 8 prediction models: Moving Average, Linear Trend, Seasonal Trend, Seasonal Naive Model, Exponential Smoothing, Holt Double Exponential Smoothing, Random Forest, and Intelligent Integration Model. The multi-model design is based on the understanding that 'no single model is suitable for all datasets', and the optimal model is automatically selected by comparing performance metrics (MAE, RMSE, MAPE, R²). The intelligent integration model dynamically adjusts weights, assigning higher weights to better-performing models based on validation set results, adapting to changes in data characteristics.

The scenario simulation module supports 'what-if' analysis, allowing users to adjust parameters such as growth rate, discount rate, and marketing impact coefficient to test business hypotheses and reduce decision-making risks. The intelligent Q&A robot can access uploaded data to answer questions such as sales overview, product category performance, regional sales distribution, and future forecasts. It supports integration with the Google Gemini API to generate natural language explanations (requires users to configure the API key).

Model performance is evaluated using MAE, RMSE, MAPE, and R². On the sample dataset, the Exponential Smoothing model has a MAPE of 7.29% (accuracy rate of 92.71%). The application value of the project includes optimizing inventory levels, formulating production plans, allocating marketing budgets, and setting sales targets, enabling small and medium-sized enterprises to also benefit from machine learning. From an industry perspective, the project demonstrates the deep integration of AI with business scenarios and promotes technology democratization.

Project improvement directions: Introduce deep learning models such as LSTM and Transformer to handle complex time-series patterns; add automated report generation functions; integrate external data sources such as weather, holidays, and competitor prices; develop API interfaces for other systems to call prediction services. These improvements will further enhance the system's functionality and applicability.