Marketing Analytics & Retail Business Management using Excel
Retail analytics using MS Excel - Covering Forecasting, Market Basket, RFM, Customer Valuation & Price Bundling
What you will learn:
Become proficient in using powerful tools such as excel solver to create forecasting modelsLearn 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