Marketing Analytics & Retail Business Management using Excel

سرفصل های دوره

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

1. Course Introduction

1. Introduction

2.1 Course resources.zip

2. Course resources.html

2. Part 1 Forecasting

1. Basics of Forecasting

2. This is a milestone!

3. Creating Linear Model with Trendlines

4. Quiz.html

3. 1.1 Getting Data ready for Regression Model

1. Gathering Business Knowledge

2. Data Exploration

3. The Data and the Data Dictionary

4. Univariate analysis and EDD

5. Descriptive Data Analytics or EDD in Excel

6. Outlier Treatment

7. Outlier treatment in Excel

8. Missing Value Imputation

9. Missing value imputation in Excel

10. Variable Transformation in Excel

11. Dummy variable creation Handling qualitative data

12. Dummy Variable Creation in Excel

13. Correlation Analysis

14. Creating Correlation Matrix in Excel

15. Quiz.html

4. 1.2 Forecasting using Regression Model

1. The Problem Statement

2.1 Presentations.zip

2. Regression model - Presentations.html

3. Basic Equations and Ordinary Least Squares (OLS) method

4. Assessing accuracy of predicted coefficients

5. Assessing Model Accuracy RSE and R squared

6. Creating Simple Linear Regression model

7. Multiple Linear Regression

8. The F - statistic

9. Interpreting results of Categorical variables

10. Creating Multiple Linear Regression model

5. 1.3 Handling Special events like Holiday sales

1. Forecasting in presence of special events

2. Excel Running Linear Regression using Solver

3. Excel Including the impact of Special Events

6. 1.4 Identifying Seasonality & Trend for Forecasting

1. Models to identify Trend & Seasonality

2. Quiz.html

3. Excel Additive model to identify Trend & Seasonality

4. Excel Multiplicative model to identify Trend & Seasonality

7. Market Basket Analysis

1. Market Basket and Lift - Introduction

2. Named Ranges - Excel

3. Indirect Function - Excel

4. 2-way lift calculation in Excel

5. 2-way lift calculation - Dynamic

6. 2-way lift data table creation

7. 3-way lift calculation

8. Store Layout optimization using Lift values

8. RFM (recency, frequency, monetary) Analysis

1. RFM (recency, frequency, monetary) Analysis

2. RFM Analysis in Excel- Part 1

3. RFM Analysis in Excel- Part 2

9. Part 2 Pricing

1. Steps of setting a Pricing policy

2. Different Pricing Objectives

10. 2.1 Estimating Demand

1. Estimating Demand

2. Forms of Demand Curve

3. Price Elasticity Examples.html

4. Excel Estimating Linear Demand Curve

5. Excel Estimating Power Demand curve with Elasticity

6. Excel Estimating Power Demand Curve with points

7. Subjective Demand curve

8. Excel Estimating Subjective Demand Curve

11. 2.3 Evaluating Pricing Strategies

1. Price Bundling

2. Types of Bundling

3. The Bundling Problem

4. Excel Solving Bundling problem Part 1

5. Excel Solving Bundling problem Part 2

6. Excel Solving Bundling problem (Price Reversal)

7. Non-Linear Pricing Strategies

12. 3.1 Lifetime Customer Value

1. Lifetime Customer Value - Key concepts

2. Lifetime Customer Value - Excel model

13. 3.2 Variations and Sensitivity Analysis

1. Sensitivity Analysis in Excel

2. Variations in finding customer value

14. Appendix 1 Excel crash course

1. Important Excel functions.html

2. Popular Excel charts.html

15. Congratulations & about your certificate

1. The final milestone!

2. Bonus Lecture.html

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training