Marketing Analytics Bootcamp- IIT Alumni

Marketing Analytics Bootcamp- IIT Alumni

Top Rated Bootcamp from IIT Alumni with hands on Practical Projects

Bestseller
119.14 20.26

About This Course

You're looking for a complete course on understanding Marketing Analytics including Forecasting models to drive business decisions, Pricing strategies & analytics that maximize your firm revenue/profit , and Retail Analytics?

You've found the perfect Marketing Analytics Bootcamp that covers all the above topics in the most exhaustive and application oriented way!  

Marketing Analytics Bootcamp covers: Forecasting + Pricing Analytics + Customer Valuation + Retail Analytics

After completing this course you will be able to:

  • Implement forecasting models such as simple linear, simple multiple regression, Ratio to Moving Average, Winter's method for exponential smoothing with trend and seasonality, famous Bass diffusion model and many more.

  • Increase revenue/profit of your firm by implementing accurate forecasting using Excel solver Add-in

  • Confidently practice, discuss and understand different Forecasting models used by organizations

  • Implement pricing strategies such as simple linear pricing, price bundling, giving quantity discount, price skimming, applying two part tariffs and many more.

  • Increase revenue/profit of your firm by implementing revenue / profit maximizing price point using Excel solver Add-in

  • Confidently practice, discuss and understand different Pricing strategies used by organizations

  • Implement forecasting models such as simple linear, simple multiple regression, Additive and multiplicative trend and seasonality model and many more.

  • Perform 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 Excel solver Add-in

  • Understand the value of your customers to make intelligent decisions on how to spend money acquiring them

  • Confidently practice, discuss and understand different retail analytics models used by organization

Why should you choose this Bootcamp?

We believe in teaching by example. This course is no exception. Every Section’s primary focus is to teach you the concepts through how-to examples. Each section has the following components:

  • Theoretical concepts and use cases of different forecasting models

  • Step-by-step instructions on implement forecasting models in excel

  • Downloadable Excel file containing data and solutions used in each lecture

  • Class notes and assignments to revise and practice the concepts

The practical classes where we create the model for each of these strategies is something which differentiates this course from any other course available online.

What makes us qualified to teach you?

The bootcamp is taught by Abhishek and Pukhraj. As managers in Global Analytics Consulting firm, we have helped businesses solve their business problem using machine learning techniques and we have used our experience to include the practical aspects of data analysis in this bootcamp

We are also the creators of some of the most popular online bootcamps - with over 1,800,000 enrollments and thousands of 5-star reviews like these ones:

This is very good, i love the fact the all explanation given can be understood by a layman - Joshua

Thank you Author for this wonderful bootcamp. You are the best and this bootcamp is worth any price. - Daisy

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the bootcamp content, practice sheet or anything related to any topic, you can always post a question in the bootcamp or send us a direct message.

Download Practice filesand complete Assignments

With each lecture, there are class notes attached for you to follow along. Each section contains a practice assignment for you to practically implement your learning.

Table of Contents:

Course 1: Forecasting models

  • Section 1- Basics of Forecasting for Marketers
  • Section 2- Regression model for forecasting
  • Section 3- Practical –Data preprocessing for forecasting models
  • Section 4- Practical -Creating regression model in Excel
  • Section 5- Evaluating model performance
  • Section 6- Identifying trend and seasonality in sales
  • Section 7- Practical -Identifying trend and seasonality using Excel
  • Section 8- Forecasting models for New Products
  • Section 9- Practical –Winter Holt Model
  • Section 10- Practical –Gompertz and Logistic curve

Course 2: Pricing models and strategies

  • Section 1- Basics of Pricing Models
  • Section 2- Estimating Demand
  • Section 3- Practical: Simulating the demand curves in Excel
  • Section 4- Estimating revenue and profit
  • Section 5- Practical: Optimizing price to maximize profit/ revenue
  • Section 6- Pricing Strategies
  • Section 7- How much can Bundled Pricing increase revenue
  • Section 8- Practical: Price Bundling model in Excel
  • Section 9- Two tier pricing and Price Skimming
  • Section 10- Practical: Two tier pricing and Price Skimming
  • Section 11- Standard and Non-standard Quantity Discounts
  • Section 12- Practical: Quantity Discounts

