Problem
Marketing managers relied on static CSVs and aggregated monthly data that made granular ROAS calculation impossible. Traditional forecasting models like ARIMA and XGBoost yielded high error rates (MAPE > 40%), failing to provide the predictive depth needed for proactive budget allocation.
Solution
Developed a containerized architecture utilizing Meta's Prophet for time-series forecasting and a multi-LLM pipeline (Llama 3, Llama 4 Maverick, and DeepSeek-R1) to automate report generation. The system features automated hyperparameter tuning via Optuna and an Nginx-routed microservices backend to handle concurrent analytical workloads.
Achievements
- Achieved ≤ 15% MAPE for revenue forecasting, significantly outperforming ARIMA (42.3%) and XGBoost (49.8%)
- 91.7% success rate in query classification across description, report, and chart tasks
- Sub-second classification latency (0.71s) for real-time user query processing
- Optimized 25 engineered features down to 7 key predictors using VIF to eliminate multicollinearity and improve model stability













