Certified Marketing and Sales Analytics Professional

Current Status

Not Enrolled

Price

Get Started

This course is currently closed

You must login before you access the courses page.

Course Content

Expand All

Course Videos 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Excel 2019 Beginners: Formulas and Functions

Excel 2019 Beginners: Sorting and Filtering

Excel 2019 Beginners: Outlining and Subtotaling

Excel 2019 Beginners: Advanced Formula Creation

Excel 2019 Beginners: PivotTables

Excel 2019 Beginners: Additional Excel Features

Excel 2019 Advanced: PivotTables

Excel 2019 Advanced: Data Analysis

Analytics Introduction 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Evolution and Scope

Data Management and Types

Decision Models

Problem Solving and Decision Making

Using Spreadsheets for Analytics 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Excel Formulas

Excel Functions

Spreadsheet Add-Ins

What is Spreadsheet Modeling?

Visualizing Data in Spreadsheets 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Excel Data Visualization Tools

Data Queries in Excel

Data Summarization in Excel

PivotTables and Pivot Charts

Descriptive Statistical Measures 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Statistical Notation

Measures of Location

Measures of Dispersion

Measures of Shape

Measures of Association

Frequency Distributions

Excel Descriptive Statistics Tool

Probability Distributions 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Probability Basics

Discrete Probability Distributions

Continuous Probability Distributions

Distribution Fitting

Marketing Management 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Defining Marketing for the 21st Century

Core Concepts in Marketing

Marketing Environment

Company Orientation towards Market Place

The Holistic Marketing Concept

Market Research Process 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

The Research Process

Formulating the Research Problem

Choice of Research Design

Determining Sampling Design and Sampling Size

Preparing the Research Report

Evaluation and Control of Marketing Research

Sampling and Hypothesis 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Types of Sample Designs

Bases of stratification

Characteristics of a Good Sample Design

Determining the Sample Size

Data Processing and Analysis 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Data-Processing Methods

Forecasting Methods 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Forecasting Basics

Moving average and Exponential methods

Decomposition method

ARIMA Model

Environmental Analysis 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

PEST

Anticipating Changes in the Law

Economic Factors

International Factors

Social Factors

Technological Factors

Competitive Intelligence

Segment-Target-Position 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Marketing Strategies 11 Topics

Expand

Lesson Content

0% Complete 0/11 Steps

Strategic Intent

Ansoff’s Product/Market Matrix

The Boston Matrix

Bowman’s Strategy Clock

Generic Strategies – Michael Porter (1980)

The danger of Being ‘Stuck in the Middle’

Marketing Control

Internal Marketing

The Balanced Scorecard

Gap Analysis

KPI

Test Marketing 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

Test Marketing

Other Forms of Experimentation

Innovation

Pricing policy 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Pricing Decisions

Pricing Approaches

Pricing and Market Share

Pricing Strategies

Price Adjustment Strategies

Digital Marketing 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Introduction

E-Commerce

Search Engine Optimization

Social Media

Behavioral Targeting

Email Marketing

Customer Relationship Management

Sales Management 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

Objectives of Sales Management

Sales Executives as Coordinator

Coordinating with Advertising

Co-ordination with Production

Co-ordination with Human Resource

The Four Sales Channels

Sales Management in the 21st Century

A Five-Step Remedy

“Top Gun” Sales Managers

Theories Of Selling 3 Topics

Expand

Lesson Content

0% Complete 0/3 Steps

“Right Set of Circumstances” Theory of Selling

“Buying Formula” Theory of Selling

“Behavioral Equation” Theory

Prospecting, Objection Handling and Closing 5 Topics

Expand

Lesson Content

0% Complete 0/5 Steps

Prospecting

Formulating Prospect Definitions

Searching out Potential Accounts

Sales Resistance

Closing Sales

Sales Forecasting 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

Analyzing Market Potential

Market Indexes

Sales Potential

Sales Forecasting Methods

Qualitative Forecasting Methods

Projection of Past Sales

Time-Series Analysis

Exponential Smoothing

Regression Analysis

Econometric Model Building and Simulation

Advanced Sales Analytics 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Campaign Effectiveness Analysis

Dealer wise and Region wise Sales Analysis

Customer Analytics (Acquisition, NPS, Lifetime Value, etc)

Customer Engagement

Promotion Analytics

Sentimental Analysis

Advanced Marketing Analytics 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

Marketing Success Metrics

Price Analytics

Market Mix Modeling

Digital Marketing Analytics (Web, social media, digital ad)

Additional Course Videos 17 Topics

Expand

Lesson Content

0% Complete 0/17 Steps