Marketing Analytics and Retail Business Management
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)