Course 3: Customer valuation and Retail

  • Section 1- Introduction to Retail Analytics
  • Section 2- Market Basket Analysis and Lift
  • Section 3- Practical –Market Basket Analysis using Excel
  • Section 4- Store Layout for profit maximization
  • Section 5- Practical –Store Layout optimization in Excel
  • Section 6- RFM analysis
  • Section 7- Practical –RFM in Excel
  • Section 8- Customer Lifetime Valuation
  • Section 9- Customer Lifetime valuation in Excel
  • Section 10- Monte Carlo Simulation
  • Section 11- Monte Carlo Simulation in Excel

Other Information

  • Certificate will provided in this course on Completion
  • Full lifetime access
  • Available on Mobile & Laptop

What Students Will Learn In Your Course?

 

1. Forecasting Models with ExcelThis course will teach students some of the most popular forecasting models which are actually used in companies. We cover regression predictive models, models to identify trend and seasonality, averaging methods to remove noise, forecasting sales of new products and many more models

2. Pricing models and StrategiesStudents will learn how companies analytically analyze various pricing strategies to boost profitability and revenue. Learn how to build models of advanced pricing in Excel and finding the right strategy that maximizes revenue or profit.

3. Customer valuation and Retail AnalyticsIn this course, students will learn how to find the lifetime value of customer and use it to build customer acquisition strategy. Using Market Basket Analysis and Lift concepts, students can design the store layout that increases sales revenue. RFM technique will be taught so that students can design better communication strategies.

Are There Any Course Requirements Or Prerequisites?

  • 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

Who Are Your Target Students?

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

