Section 1 : Introduction

Lecture 1 What the course will be about 00:01:44 Duration
Lecture 2 A little bit about me 00:01:48 Duration
Lecture 3 How the course is organized 00:02:29 Duration
Lecture 4 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM
Lecture 5 About Certification

Section 2 : Understanding the business through KPIs

Lecture 1 Understanding the business through KPIs – Introduction 00:02:34 Duration
Lecture 2 KPIs and main drivers – Introduction 00:02:24 Duration
Lecture 3 Overview of Business models
Lecture 4 Overview of case studies you will be solving in this section 00:01:59 Duration
Lecture 5 KPIs for cinema – Problem 00:00:33 Duration
Lecture 6 KPIs for cinema – Solution 00:01:53 Duration
Lecture 7 KPIs for cinema – Excel 00:05:16 Duration
Lecture 8 KPIs for cinema – Power Point 00:01:58 Duration
Lecture 9 KPIs for marketplace – Problem 00:00:38 Duration
Lecture 10 KPIs for marketplace – Solution 00:02:57 Duration
Lecture 11 KPIs for marketplace – Alternative Solution 00:01:52 Duration
Lecture 12 KPIs for a retailer – Problem 00:00:50 Duration
Lecture 13 Drivers for a retail business model 00:02:07 Duration
Lecture 14 KPIs for a retailer – Solution 00:05:40 Duration
Lecture 15 KPIs for SaaS – Problem
Lecture 16 Examples of SaaS businesses 00:02:03 Duration
Lecture 17 KPIs for SaaS – Solution 00:02:40 Duration
Lecture 18 KPIs for a restaurant – Problem 00:00:45 Duration
Lecture 19 Main drivers for restaurant business model 00:02:24 Duration
Lecture 20 KPIs for a restaurant – Solution 00:02:35 Duration
Lecture 21 KPIs for a consulting business – Problem 00:00:44 Duration
Lecture 22 Main drivers for consulting business 00:01:57 Duration
Lecture 23 KPIs for a consulting business – Solution 00:02:37 Duration
Lecture 24 KPIs for a FMCG business model – Problem 00:00:50 Duration
Lecture 25 Main drivers for FMG business model 00:01:49 Duration
Lecture 26 KPIs for a FMCG business model – Solution 00:03:37 Duration
Lecture 27 KPIs for a SMCG business model – Problem 00:00:47 Duration
Lecture 28 Main drivers for SMCG business model 00:02:23 Duration
Lecture 29 KPIs for a SMCG business model – Solution 00:03:37 Duration
Lecture 30 KPIs for a commodity business model – Problem 00:00:38 Duration
Lecture 31 Main drivers for Commodity business model 00:02:34 Duration
Lecture 32 KPIs for a commodity business model – Solution 00:03:39 Duration
Lecture 33 KPIs for an e-commerce – Problem 00:00:30 Duration
Lecture 34 Main drivers for e-commerce business model 00:03:14 Duration
Lecture 35 KPIs for an e-commerce – Solution 00:09:37 Duration

Section 3 : Using KPIs to model the business in Excel

Lecture 1 Using KPIs to model the business in Excel – Introduction 00:00:49 Duration
Lecture 2 Overview of case studies we will discuss in this section 00:01:09 Duration
Lecture 3 Introduction to the B2C Services Business Model 00:01:17 Duration
Lecture 4 Things that matter in hairderssers, beauty salons etc- 00:05:31 Duration
Lecture 5 Things that matter in other B2C Services Business Model 00:01:58 Duration
Lecture 6 Introduction to modeling B2C Services in Excel 00:01:01 Duration
Lecture 7 Business model of a restaurant in Excel - basic model 00:08:33 Duration
Lecture 8 Business model of a restaurant in Excel - advanced model 00:08:22 Duration
Lecture 9 Restaurant chain - how to model it in Excel- 00:05:49 Duration
Lecture 10 Introduction to e-commerce 00:03:28 Duration
Lecture 11 Examples of e-commerce businesses 00:01:53 Duration
Lecture 12 Logic flow of customers in e-commerce 00:01:09 Duration
Lecture 13 Main KPIs for e-commerce 00:09:37 Duration
Lecture 14 Main challenges in e-commerce 00:04:51 Duration
Lecture 15 E-commerce financial model - basic version 00:09:11 Duration
Lecture 16 Introduction to the B2B Services Business Model 00:01:52 Duration
Lecture 17 Things that matter in B2B Services Business Model 00:02:48 Duration
Lecture 18 General thoughts on B2B Services
Lecture 19 Introduction to modeling B2B Services in Excel 00:00:39 Duration
Lecture 20 Mechanics of business model for a consulting firm 00:01:56 Duration
Lecture 21 The business model of a consulting firm in Excel - Capacity and revenues 00:02:54 Duration
Lecture 22 The business model of a consulting firm in Excel - costs and profit & loss 00:05:05 Duration
Lecture 23 Introduction to SaaS 00:00:51 Duration
Lecture 24 Examples of SaaS businesses 00:02:03 Duration
Lecture 25 Logic flow of customers in SaaS 00:01:59 Duration
Lecture 26 Main KPIs for SaaS 00:09:09 Duration
Lecture 27 Main challenges in SaaS 00:05:06 Duration
Lecture 28 SaaS financial model - basic version 00:08:06 Duration

