Skip to main content
HomeGoogle SheetsCase Study: Net Revenue Management in Google Sheets

Case Study: Net Revenue Management in Google Sheets

You will use Net Revenue Management techniques in Google Sheets for a Fast Moving Consumer Goods company.

Start Course for Free
3 Hours6 Videos27 Exercises

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
GroupTraining 2 or more people?Try DataCamp For Business

Loved by learners at thousands of companies


Course Description

Fast Moving Consumer Goods

The world of Fast Moving Consumer Goods (FMCG) is a dynamic world that plays a significant role in our daily lives. Have you ever wondered how well-known brands like Coca-Cola, Nivea, and Lay's are being managed? This case study will help you get a better understanding of this industry.

Net Revenue Management

You will start by analyzing a big dataset and by performing your own market analysis. You will go from calculating market share to creating clear visuals to reveal actionable insights. Next, you will use the principles of Net Revenue Management (NRM), which will help you to identify new growth opportunities for your company. You will have to use a variety of Google Sheets tools and functions to calculate the true potential of these growth buckets. You will not only master everything which relates to PivotTables, VLOOKUP, and forecasting but also have a better understanding of what is happening behind the scenes of your favorite FMCG brands. Are you ready to use your Google Sheets skills to build a complete business case?
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more
Try DataCamp for BusinessFor a bespoke solution book a demo.
  1. 1

    Fast Moving Consumer Goods (FMCG)

    Free

    In the first chapter, you will be working as a category manager for Healthmax, a FMCG company active in the shampoo business. You will calculate Key Performance Indicators (KPIs) such as market share and value growth on various time dimensions such as year-to-date (YTD) and moving annual (MAT) total.

    Play Chapter Now
    Introduction to the FMCG industry
    50 xp
    FMCG Products
    50 xp
    How do FMCG companies measure their performance?
    50 xp
    Investigating the dataset
    100 xp
    Year-over-Year Growth
    100 xp
    Calculating year-to-date Numbers
    50 xp
    Year-to-Date
    100 xp
    Moving Annual Total
    100 xp
    Market Share
    100 xp
    FMCG Products Market Share
    50 xp
  2. 2

    Net Revenue Management (NRM)

    In this chapter, you will learn about the concept of Net Revenue Management (NRM) and will focus on two of its pillars: Brand Portfolio Pricing and Mix Management.

    You’ll calculate important KPIs such as net sales contribution and gross margin. You’ll also use brand Portfolio Pricing to identify the correct price for your consumers. Consecutively you’ll use Mix Management techniques to help Healthmax launch a new product and expand into a new subcategory.

    Play Chapter Now
  3. 3

    Optimizing Net Revenue

    In the last chapter, you will focus on the three remaining pillars of Net Revenue Management (NRM). Trade Terms Management will help you to decide in which customers and products you should be investing to grow your business.

    You’ll combine that information with Pack Price Architecture to develop a new pricing strategy for a small shampoo bottle and use a Promotion Management technique to identify the most successful promotion. Finally, you’ll wrap it up by forecasting next year's growth by combining organic growth with the additional revenue of your NRM activities.

    Play Chapter Now

Datasets

MetadataShampoo DatasetPromotion Analysis DatasetInternet Sales DatasetNew Product Launch Dataset

Collaborators

Collaborator's avatar
Gauthier Georgis
Collaborator's avatar
Maarten Van den Broeck
Carl Rosseel HeadshotCarl Rosseel

Head of BI Curriculum at DataCamp

Carl, a Tableau certified data analyst, is the head of the BI Curriculum at DataCamp, where he focuses on democratizing data skills through Business Intelligence tools. He holds a double master's degree in Business Engineering and worked in various analyst roles at an e-commerce company before joining DataCamp. He likes to use data to make the complex simple and tell data stories. Outside work, you can often find him enjoying a game of soccer, both on and off the pitch.
See More

What do other learners have to say?

Join over 13 million learners and start Case Study: Net Revenue Management in Google Sheets today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.