Marketing Analytics: Forecasting Models with Excel.

Master Marketing Analytics| Forecasting and Time Series analysis | Sales Forecasting| Build Forecasting models in 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.

Requirements

You will need a PC with any version of Excel installed in it.
Basic understanding of Excel operations like opening, closing and saving a file.