Learn to calculate market segments, use pricing techniques, and forecast sales with Excel for better marketing strategy.

Market Analytics: Become a Data-Driven Marketing Expert

Learn to calculate market segments, use pricing techniques, and forecast sales with Excel for better marketing strategy.
Notes de 4,4 sur 5
486 Avis
3 773  Sessions

Ce que vous allez apprendre dans ce cours

Détails

Description

Marketing analyst salaries can reach six figures, but not everyone automatically earns such a high wage. First, you have to have strong analytical skills. Second, you need to know market analytics, which blends marketing, data analysis, and financial modeling. That’s why the Scandinavian Institute of Business Analytics (SCANBA) created a course that combines all three fields. You’ll learn how to conduct market surveys, analyze the data, find clusters, set product prices, forecast sales and even more. You’ll learn to use Microsoft Excel at a professional level, and be guided through every example to ensure you reach the learning objectives. By the end of the course, you’ll possess the kind of knowledge that’s available only to top market analytics experts.    

The course is 2 hours in total, evenly split into 3 chapters:

Chapter 1. Market Segmentation   

5 advantages of market segmentation

Segmentation variables you can use

Descriptive and predictive market segmentation techniques

4 major market segmentation techniques: cross-tabulation, regression, clustering, and conjoint-analysis

Chapter 2. Price Analytics   

11 pricing techniques

3 pricing assessment methods, including break-even analysis and the net present value capital budgeting model

5 Excel spreadsheet examples

Concepts of elastic demand, optimal pricing, and price discrimination.

Chapter 3. Sales Forecasting   

3 major sales forecasting methods including moving average, exponential smoothing, and regression

2 additional extensions to the methods for in-depth analysis

5 Excel spreadsheet examples

Methods for predicting both seasonality and trends in sales.

   

The course has downloadable example files you can use for practice. 

À qui ce cours s’adresse-t-il ?
Marketing professionals
MBA students
Enterpreneurs
Business developers
All levels of business analysts
Afficher plus

Learn to calculate market segments, use pricing techniques, and forecast sales with Excel for better marketing strategy.

19,99 €
Redirection avec pop-up et nouvel onglet
Redirection double
Redirection double avec deux onglets

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Cours similaires

Propulsez vos connaissances !

Tous les sujets que vous souhaitez apprendre sont sur Coursselly ! N’attendez plus pour découvrir les formations !

Rejoindre la #commu

Profitez d’avantages exclusifs et de nouvelles fraîches chaque semaine.

19,99 €
Redirection avec pop-up et nouvel onglet