Data Analytics for Pricing Analysts in Excel
2h 4mAdvanced2023-10-11
Authors
Michael McDonald
Researcher and Professor of Finance at Fairfield University
Course details
Discover how to make smarter product pricing decisions that maximize your organization's profits. In this course, instructor Michael McDonald goes over using scenario analysis, price optimization, and variance analysis to model the data analytics behind pricing . Michael explains how to determine bundle pricing in a scenario, estimate price elasticity, compute price optimization profits with one variable or many variables, balance price and sales volume considerations, and more. If you'd like to pursue a career in corporate finance—particularly as a pricing analyst in an insurance, retail, manufacturing, or technology firm—then this course can help equip you with the skills you need to help your company succeed in today's economy.
Learning objectives
Break down how price affects both supply and demand.
Explain how to use linear interpolation to make optimal pricing decisions.
Identify different types of price discrimination.
Give examples of inelastic pricing.
Predict the effect higher margins for your products would have on your competitors.
Compare the value of a unit of price to a unit of volume.
Learning objectives
Break down how price affects both supply and demand.
Explain how to use linear interpolation to make optimal pricing decisions.
Identify different types of price discrimination.
Give examples of inelastic pricing.
Predict the effect higher margins for your products would have on your competitors.
Compare the value of a unit of price to a unit of volume.
Skills covered
Business IntelligenceSpreadsheetsMicrosoft ExcelAdvancedData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft
Concepts
0. Introduction
- 01 - Build effective pricing models with Excel
- 02 - Practical considerations in pricing
1. The Basics of Pricing
- 03 - What price matters
- 04 - Models of pricing
- 05 - Supply and demand
- 06 - Optimizing price in business
- 07 - Assessing price in a scenario
- 08 - Gathering data to set pricing
- 09 - Pricing in practice
2. Data Analytics and Optimization
- 10 - Demand curves and business
- 11 - Estimating linear and power demand curves
- 12 - Estimating profit-maximizing price with Goal Seek
- 13 - Optimization and scenario analysis
- 14 - Advanced analytics tools
3. Using Price Discrimination
- 15 - Fundamentals of price discrimination
- 16 - Price elasticity
- 17 - Estimating price elasticity
- 18 - Determining feasible degrees of price discrimination
- 19 - Calculating profitability under price discrimination
- 20 - Price discrimination with multiple variables
- 21 - Applied pricing discrimination
- 22 - Price differentiation and marketing attribution
4. Stress Testing
- 23 - Business forecasting
- 24 - Assessing the impact of competition
- 25 - Scenario analysis in pricing
- 26 - Variance analysis walks and pricing
- 27 - Building variance waterfalls
- 28 - Best practices in pricing
- 29 - Tools for pricing
Conclusion
- 30 - Continue using Excel for pricing analytics