Data Analytics for Pricing Analysts in Excel

Learn how to use pricing analysis to maximize firm profits with scenario analysis, price optimization, and data analytics in Excel.

Introduction

• Build effective pricing models with Excel
• Practical considerations in pricing

1. The Basics of 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

2. Data Analytics and Optimization

• Demand curves and business
• Estimating linear and power demand curves
• Estimating profit-maximizing price with Goal Seek
• Optimization and scenario analysis
• Advanced analytics tools

3. Using Price Discrimination

• 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

4. Stress Testing

• 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

Conclusion

• Continue using Excel for pricing analytics