Data Analytics for Pricing Analysts in Excel (2018)

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.