I have taught various marketing topics at undergraduate, MBA/EMBA/MS, and doctoral levels, at different institutions: C. T. Bauer College at the University of Houston (current), Krannert School of Management at Purdue University, and the Wharton School of the University of Pennsylvania.
Empirical Models (Ph.D.)
Digital Marketing
Marketing Management
Marketing Research
New Product Development
Pricing
Quantitative Analysis (EMBA, DBA)
International Marketing
Introduction to Marketing
Content of Introduction to Marketing (MARK 3336)
This course introduces students to the dynamic world of marketing, emphasizing customer-centric value creation through effective marketing strategies. Students should expect to gain an understanding of key areas, including market research, buyer behavior, strategic pricing, marketing channels, and various promotional and social media activities.
Week 1: Orientation and Introduction – The Marketing Process
Week 2: Marketing strategy / Marketing environment / Global Marketplace
Week 3: Understanding customers / Market metrics
Week 4: Exam 1
Week 5: Consumer markets / Business markets
Week 6: Segmentation, targeting, and positioning
Week 7: Creating customer value: Products, services, brands / Developing new products
Week 8: Exam 2
Week 9: Extracting customer value: Pricing
Week 10: Delivering customer value: Channel / Retailing and wholesaling
Week 11: Exam 3
Week 12: Communicating customer value: Advertising
Week 13: Personal selling and sales promotion / Competition
Week 14: Legal and ethnic issues in marketing
Week 15: Exam 4
Content of Marketing Analytics
This is a very hands-on course with many Excel examples. It requires a lot of work and demands weekly attention and studies. If you are looking for an easy course in marketing, this is not the course for you.
The designated analytics tool is Microsoft Excel 365, perhaps the most commonly used data processing software in the business world. The structure of the course is as follows:
Part 1: Marketing Metrics and Excel
Orientation
Course/Excel Introduction
Data
Advertising
Part 2: Customer Analytics
Customer Profiling
Targeting Customers
Customer Lifetime Value
Part 3: Four P's Analytics
Price (optimization)
Place (distribution and salesforce optimization)
Promotion (experiments)
Regression
Product (conjoint analysis)
Course Schedule (With Link to YouTube Video)
Week 1: Introduction/Excel Basics
Excel: Restaurant Profit Margin
Excel: Grades and Price
Excel: Travel Salesperson
Week 2: Data data everywhere
Excel: Music Chart COUNT
Excel: Sales Rep Records SUM
Excel: Grades Summary Histogram
Excel: Google Search Heat Map
Week 3: Does my advertising work?
Excel: Estimating Ad ROI
Excel: AdStock
Excel: Ad Expense by Media
Week 4: Customer Profiling
Excel: MLB Players 1900-
Excel: Drug store pie chart
Excel: Cash Reserve waterfall chart
Excel: Automaker bubble chart
Excel: Combo chart using Mac
Excel: Groceries pivot table
Excel: Travel expense pivot table
Excel: Minivan pivot table
Week 5: Targeting Customers
Excel: Collaborative Filtering
Week 6: Customer Lifetime Value (CLV)
Excel: CLV and retention rate
Excel: Using CLV for poaching
Week 7: Review
Week 8: Exam 1 (no video)
Week 9: Price optimization
Week 10: Place: distribution and salesforce optimization
Excel: Mapping retailers
Excel: Optimize warehouse locations
Excel: Traveling salesperson
Excel: Detailing call allocation
Week 11: Promotion and experiments
Excel: Generating random numbers
Excel: Why sample size matters
Excel: Analyzing campaign data
Week 12: Predicting customer behavior using regression
Week 13: Product: new product design / conjoint analysis
Week 14: Review
Week 15: Exam 2 (no video)