About this course: How will customers act in the future? What will demand for our products and services be? How much inventory should we order for the next season? Beyond simply forecasting what customers will do, marketers need to understand how their actions can shape future behavior. In Developing Forecasting Tools with Excel, learners will develop an understanding of the basic components of a forecasting model, how to build their own forecasting models, and how to evaluate the performance of forecasting models. All of this is done using Microsoft Excel, ensuring that learners can take their skills and apply them to their own business problems.
Who is this class for: Prerequisites: It is recommended that you complete the "Meaningful Marketing Insights" and "Managing Uncertainty in Marketing Analytics" courses offered by Coursera before starting this course. Learners should have the ability to extract information from the data available and make meaningful insights, understanding of regression methods, and basic knowledge of Microsoft Excel.
Created by: Emory University
Taught by: David Schweidel, Associate Professor of Marketing
Goizueta Business School
| Basic Info |
Course 3 of 6 in the
Foundations of Marketing Analytics Specialization.
|
| Level | Intermediate |
| Language | English |
| How To Pass | Pass all graded assignments to complete the course. |
| User Ratings |
Syllabus
WEEK 1
Basics of Forecasting Models
This module will discuss how to identify the necessary components of a forecasting model based on patterns in the history data. You will also be able to evaluate the performance of a forecasting model using both in-sample and out-of-sample metrics.
4 videos, 3 readings
Graded: Module 1
WEEK 2
Customer Analytics: Predicting Individual Customer Behavior
"Meaningful Marketing Insights," This content will be familiar for learners who completed the first course; please think of this portion of the class as a review.
6 videos, 5 readings
Graded: Module 2
WEEK 3
Managing Customer Equity: Linking Customer Analytics to Customer Value
This module will discuss managing customer equity, acquisition, retention, & market value, and customer valuation. You will learn how to decompose customer value into its underlying components.
4 videos, 2 readings
WEEK 4
Marketing Mix Modeling
A common task in developing forecasting models is to use them to make decisions regarding the marketing mix activity. With a marketing mix model, organizations can assess the efficacy of different marketing actions. Included is a sample of data for a popular f...
4 readings
Graded: Conducting Exploratory Analysis Quiz
Graded: Building a Marketing Mix Model Quiz
Graded: Marketing Mix Model Peer Assessment
FAQs
How It Works
Coursework
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Help from Your Peers
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Certificates
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
Creators
Emory University
Emory University, located in Atlanta, Georgia, is one of the world's leading research universities. Its mission is to create, preserve, teach and apply knowledge in the service of humanity.
Pricing
| Audit | Purchase Course | |
|---|---|---|
| Access to course materials | Available | Available |
| Access to graded materials | Not available | Available |
| Receive a final grade | Not available | Available |
| Earn a shareable Course Certificate | Not available | Available |
Ratings and Reviews
Great insight into Sales forecasting. I liked it
Coursera provides universal access to the world’s best education, partnering with top universities and organizations to offer courses online.
© 2017 Coursera Inc. All rights reserved.
JC
Excelente =)