Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Data Analytics for Pricing Analysts in Excel

via LinkedIn Learning

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
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

Taught by

Michael McDonald

Reviews

4.8 rating at LinkedIn Learning based on 133 ratings

Start your review of Data Analytics for Pricing Analysts in Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.