Retail analytics using MS Excel – Covering Forecasting, Market Basket, RFM, Customer Valuation & Price Bundling
-
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
GET ON UDEMY