Course Highlights
  • 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
Curriculum

1 Topic
Introduction

4 Topics
Basics of Forecasting
Course Resources
This is a milestone!
Creating Linear Model with Trendlines

15 Topics
Gathering Business Knowledge
Data Exploration
The Data and the Data Dictionary
Univariate analysis and EDD
Discriptive Data Analytics in Excel
Outlier Treatment
Identifying and Treating Outliers in Excel
Missing Value Imputation
Identifying and Treating missing values in Excel
Variable Transformation in Excel
Dummy variable creation: Handling qualitative data
Dummy Variable Creation in Excel
Correlation Analysis
Creating Correlation Matrix in Excel
Quiz

10 Topics
The Problem Statement
Basic Equations and Ordinary Least Squares (OLS) method
Assessing accuracy of predicted coefficients
Assessing Model Accuracy: RSE and R squared
Creating Simple Linear Regression model
Multiple Linear Regression
The F - statistic
Interpreting results of Categorical variables
Creating Multiple Linear Regression model
Assignment 1: Regression based Forecasting

3 Topics
Forecasting in presence of special events
Excel: Running Linear Regression using Solver
Excel: Including the impact of Special Events

8 Topics
Models to identify Trend & Seasonality
Quiz
Excel: Additive model to identify Trend & Seasonality
Excel: Multiplicative model to identify Trend & Seasonality
Moving Average Method
Quiz
Excel: Moving Average Method
Assignment 2: Identifying Trend and Seasonality

3 Topics
Winter's Method to accomodate changing Trend & Seasonality
Excel: Winter's method
Quiz

7 Topics
S-curve for New products
Excel: Using Logistic curve to model S-curve
Excel: Using Gompertz curve to model S-curve
Bass Diffusion Model for New Products
Excel: Implementing Bass Diffusion Model
Final Course Quiz
Assignment 3: Bass Model

8 Topics
Important Excel Functions - Sum Average Concatenate Trim
Important Excel Functions- Vlookup If Count If Sum if
Sorting Filtering and Data Validation
Text-to-columns and remove duplicates
Advanced Filter option
Quiz
Pivot tables
Popular Excel charts

2 Topics
The final milestone!
Bonus Lecture

  Write a Review

Marketing Analytics: Forecasting Models with Excel

Go to Paid Course