Section 4 : How to use KPIs to manage

Lecture 1 How to use KPIs to manage – Introduction 00:01:11 Duration
Lecture 2 Benchmarks – external and internal
Lecture 3 Backward logic 00:02:44 Duration
Lecture 4 Comparison metrics 00:02:05 Duration
Lecture 5 Overview of case studies we will discuss in this section 00:00:58 Duration
Lecture 6 How to decide how to 10x your business – Problem 00:01:48 Duration
Lecture 7 How to decide how to 10x your business – New Stores 00:02:41 Duration
Lecture 8 How to decide how to 10x your business – LFL 00:01:56 Duration
Lecture 9 How to decide how to 10x your business – Expansion, Margin & Summary 00:02:34 Duration
Lecture 10 How to decide how to 10x your business – Summary 00:02:15 Duration
Lecture 11 How to decide how to 10x your business – Solution in Power Point 00:02:02 Duration
Lecture 12 How to increase the profitability of a retail chain – Problem 00:01:36 Duration
Lecture 13 How to increase the profitability of a retail chain – Solution – Sales Increase 00:03:17 Duration
Lecture 14 How to increase the profitability of a retail chain – Solution – Cost Reduction 00:04:10 Duration
Lecture 15 How many waiters and dishwashers you need – Problem 00:01:18 Duration
Lecture 16 How many waiters and dishwashers you need – Solution – Waiters 00:03:27 Duration
Lecture 17 How many waiters and dishwashers you need – Solution – Dishwashers 00:04:07 Duration
Lecture 18 How to increase production and decrease costs – Problem 00:02:26 Duration
Lecture 19 How to increase production and decrease costs – Solution – Part 1 00:01:04 Duration
Lecture 20 How to increase production and decrease costs – Solution – Part 2 00:05:19 Duration

Section 5 : How to use KPIs to motivate

Lecture 1 How to use KPIs to motivate – Introduction 00:02:09 Duration
Lecture 2 Where you should put KPIs to motivate people 00:02:30 Duration
Lecture 3 Overview of cases that we will discuss in this section 00:01:03 Duration
Lecture 4 How to analyze the motivation system of sales force – Introduction 00:03:42 Duration
Lecture 5 How to analyze the motivation system of sales force – Solution 00:03:40 Duration
Lecture 6 Juice producer – motivation system of sales force – Introduction 00:02:32 Duration
Lecture 7 Juice producer – motivation system of sales force – Solution – Area Manager 00:04:30 Duration
Lecture 8 Juice producer – motivation system of sales force – Solution – Sales Rep 00:02:12 Duration
Lecture 9 How bad KPIs in production can cause troubles – Problem 00:00:58 Duration
Lecture 10 How bad KPIs in production can cause troubles – Solution 00:03:28 Duration
Lecture 11 Board of directors motivation system – Problem 00:01:28 Duration
Lecture 12 Board of directors motivation system – General Solution
Lecture 13 Board of directors motivation system – Detailed Solution 00:03:31 Duration

Section 6 : What is a good KPI

Lecture 1 What is a good KPI – Introduction 00:01:23 Duration
Lecture 2 The definition of a good KPI 00:02:41 Duration
Lecture 3 Vanity metrics 00:03:27 Duration
Lecture 4 SMART KPIs – Introduction 00:00:34 Duration
Lecture 5 SMART rule for goals 00:05:24 Duration
Lecture 6 SMART KPIs – General rules 00:01:34 Duration
Lecture 7 SMART KPIs – Example 00:01:58 Duration
Lecture 8 Alignment of KPIs – Introduction 00:02:29 Duration
Lecture 9 Alignment of KPIs – Solution 00:05:16 Duration
Lecture 10 Cascading KPIs – Introduction 00:02:28 Duration
Lecture 11 Cascading KPIs – Solution 00:02:51 Duration
Lecture 12 Leading vs Lagging KPIs 00:03:25 Duration
Lecture 13 Input KPIs vs Output KPIs 00:03:54 Duration
Lecture 14 Proxy KPIs 00:02:25 Duration
Lecture 15 How to set the value for KPIs 00:03:34 Duration