Retail analytics using MS Excel – Covering Forecasting, Market Basket, RFM, Customer Valuation & Price Bundling
What you’ll 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