I want to forecast future(next 20 days) sales with sample dataset.
This is just a sample data and the actual data is from Jan 2014 to Dec 2016. As you can see, sales tend to increase as time goes by, and usually it gets higher when variable(c) is 'no'.
Time series forecasting cases that were posted on Stackoverflow or other Websites were either univariate time series or multivariate time series without categorical variables. I definitely don't want to ignore the variable(c) in this case.
I tried to use Random forest and XGBOOST but the result was really bad. It is because those decision-tree based models don't work well for extrapolation analysis. I am pretty sure regression based model will work well for this case but linear regression can't read the categorical variable and also, it won't capture the seasonality and weekdays trend.
To sum up, it would be great if you can recommend me a good future forecasting model that satisfies those 3 things:
- Captures the sales increasing trend
- Captures the seasonality and weekdays trend
- Treats not only numerical variables but also categorical variables