Marketing Analytics: Forecasting Models with Excel

1. Become proficient in using powerful tools such as excel solver to create forecasting models
2. Learn about two of the most used forecasting tools: simple linear and simple multiple regression
3. Learn how to estimate the trend and seasonal aspects of sales
4. Learn to generate forecasts using the Ratio to Moving Average forecasting method
5. Forecast using dynamic trend and seasonal index using Winter’s method
6. Learn forecasting for new product launch with little or no history about sales of a product
7. Learn how to use S Curves to Forecast Sales of a New Product
8. Learn how to forecast product sales even before the product comes to market using popular the Bass diffusion model
9. Indepth knowledge of data collection and data preprocessing for Linear Regression problem
10. Understand how to interpret the result of Linear Regression model and translate them into actionable insight