Marketing Analytics: Forecasting Models with Excel

Master Marketing Analytics| Forecasting and Time Series analysis | Sales Forecasting| Build Forecasting models in Excel

Created by: Start-Tech Academy
5,000,000+ Enrollments | 4.5 Rated | 160+ Countries

What Will I 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

Target audience

• Anyone curious to master Forecasting Models from beginner to advanced