Marketing Analytics and Retail Business Management

Share this post:

Retail analytics using MS Excel – Covering Forecasting, Market Basket, RFM, Customer Valuation & Price Bundling

Marketing Analytics and Retail Business Management

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




Leave a Comment