The client wanted to predict, week-over-week, where revenue would be 10-weeks out. Our analysts determined the delta between revenue and guided revenue. If the delta was above the set threshold, our automated business rules identified the product line causing the impact down to the regional level so immediate action could be taken.
This solution was built using an R script for predictive forecasting and visualized via Tableau dashboard. The two most critical quality metrics were RMSE and AIC. The analysts trained the business on these metrics and explained how Tableau’s forecasting functionality worked in conjunction with statistical modeling.
Tools Used: R statistical modeling, Tableau