Revenue and Pricing Analytics with Excel & Python.
What you'll learn
- What are the discount rates you should set to maximize revenue of your products?
- Optimizing prices with excel and python
- Customized pricing with python
- Customer analytics
- The different pricing strategies that you should implement for different products.
- The willingness to pay of customers
- how to fit the demand with the right response function
- How to differentiate products and pricing to different segments
- The concept of nesting in revenue management and how to apply it
- Data Science
- Basic Knowledge of excel
- Motivation to increase revenue and profits.
Course Image by @agent_illustrateur-Christine Roy from unsplash.
Python Crash section included!
in the late seventies, airline ticket prices in the united states were regulated and almost fixed, we as customers did not have the luxury to opt for economy class or business class, only one class!! Back then American airlines were the leaders in the industry. But with deregulation new disruptors as People Express entered the scene with tickets so much cheaper than American Airlines. Customers migrated from American airlines to the economic People Express.
what happened next changed the way we think about prices from merely making a profit to a strategic weapon that boosts business profitability and enhances product availability.
American Airlines introduced segmentation and revenue management techniques on its ticket prices "yield management" to attract People Express Customers back and People Express eventually went out of business. oh, I forgot to mention that American airlines' profit increased by 47% that year. And the rest was history.
This practice was then adopted by Ford for car rentals, Mariott hotels for room booking, NBC, and ABC for Ads placement to pretty much every business there is nowadays.
this course will take you on this exciting journey of understanding consumer behavior. how to set prices for your products to maximize revenue and enhance product availability. if you are running your own business, managing a product line, or even launching a new product or service, this course will come in handy to set you on the right path for success.
Not only this, Businesses now have hundreds of products and services if not thousands and we simply cannot optimize pricing for all of them with excel for example, that's why the course introduces you also pricing and revenue management with Python. not to worry if it's the first time for you with python, I show you how to do it step by step.
the course is full of lectures, concepts, codes, exercises, and spreadsheets. and we don't present the code, we do the code with you, step by step, by the end of this course, you will be able to :
With excel :
The perishability of inventory
The different pricing strategies
The willingness to pay of customers
how to fit the demand with the right response function
Elasticity of products and how can we use them to set prices
How to differentiate products and pricing to different segments
The concept of nesting in revenue management and how to apply it
Applying little wood’s rule and EMSR to set booking limits for different service offering
Optimizing the prices for different product simultaneously
With python :
Þ The basics of python, functions, and for loops
Þ Fitting demand with linear and logit functions
Þ Multi-product optimization
Þ Customized pricing.
the course is designed as experiential learning Modules, the first couple of modules are for understanding pricing followed by applications using optimization.Don't worry if you don't know python, there are is a python fundamental section in the course to get you up and running with python.
Looking forward to seeing you inside and hope you enjoy the class.
Who this course is for:
- Marketing professionals
- Sales professionals
- Revenue managers
- Brand Managers
- Supply chain professionals
"Never follow a book by its cover, In a world that changes every second, we must be resilient and proactive. " Consultant / Developer /Trainer
Consultant in Supply Chain Management & Business Intelligence
Founder - Rescale Analytics – Dubai
• PhD student at the University of Bordeaux.
• Supply chain and data science consultant for several national and multinational clients in the UAE and France.
• Data Scientist, Master of Science in Global Supply Chain Management from Bordeaux Ecole de Management, Bordeaux, France
He is currently conducting workshops and seminars in Supply chain and data science as well as consultancy projects for Sephora, Sharaf group and aster pharmacy.
• Haytham conducted more than 70 workshops in UAE in the last three years in supply chain and data science.
Qarar for financial analytics
PWC training Academy
Higher College of Technology
Partners: Edusphere dubai- Limar Tech Saudi arabia – sl-tech Abu Dhabi
Projects :AHQ-SHARAF GROUP:
developing an algorithm for the replenishment of stocks to Sharaf group -adventure HQ . the algorithm is being used since November 2019 with notable results.
Developing and deploying an algorithm for revenue maximization based on elasticity techniques for adventure zones service provided by AHQ.
Projects: Sephora – France
Haytham is working with Kedge business school as part of the team CSIT for partnership
The collaboration of Omni-channel optimization with Sephora France. As a part of his Ph.D. project.
Development: Haytham developed the Inventorize package in R mainly used for supply chain analytics with more than 12000 Downloads so far.