Marketing Analytics & Retail Business Management using Excel

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

Created by: Start-Tech Academy
5,000,000+ Enrollments | 4.5 Rated | 160+ Countries

What Will I 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

Requirements

• You will need a PC with any version of Excel installed in it
• Basic understanding of Excel operations like opening, closing and saving a file

Target audience

• Anyone curious to learn the analytics behind most popular marketing startegies