Marketing Analytics: Forecasting Models with Excel

سرفصل های دوره

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

01 - Introduction

001 00-INtro.pdf

001 Introduction

02 - Basics of Forecasting

001 01-reg-basics.pdf

001 Basics of Forecasting

002 Course Resources.html

002 Marketing-Analytics-Forecasting-Models-with-Excel.zip

003 This is a milestone!

004 Creating Linear Model with Trendlines

03 - Getting Data Ready for Regression Model

001 03-01-PDE-Business-knowledge.pdf

001 Gathering Business Knowledge

002 Data Exploration

003 03-03-PDE-Raw-Data-Analysis-Uni.pdf

003 The Data and the Data Dictionary

004 03-04-PDE-Univariate-Analysis-Uni.pdf

004 04-House-Price.xlsx

004 Univariate analysis and EDD

005 05-Outlier.xlsx

005 Discriptive Data Analytics in Excel

006 Outlier Treatment

007 05-Outlier.xlsx

007 Identifying and Treating Outliers in Excel

008 Missing Value Imputation

009 05-Miss-val.xlsx

009 Identifying and Treating missing values in Excel

010 07-Dummy-variable.xlsx

010 Variable Transformation in Excel

011 04-11-Dummy-Var.pdf

011 Dummy variable creation Handling qualitative data

012 07-Dummy-variable.xlsx

012 Dummy Variable Creation in Excel

013 04-10-Correlation.pdf

013 Correlation Analysis

014 08-corr.xlsx

014 Creating Correlation Matrix in Excel

04 - Forecasting using Regression Model

001 05-01-Intro.pdf

001 The Problem Statement

002 05-02-Simple-lin-reg.pdf

002 Basic Equations and Ordinary Least Squares (OLS) method

003 05-03-Simple-lin-reg-Accuracy.pdf

003 Assessing accuracy of predicted coefficients

004 05-03-Simple-lin-reg-Accuracy.pdf

004 Assessing Model Accuracy RSE and R squared

005 Creating Simple Linear Regression model

006 05-04-Multiple-lin-reg.pdf

006 Multiple Linear Regression

007 05-05-F-stat.pdf

007 The F - statistic

008 05-06-Cat-var.pdf

008 Interpreting results of Categorical variables

009 09-multiple.xlsx

009 Creating Multiple Linear Regression model

05 - Handling Special events like Holiday sales

001 11-Special-Events.pdf

001 Forecasting in presence of special events

002 11-Solver-reg.xlsx

002 Excel Running Linear Regression using Solver

003 12-SpecialEvents.xlsx

003 Excel Including the impact of Special Events

06 - Identifying Seasonality & Trend for Forecasting

001 12-Seasonality.pdf

001 Models to identify Trend & Seasonality

002 13-Seasonality.xlsx

002 Excel Additive model to identify Trend & Seasonality

003 Excel Multiplicative model to identify Trend & Seasonality

004 14-Moving-Average.pdf

004 14-Moving-Avg.xlsx

004 Moving Average Method

005 14-Moving-Avg.xlsx

005 Excel Moving Average Method

07 - Handling Changing Trend & Seasonality over time

001 15-Winters.pdf

001 Winters Method to accomodate changing Trend & Seasonality

002 15-winter.xlsx

002 Excel Winters method

08 - Forecasting models for New Products

001 16-S-Model.pdf

001 S-curve for New products

002 16-S-curve.xlsx

002 Excel Using Logistic curve to model S-curve

003 16-S-curve.xlsx

003 Excel Using Gompertz curve to model S-curve

004 17-bass.pdf

004 Bass Diffusion Model for New Products

005 17-Bass.xlsx

005 Excel Implementing Bass Diffusion Model

09 - Appendix 1 Excel crash course

001 Important Excel Functions - Sum, Average, Concatenate, Trim

002 Important Excel Functions- Vlookup, If, Count If, Sum if

003 Data-Tools-1.xlsx

003 Sorting, Filtering and Data Validation

004 Data-Tools.xlsx

004 Text-to-columns and remove duplicates

005 Advanced Filter option

005 Advanced-Filters.xlsx

005 Advanced-Filters-solved.xlsx

006 Pivot tables

007 Popular Excel charts.html

10 - Bonus Section

001 The final milestone!

002 Bonus Lecture.html

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy