UDEMY
UDEMY Logo

Marketing Analytics and Retail Business Management 

  • Offered byUDEMY

Marketing Analytics and Retail Business Management
 at 
UDEMY 
Overview

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

Duration

11 hours

Total fee

1,920

Mode of learning

Online

Credential

Certificate

Marketing Analytics and Retail Business Management
Table of contents
Accordion Icon V3

Marketing Analytics and Retail Business Management
 at 
UDEMY 
Highlights

  • Earn a Certificate of completion from Udemy
  • Get a 30 days money back guarantee on the course
  • Get full lifetime access of this course material
  • Learn from 4 articles and 2 downloadable resources
Read more
Details Icon

Marketing Analytics and Retail Business Management
 at 
UDEMY 
Course details

Who should do this course?
  • For anyone who id curious to learn the analytics behind most popular marketing stategies
What are the course deliverables?
  • 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
More about this course
  • Implement forecasting models such as simple linear, simple multiple regression, Additive and multiplicative trend and seasonality model and many more, required for devising marketing analytics strategies effectively
  • Perform marketing analytics and market basket analysis and calculate lift to derive a store layout that maximizes sales from complementary products
  • Do RFM (Recency, frequency, and monetary value) analysis to help you maximize profit from promotional mail campaigns
  • Increase revenue/profit of your firm by implementing revenue / profit maximizing bundle price point using marketing analytics tool like Excel solver Add-in

Marketing Analytics and Retail Business Management
 at 
UDEMY 
Curriculum

Section 1 - Introduction

Section 2 - Basics of Forecasting

Section 3 - Getting Data Ready for Regression Model

Data Exploration

The Data and the Data Dictionary

Univariate analysis and EDD

Discriptive Data Analytics in Excel

Outlier Treatment

Identifying and Treating Outliers in Excel

Missing Value Imputation

Identifying and Treating missing values in Excel

Section 4 - Forecasting using Regression Model

Section 5 - Handling Special events like Holiday sales

In this section we will learn how to incorporate effects of Day of Week Effect, Month Effect or any special event such Holidays, pay day etc.

Section 6 - Identifying Seasonality & Trend for Forecasting

In this section we will learn about trends and seasonality and how to use the Solver to develop an additive or multiplicative model to estimate trends and seasonality. We will also learn how to use moving averages to eliminate seasonality to easily see trends in sales.

Marketing Analytics and Retail Business Management
 at 
UDEMY 
Entry Requirements

Eligibility criteriaUp Arrow Icon
Conditional OfferUp Arrow Icon
  • Not mentioned

Other courses offered by UDEMY

Marketing Analytics and Retail Business Management
 at 
UDEMY 
Students Ratings & Reviews

5/5
Verified Icon8 Ratings
qna

Marketing Analytics and Retail Business Management
 at 
UDEMY 

Student Forum

chatAnything you would want to ask experts?
Write here...