Share Description
In this course, you will :
- Learn how to use powerful tools like Excel Solver to create forecasting models.
- Learn how to forecast sales trends and seasonality.
- To create a store layout that maximises sales from complementary products, conduct a market basket analysis and calculate lift.
- Understand how to interpret Linear Regression model results and turn them into actionable insight.
- Learn practical concepts for obtaining a revenue/profit optimised price point for Bundle products.
- Discover why cable companies bundle landlines, cell phones, television, and Internet service (Bundling).
- RFM (Recency, frequency, and monetary value) analysis can assist you in maximising profit from promotional mail campaigns.
- Learn how to calculate a customer's lifetime value in various scenarios and use it to boost the company's profitability.
Syllabus :
- Forecasting
- Getting Data ready for Regression Model
- Forecasting using Regression Model
- Handling Special events like Holiday sales
- Identifying Seasonality & Trend for Forecasting
- Market Basket Analysis
- RFM (recency, frequency, monetary) Analysis
- Pricing
- Estimating Demand
- Evaluating Pricing Strategies
- Lifetime Customer Value
- Variations and Sensitivity Analysis
