关于此课程： With marketers are poised to be the largest users of data within the organization, there is a need to make sense of the variety of consumer data that the organization collects. Surveys, transaction histories and billing records can all provide insight into consumers’ future behavior, provided that they are interpreted correctly. In Introduction to Marketing Analytics, we introduce the tools that learners will need to convert raw data into marketing insights. The included exercises are conducted using Microsoft Excel, ensuring that learners will have the tools they need to extract information from the data available to them. The course provides learners with exposure to essential tools including exploratory data analysis, as well as regression methods that can be used to investigate the impact of marketing activity on aggregate data (e.g., sales) and on individual-level choice data (e.g., brand choices). To successfully complete the assignments in this course, you will require Microsoft Excel. If you do not have Excel, you can download a free 30-day trial here: https://products.office.com/en-us/try
此课程适用人群： This course is aimed at those familiar with business and marketing concepts or those currently working in a business analyst or marketing research role.
教学方： David Schweidel, Associate Professor of Marketing
Goizueta Business School
| 基本信息 | 课程 1（共 6 门，Foundations of Marketing Analytics Specialization ） |
| 级别 | Intermediate |
| 承诺学习时间 | 5 weeks of study, 2-3 hours/week |
| 语言 | English |
| 如何通过 | 通过所有计分作业以完成课程。 |
| 用户评分 |
- 阅读: Getting Started
- 阅读: A Note About Exercises & Quizzes
- 讨论提示: Introduce Yourself
- 视频: Course Goals & Example 2: Performing Arts Centers
- 视频: Organizing Data
- 视频: The Motion Picture Industry
- 阅读: How Companies Learn Your Secrets
- 阅读: Big Data in the Big Apple
- 讨论提示: Categorical Variables in the Motion Picture Industry
- 阅读: Motion Picture Industry Example Data Set
- 视频: Displaying Conditional Distributions
- 视频: Analyzing Qualitative Variables
- 视频: Steps in Constructing Histograms
- 视频: Common Descriptive Statistics for Quantitative Data
- 阅读: Giving Viewers What They Want
- 阅读: Why Personalization is Key for Content Marketing
- 阅读: Assignment: Survey Analysis Assignment
- 讨论提示: Visualizing Data: Technique Review
- 视频: Introduction to Customer Analytics
- 视频: Customer Choices Drive Business Decisions
- 视频: Illustrating Customer Analytics in Excel
- 阅读: How to Find Your Most Valuable Customers
- 阅读: Assignment: Customer Acquisition Example
- 讨论提示: Logit v. Probit Models
- 视频: Inventory Management Excel Demonstration
- 阅读: Encouraging TV Binge Watching May Backfire On Advertisers
- 阅读: Use Big Data to Create Value for Customers, Not Just Target Them
- 阅读: Assignment: Using Regression for Inventory Management
- 讨论提示: Course Reflection
每门课程都像是一本互动的教科书，具有预先录制的视频、测验和项目。
与其他成千上万的学生相联系，对想法进行辩论，讨论课程材料，并寻求帮助来掌握概念。
获得正式认证的作业，并与朋友、同事和雇主分享您的成功。
| 购买课程 | |
|---|---|
| 访问课程材料 | 可用 |
| 访问评分的材料 | 可用 |
| 收到最终成绩 | 可用 |
| 获得可共享的课程证书 | 可用 |
This course went in depth into some excel functions used for analyzing sales and marketing data, really thought it was useful.
This course provided practical hands-on approach to understanding basics of marketing forecasting.
I would have liked more discussion of theory behind what the formulas were and, actually, using slicers for data so that clients couldn't "break" the file unintentionally. Otherwise, it was a good basic course, a little too dependent on showing Excel rather than saying why something worked (IF clauses are a good example here, cutting and pasting formulas is not as helpful to my personal learning style as just explaining the rationale behind them.)
The last 2 video lectures: Customer Valuation Excel Demonstration and Inventory Management Excel Demonstrationm were very well explained and taught me something new and useful.