Introduction to the case study

Case Study: Net Revenue Management in Google Sheets

Carl Rosseel

Head of Business Intelligence Curriculum at DataCamp

Case study goals

  • Apply Google Sheets skills to a real-world problem
  • Context: Fast Moving Consumer Goods (FMCG) company
  • Goal: identify NRM growth opportunities
  • Recommended prerequisites in Excel:
    • Data Analysis in Google Sheets
    • Pivot Tables in Google Sheets

Image of an employee solving a problem in Excel

Case Study: Net Revenue Management in Google Sheets

Case study overview

Overview of the steps we will follow during this case study

Case Study: Net Revenue Management in Google Sheets

Case study overview

Overview of the steps we will follow during this case study

Case Study: Net Revenue Management in Google Sheets

Case study overview

Overview of the steps we will follow during this case study

Case Study: Net Revenue Management in Google Sheets

FMCG industry

FMCG = Fast Moving Consumer Goods Image with some FMCG brands as an example

Case Study: Net Revenue Management in Google Sheets

FMCG products

  • Purchased frequently
  • Quick consumption
  • Relatively low price
  • Widely available
  • High shelf rotation
  • Sold in huge quantities
  • Low margin for supplier

Image with some FMCG products as an example

Case Study: Net Revenue Management in Google Sheets

Growth in the FMCG industry

  • Global annual turnover of $11.4 trillion in 2021
  • Growth strategies:
    • 4 P's: Product, Price, Place & Promotion

Example of 4 P's for Coca-Cola

  • Net Revenue Management (NRM)
1 https://www.alliedmarketresearch.com/fmcg-market
Case Study: Net Revenue Management in Google Sheets

Let's practice!

Case Study: Net Revenue Management in Google Sheets

Preparing Video For Download...