Login Sign Up

Marketing Analytics & Retail Business Management using Excel

Via Udemy

Udemy based on 1 ratings

Share

0

Overview

Retail analytics using MS Excel - Covering Forecasting, Market Basket, RFM, Customer Valuation & Price Bundling 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...

Syllabus

  • Course Introduction
  • Part 1: Forecasting
  • 1.1 Getting Data ready for Regression Model
  • 1.2 Forecasting using Regression Model
  • 1.3 Handling Special events like Holiday sales
  • 1.4 Identifying Seasonality & Trend for Forecasting
  • Market Basket Analysis
  • RFM (recency, frequency, monetary) Analysis
  • Part 2: Pricing
  • 2.1 Estimating Demand


Marketing Analytics & Retail Business Management using Excel
Go to Class

via Udemy

7 hours 51 minutes

Certificate Available

English

On-Demand

Beginner

Instructor

Start-Tech Academy

Reviews

No reviews yet. Be the first to review!