Marketing Analytics & Retail Business Management using Excel
Retail analytics using MS Excel - Covering Forecasting, Market Basket, RFM, Customer Valuation & Price Bundling
4.63 (1661 reviews)
107 812
students
8 hours
content
May 2025
last update
$79.99
regular price
What you will learn
Become proficient in using powerful tools such as excel solver to create forecasting models
Learn how to estimate the trend and seasonal aspects of sales
Perform market basket analysis and calculate lift to derive a store layout that maximizes sales from complementary products
Understand how to interpret the result of Linear Regression model and translate them into actionable insight
Learn practical concepts of how to get revenue/profit optimized price point in case of Bundle products.
Learn why cable companies bundle landlines, cell phone service, TV service, and Internet service (Bundling)
Perform RFM (Recency, frequency, and monetary value) analysis to help you maximize profit from promotional mail campaigns.
Learn to calculate customer’s lifetime value under different scenarios and use it to increase the company’s profitability.
Incorporate the impact of discount rate and retention rate to calculate customer value
Course Gallery
Loading charts...
2670218
udemy ID
23/11/2019
course created date
27/11/2019
course indexed date
Bot
course submited by