Scribd Logo
Upload

Welcome to Scribd!

  • 2K views

    Tiger Analytics - Case Study 2

    Uploaded by

    Saurabh Mahajan
    This document provides details about a case study on new food and beverage product launches. It includes three datasets: 1) a product launch dataset with details on products, flavors, and launch dates; 2) a flavor classification dataset mapping flavors to groups; and 3) a positioning category mapping dataset mapping positioning categories to groups. The case asks to identify the top 10 emerging flavors in North America over the last 5 years from the data and explain the solution approach. It also asks what additional data and analyses a brand manager would use to decide whether to launch new SKUs or modify existing offerings for an iced tea brand.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Tiger Analytics - Case Study 2

    Uploaded by

    Saurabh Mahajan
    2K views2 pages
    This document provides details about a case study on new food and beverage product launches. It includes three datasets: 1) a product launch dataset with details on products, flavors, and launch dates; 2) a flavor classification dataset mapping flavors to groups; and 3) a positioning category mapping dataset mapping positioning categories to groups. The case asks to identify the top 10 emerging flavors in North America over the last 5 years from the data and explain the solution approach. It also asks what additional data and analyses a brand manager would use to decide whether to launch new SKUs or modify existing offerings for an iced tea brand.

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides details about a case study on new food and beverage product launches. It includes three datasets: 1) a product launch dataset with details on products, flavors, and launch dates; 2) a flavor classification dataset mapping flavors to groups; and 3) a positioning category mapping dataset mapping positioning categories to groups. The case asks to identify the top 10 emerging flavors in North America over the last 5 years from the data and explain the solution approach. It also asks what additional data and analyses a brand manager would use to decide whether to launch new SKUs or modify existing offerings for an iced tea brand.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    2K views2 pages

    Tiger Analytics - Case Study 2

    Uploaded by

    Saurabh Mahajan
    This document provides details about a case study on new food and beverage product launches. It includes three datasets: 1) a product launch dataset with details on products, flavors, and launch dates; 2) a flavor classification dataset mapping flavors to groups; and 3) a positioning category mapping dataset mapping positioning categories to groups. The case asks to identify the top 10 emerging flavors in North America over the last 5 years from the data and explain the solution approach. It also asks what additional data and analyses a brand manager would use to decide whether to launch new SKUs or modify existing offerings for an iced tea brand.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 2

    https://www.tigeranalytics.

    com/

    Case Study - 2

    The provided datasheet captures some details about new Food and Beverage (F&B)

    product launches across the world.

    Below are some notes around various files.


    Product Launch Dataset.csv

    The column names are self-explanatory; feel free to make relevant assumptions.

    Each product could come in combination of multiple flavors. Each unique flavor used

    in a product is separated from another by a semicolon (;).


    E.g. Product ID #10 states: “Cherry, not specified; Vanilla, not specified.” This means

    product #10 comes in a combination of two unique flavors. The first flavor “Cherry,
    not specified” means the flavor is Cherry but it is not mentioned what particular type

    of Cherry flavor is used (e.g Red Cherry or Black Cherry). Similarly, for the second
    flavour.

    The “Launch date” represents the date on which a product was launched.
    Flavor Classification Dataset. Csv

    Maps each unique flavor to a “Flavor Group”.


    Positioning Category Mapping Dataset. csv

    Each product (as specified by a product ID) could come in combination of multiple
    positioning categories. This file maps each unique positioning category to a

    “Positioning Group”.

    C o n f i d e n t i a l
    1
    https://www.tigeranalytics.com/

    Case Statement

    Prepare a presentation giving an overview of the “F&B flavors in North America


    region”.

    Among other things of interest in the presentation, identify the top 10 emerging

    flavors over the last 5 years available in the data. Explain your solution approach.

    If you are the Brand Manager in CPG - Foods business (in a category say Iced Tea),
    and you need to decide whether to launch a new brand variant in the market in

    addition to the flavors you already have. What data and analyses will you use (in
    addition to what you have here), to decide whether to launch a new SKUs or retain

    the existing SKUs, or even remove some of the existing SKUs?

    Feel free to use any tool / language of your choice to do the analysis and submit a

    report (PPT) not exceeding 15 slides.

    Please have any raw results in excel files or codes/scripts and submit the same.

    C o n f i d e n t i a l
    2

    You might also like