Marketing Analytics and Retail Business Management

1. Become proficient in using powerful tools such as excel solver to create forecasting models
2. Learn how to estimate the trend and seasonal aspects of sales
3. Perform market basket analysis and calculate lift to derive a store layout that maximizes sales from complementary products
4. Understand how to interpret the result of Linear Regression model and translate them into actionable insight
5. Learn practical concepts of how to get revenue/profit optimized price point in case of Bundle products.
6. Learn why cable companies bundle landlines, cell phone service, TV service, and Internet service (Bundling)
7. Perform RFM (Recency, frequency, and monetary value) analysis to help you maximize profit from promotional mail campaigns.
8. Learn to calculate customer’s lifetime value under different scenarios and use it to increase the company’s profitability.
9. Incorporate the impact of discount rate and retention rate to calculate customer value