Marketing Analytics: Forecasting Models with Excel

Marketing Analytics: Forecasting Models with Excel

What you’ll learn

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