À propos de ce cours : 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
Les destinataires de ce cours : This course is aimed at those familiar with business and marketing concepts or those currently working in a business analyst or marketing research role.
Enseigné par : David Schweidel, Associate Professor of Marketing
Goizueta Business School
| Informations de base | Cours 1 de 6 dans Foundations of Marketing Analytics Specialization |
| Niveau | Intermediate |
| Engagement | 5 weeks of study, 2-3 hours/week |
| Langue | English |
| Comment réussir | Réussissez tous les devoirs notés pour terminer le cours. |
| Notes des utilisateurs |
- Vidéo: Meet Dr. Schweidel
- Lecture: Getting Started
- Lecture: A Note About Exercises & Quizzes
- Demande de discussion: Introduce Yourself
- Vidéo: Course Objectives & Example 1: Political Advertising Expenditures
- Vidéo: Course Goals & Example 2: Performing Arts Centers
- Vidéo: Organizing Data
- Vidéo: The Motion Picture Industry
- Lecture: How Companies Learn Your Secrets
- Lecture: Big Data in the Big Apple
- Demande de discussion: Categorical Variables in the Motion Picture Industry
- Lecture: Motion Picture Industry Example Data Set
- Vidéo: Excel Analysis of Motion Picture Industry Data
- Vidéo: Displaying Conditional Distributions
- Vidéo: Analyzing Qualitative Variables
- Vidéo: Steps in Constructing Histograms
- Vidéo: Common Descriptive Statistics for Quantitative Data
- Lecture: Giving Viewers What They Want
- Lecture: Why Personalization is Key for Content Marketing
- Lecture: Assignment: Survey Analysis Assignment
- Demande de discussion: Visualizing Data: Technique Review
- Vidéo: Regression-Based Modeling
- Vidéo: Introduction to Customer Analytics
- Vidéo: Customer Choices Drive Business Decisions
- Vidéo: Illustrating Customer Analytics in Excel
- Lecture: How to Find Your Most Valuable Customers
- Lecture: Assignment: Customer Acquisition Example
- Demande de discussion: Logit v. Probit Models
- Vidéo: Customer Valuation Excel Demonstration
- Vidéo: Inventory Management Excel Demonstration
- Lecture: Encouraging TV Binge Watching May Backfire On Advertisers
- Lecture: Use Big Data to Create Value for Customers, Not Just Target Them
- Lecture: Assignment: Using Regression for Inventory Management
- Demande de discussion: Course Reflection
Chaque cours fonctionne comme un manuel interactif en proposant des vidéos préenregistrées, des quiz et des projets.
Connectez-vous à des milliers d'autres étudiants et débattez sur des idées, discutez le contenu du cours et obtenez de l'aide pour en maîtriser les concepts.
Obtenez une reconnaissance officielle pour votre travail et partagez votre réussite avec vos amis, vos collègues et vos employeurs.
| Acheter le cours | |
|---|---|
| Accéder au contenu du cours | Disponible |
| Accéder au contenu noté | Disponible |
| Recevoir une Note Finale | Disponible |
| Obtenir un Certificat de Cours partageable | Disponible |
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.