关于此课程： 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.
此课程适用人群： 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.
制作方： 艾莫利大学
教学方： David Schweidel, Associate Professor of Marketing
Goizueta Business School
| 基本信息 | 课程 3（共 6 门，Foundations of Marketing Analytics Specialization ） |
| 级别 | 中级 |
| 语言 | English |
| 如何通过 | 通过所有计分作业以完成课程。 |
| 用户评分 |
授课大纲
第 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 个视频, 3 个阅读材料
- Reading: Simple Forecasting Model Assignment
- 视频: Regression - Based Modeling
- 视频: Examining the Residuals
- 视频: Assessing Forecasting Performance
- Reading: A Predictive Analytics Primer
- Reading: Nowcasting: A Model for the Future of Marketing
已评分: Module 1
第 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 个视频, 5 个阅读材料
- Reading: Read This First
- 视频: Business Decisions Drive Customer Choices
- 视频: Illustrating Customer Acquisition in Excel
- 视频: Timing Models in Marketing
- Reading: Leveraging Customer Analytics: The Insurance Industry
- Reading: Companies still struggle to unlock customer data analytics insight
- Reading: Retention Exercise Instructions
- 视频: Model for Retention Excel Demonstration
- Reading: Kiwi Bubbles Instructions
- 视频: Kiwi Bubbles Exercise Excel Demonstration
已评分: Module 2
第 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 个视频, 2 个阅读材料
- 视频: Acquisition, Retention, & Market Value
- 视频: Customer Valuation
- 视频: Marketing to New & Current Customers
- Reading: What You Should Know About Customer Success Technology
- Reading: Online Communities Foster Customer Loyalty
- Discussion Prompt: Social Networking and Customer Valuation
第 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 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.
4 个阅读材料
- Reading: Marketing Mix Modeling
- Reading: Instructions for Exercise
- Discussion Prompt: Discussion Question
- Reading: Instructions for Exercise
- Reading: Instructions for Exercise
已评分: Conducting Exploratory Analysis Quiz
已评分: Building a Marketing Mix Model Quiz
已评分: Marketing Mix Model Peer Assessment
常见问题解答
运作方式
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.
制作方
艾莫利大学
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.
价格
| 购买课程 | |
|---|---|
| 访问课程材料 | 可用 |
| 访问评分的材料 | 可用 |
| 收到最终成绩 | 可用 |
| 获得可共享的课程证书 | 可用 |
评分和审阅
Great insight into Sales forecasting. I liked it
JC
Excelente =)