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.
Forecasting Models for Marketing Decisions
This course is part of Foundations of Marketing Analytics Specialization
Instructor: David Schweidel
Sponsored by Louisiana Workforce Commission
17,837 already enrolled
(78 reviews)
Skills you'll gain
Details to know
Add to your LinkedIn profile
4 assignments
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review
There are 4 modules in this course
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.
What's included
4 videos3 readings1 assignment
"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.
What's included
6 videos5 readings1 assignment
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.
What's included
4 videos2 readings1 discussion prompt
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 frozen food category. In addition to weekly sales and pricing, for the focal brand we have information on whether the product was featured in the store’s advertising (e.g., newspaper circular) and if the product was on display in the store. We also have pricing information from competitors. In this module, we will build a series of regression models to evaluate the impact of the brand’s actions and competitors’ actions.
What's included
4 readings2 assignments1 peer review1 discussion prompt
Instructor
Offered by
Why people choose Coursera for their career
Learner reviews
78 reviews
- 5 stars
60.25%
- 4 stars
25.64%
- 3 stars
8.97%
- 2 stars
1.28%
- 1 star
3.84%
Showing 3 of 78
Reviewed on Mar 30, 2020
Incredibly useful and practical. Professor Schweidel keeps a good pace, and each video is engaging. I have already put everything into practice at work!
Recommended if you're interested in Business
Macquarie University
University of Colorado System
University of Minnesota
O.P. Jindal Global University
Open new doors with Coursera Plus
Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 3,400 global companies that choose Coursera for Business
Upskill your employees to excel in the digital economy