Analytics for Business Strategy: Core Executive Skills

Learn an analytics-based approach to making strategic decisions for your organization with Excel examples.

What you'll learn

Techniques and practical tools for evaluating business strategies
Methods to quantify the business strategy decision
Tools for testing strategic scenarios for the business in various market conditions
Quantitative Strategic Planning Matrix and SWOT analysis
Analytical Hierarchical Process in Excel
Monte-Carlo Simulations for business decisions in Excel

Requirements

Basic knowledge of Excel

Description

This course is unique in the sense that it combines business strategy scenarios, metrics, advanced analytic approaches, and simplicity of Excel examples for real-world applications.

The course covers Strategic Metrics, Strategic Scenarios, and Strategic Decision Models with downloadable examples in Excel. You will learn techniques and practical tools for selecting the most effective strategic option for your business. You will learn how to quantify your business strategy decision. You will learn how to test strategic scenarios for your business and test various market conditions. You will learn how to construct a Monte-Carlo model in Excel to predict business outcomes in uncertain environments. You will be introduced to the most commonly used strategic metrics and the formulas behind them.

The course consists of 23 lectures, split into three chapters.

Chapter 1. Strategic Metrics

You will learn:

9 sets of commonly used strategic metrics

Monetary and non-monetary metrics classification

Formulas behind the strategic metrics

Business areas of use for each strategic metric

Chapter 2. Strategic Scenarios

You will learn:

3 fundamental business scenarios

Strategic approaches for each scenario

Strategic models for each strategic approach

Chapter 3. Strategic Decision Model

You will learn:

3 types of strategic decisions

Decision models for each type of strategic decision

Quantitative Strategic Planning Matrix and SWOT analysis

Analytical Hierarchical Process

Monte-Carlo Simulations

Downloadable Excel spreadsheet examples for each decision model

This course has downloadable Excel files with examples that you can use for practice.

Who this course is for:

Corporate employees who want to broaden their responsibilities
Independent entrepreneurs who want to build a better business
MBA students who want to make a successful carrier
Individuals who challenge making appropriate decisions