Data Analytics for Pricing Analysts in Excel
Offered By: LinkedIn Learning
Course Description
Overview
Learn how to use pricing analysis to maximize firm profits with scenario analysis, price optimization, and data analytics in Excel.
Syllabus
Introduction
- Build effective pricing models with Excel
- Practical considerations in pricing
- What price matters
- Models of pricing
- Supply and demand
- Optimizing price in business
- Assessing price in a scenario
- Gathering data to set pricing
- Pricing in practice
- Demand curves and business
- Estimating linear and power demand curves
- Estimating profit-maximizing price with Goal Seek
- Optimization and scenario analysis
- Advanced analytics tools
- Fundamentals of price discrimination
- Price elasticity
- Estimating price elasticity
- Determining feasible degrees of price discrimination
- Calculating profitability under price discrimination
- Price discrimination with multiple variables
- Applied pricing discrimination
- Price differentiation and marketing attribution
- Business forecasting
- Assessing the impact of competition
- Scenario analysis in pricing
- Variance analysis walks and pricing
- Building variance waterfalls
- Best practices in pricing
- Tools for pricing
- Continue using Excel for pricing analytics
Taught by
Michael McDonald
Related Courses
Pricing StrategyIE Business School via Coursera Estrategia de precios
IE Business School via Coursera Cost and Economics in Pricing Strategy
University of Virginia via Coursera Customer Value in Pricing Strategy
University of Virginia via Coursera Forecasting Product Demand in R
DataCamp