Course Content

  • 96 lectures
  • 11:31:44
  • Resource Files
  • Introduction
    00:04:15
  • Basics of Forecasting
    00:05:35
  • Creating Linear Model with Trendlines
    00:08:07
  • Gathering Business Knowledge
    00:03:00
  • Data Exploration
    00:03:19
  • The Data and the Data Dictionary
    00:07:31
  • Univariate analysis and EDD
    00:03:33
  • Discriptive Data Analytics in Excel
    00:10:33
  • Outlier Treatment
    00:04:15
  • Identifying and Treating Outliers in Excel
    00:04:14
  • Missing Value Imputation
    00:03:36
  • Identifying and Treating missing values in Excel
    00:04:00
  • Variable Transformation in Excel
    00:03:40
  • Dummy variable creation Handling qualitative data
    00:04:50
  • Dummy Variable Creation in Excel
    00:07:44
  • Correlation Analysis
    00:09:47
  • Creating Correlation Matrix in Excel
    00:08:07
  • The Problem Statement
    00:01:25
  • Basic Equations and Ordinary Least Squares (OLS) method
    00:08:13
  • Assessing accuracy of predicted coefficients
    00:14:40
  • Assessing Model Accuracy RSE and R squared
    00:03:26
  • Creating Simple Linear Regression model
    00:02:41
  • Multiple Linear Regression
    00:04:57
  • The F - statistic
    00:08:22
  • Interpreting results of Categorical variables
    00:05:04
  • Creating Multiple Linear Regression model
    00:07:35
  • Forecasting in presence of special events
    00:02:47
  • Excel Running Linear Regression using Solver
    00:08:02
  • Excel Including the impact of Special Events
    00:22:05
  • Models to identify Trend Seasonality
    00:06:05
  • Excel Additive model to identify Trend Seasonality
    00:09:52
  • Excel Multiplicative model to identify Trend Seasonality
    00:06:08
  • Moving Average Method
    00:01:40
  • Excel Moving Average Method
    00:15:14
  • Winters Method to accomodate changing Trend Seasonality
    00:06:24
  • Excel Winters method
    00:12:53
  • S-curve for New products
    00:07:55
  • Excel Using Logistic curve to model S-curve
    00:08:21
  • Excel Using Gompertz curve to model S-curve
    00:04:42
  • Bass Diffusion Model for New Products
    00:08:33
  • Excel Implementing Bass Diffusion Model
    00:15:11
  • 6 Steps of setting a Pricing policy
    00:02:55
  • Different Pricing Objectives
    00:07:09
  • Estimating Demand
    00:07:36
  • Forms of Demand Curve
    00:02:02
  • Excel Estimating Linear Demand Curve
    00:08:04
  • Excel Estimating Power Demand curve with Elasticity
    00:05:02
  • Excel Estimating Power Demand Curve with points
    00:03:24
  • Subjective Demand curve
    00:01:38
  • Excel Estimating Subjective Demand Curve
    00:02:47
  • Excel Maximizing Revenue using Excel Solver
    00:08:04
  • Estimating the cost function
    00:05:47
  • Excel Modeling Cost Function and Maximizing Profit
    00:06:47
  • Including effect of complementary goods
    00:01:17
  • Excel Effect of complementary goods
    00:05:15
  • Analyzing Competitors
    00:02:33
  • Price Bundling
    00:07:13
  • Types of Bundling
    00:08:50
  • The Bundling Problem
    00:04:18
  • Excel Solving Bundling problem Part 1
    00:14:03
  • Excel Solving Bundling problem Part 2
    00:08:15
  • Excel Solving Bundling problem (Price Reversal)
    00:08:47
  • Non-Linear Pricing Strategies
    00:03:30
  • Willingness to Pay of customers
    00:03:41
  • Example Problem Statement
    00:01:06
  • Excel Standard Quantity Discounts
    00:21:48
  • Excel Non-Standard Quantity Discounts
    00:06:21
  • Excel Two-Tier Pricing
    00:04:07
  • Price Skimming Strategy
    00:05:36
  • Excel Price Skimming Strategy
    00:10:34
  • Revenue Management
    00:03:35
  • Excel Handling Uncertainity
    00:07:00
  • Appendix Using Lookup functions
    00:08:46
  • Lifetime Customer Value - Key concepts
    00:09:45
  • Lifetime Customer Value - Excel model
    00:11:10
  • Sensitivity Analysis in Excel
    00:07:31
  • Variations in finding customer value
    00:07:08
  • Monte Carlo Simulation - Introduction
    00:05:11
  • Monte Carlo Simulation - Example
    00:05:04
  • Problem Statement
    00:01:51
  • Monte Carlo Simulation in Excel Part 1
    00:10:08
  • Monte Carlo Simulation in Excel Part 2
    00:11:25
  • Monte Carlo Simulation in Excel Part 3
    00:09:46
  • Monte Carlo Simulation in Excel Part 4
    00:05:19
  • Market Basket and Lift - Introduction
    00:07:55
  • Named Ranges - Excel
    00:10:04
  • Indirect Function - Excel
    00:05:38
  • 2-way lift calculation in Excel
    00:11:42
  • 2-way lift calculation - Dynamic
    00:07:11
  • 2-way lift data table creation
    00:07:47
  • 3-way lift calculation
    00:19:36
  • Store Layout optimization using Lift values
    00:15:11
  • RFM (recency frequency monetary) Analysis
    00:08:01
  • RFM Analysis in Excel- Part 1
    00:16:00
  • RFM Analysis in Excel- Part 2
    00:12:10
Image

Start-Tech Academy

Start-Tech Academy
  • 4.9 (16)
  • 15 Reviews
  • 16 Students
  • 3 Courses

Start-Tech Academy is a technology-based Analytics Education Company and aims at Bringing Together the analytics companies and interested Learners. 
Our top quality training content along with internships and project opportunities helps students in launching their Analytics journey. 

Founded by Abhishek Bansal and Pukhraj Parikh. 

Working as a Project manager in an Analytics consulting firm, Pukhraj has multiple years of experience working on analytics tools and software. He is competent in  MS office suites, Cloud computing, SQL, Tableau, SAS, Google analytics and Python.

Abhishek worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.