Market Analytics: Become a Data-Driven Marketing Expert
- 3.9
-
![]()
![]()
![]()
![]()
Brief Introduction
Learn to calculate market segments, use pricing techniques, and forecast sales with Excel for better marketing strategy.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.
Requirements
- The course does not have specific requirements for successful compleation
- The attendees might need Excel or IBM SPSS to conduct practical analysis
Scandinavian Institute of Business Analytics
3.9 Raiting
Google BigQuery for Marketers and Agencies
- 4.7
-
![]()
![]()
![]()
![]()
![]()
Learn how to use SQL-powered queries in Google BigQuery to analyze marketing data and find meaningful insights. LATEST CONTENT UPDATE: December, 2020...
Market Analytics: Become a Data-Driven Marketing Expert
- 3.9
-
![]()
![]()
![]()
![]()
![]()
Learn to calculate market segments, use pricing techniques, and forecast sales with Excel for better marketing strategy. First, you have to have strong analytical skills....
2021 Complete Marketing Masterclass #3 | CRO
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Session 3: Conversion Rate Optimization on all your digital marketing channels. Our live Marketing Leadership Workshop is now available online! Does this sound familiar?...
Intro to Marketing Technology
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Marketing Technology and Advertising Technology in the Digital Age Data is all around us and YOU can master how to use data in your marketing strategies leveraging technology....
