Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 232 views

    Problem Statement and Dataset Details

    Uploaded by

    pratik yadav
    The dataset is from a café chain transaction records. The goal is to recommend ways to increase revenue. Exploratory analysis found that tobacco, food, and beverages are top sellers. Tobacco contributes most to revenue. Top items were identified in each category. Sales peak on weekends and evenings. Market basket analysis identified commonly purchased item pairs that could be bundled in combo offers. Recommendations include happy hour liquor deals, bundling less popular items, combo meal offers not including breakfast, discounted weekday prices, merchandise loyalty programs, more weekend staff, and buy-one-get-one beverage deals.

    Copyright:

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

    Problem Statement and Dataset Details

    Uploaded by

    pratik yadav
    232 views13 pages
    The dataset is from a café chain transaction records. The goal is to recommend ways to increase revenue. Exploratory analysis found that tobacco, food, and beverages are top sellers. Tobacco contributes most to revenue. Top items were identified in each category. Sales peak on weekends and evenings. Market basket analysis identified commonly purchased item pairs that could be bundled in combo offers. Recommendations include happy hour liquor deals, bundling less popular items, combo meal offers not including breakfast, discounted weekday prices, merchandise loyalty programs, more weekend staff, and buy-one-get-one beverage deals.

    Original Description:

    this is a case study on how to maximize cafe great revenue.

    Original Title

    MRA_Cafe

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The dataset is from a café chain transaction records. The goal is to recommend ways to increase revenue. Exploratory analysis found that tobacco, food, and beverages are top sellers. Tobacco contributes most to revenue. Top items were identified in each category. Sales peak on weekends and evenings. Market basket analysis identified commonly purchased item pairs that could be bundled in combo offers. Recommendations include happy hour liquor deals, bundling less popular items, combo meal offers not including breakfast, discounted weekday prices, merchandise loyalty programs, more weekend staff, and buy-one-get-one beverage deals.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    232 views13 pages

    Problem Statement and Dataset Details

    Uploaded by

    pratik yadav
    The dataset is from a café chain transaction records. The goal is to recommend ways to increase revenue. Exploratory analysis found that tobacco, food, and beverages are top sellers. Tobacco contributes most to revenue. Top items were identified in each category. Sales peak on weekends and evenings. Market basket analysis identified commonly purchased item pairs that could be bundled in combo offers. Recommendations include happy hour liquor deals, bundling less popular items, combo meal offers not including breakfast, discounted weekday prices, merchandise loyalty programs, more weekend staff, and buy-one-get-one beverage deals.

    Copyright:

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

    Problem Statement and Dataset Details

    Dataset : Café Great Transaction Dataset


    Recommend the Café chain Owner the point which can increase
    the revenue of his café chain.

    Approach

    Exploratory Analysis.
    Menu Analysis via Market Basket analysis.
    Recommendation.
    Data Exploration

    • Food, Beverage and Tobacco are highest selling item.


    • Tobacco contributes maximum to the Revenue.
    Data Exploration

    Top Items sold in Each Category


    Data Exploration
    Quarter Wise Category Sales

    • Tobacco leads in sales in every quarter.


    • Food and Beverage and are respectively second and third in sales.
    Data Exploration

    Day Wise Sales of Each Item.


    Specific Item Sold

    Other Item Sold


    Major Sales happened in Sat, Sun and Friday Sales in all the categories.
    Data Exploration

    Time Wise Sales of Each Item in a day


    • Tobacco Sells all time of the day.
    • Merchandise and Wines though they are on low sales but still they are being sold in small quantity all the day.
    • Food has major sales during night and late night hours.
    • Liquor has most sales during late night hours.
    Top Selling Menu items in each category(Some):

    • Carlsberg • Mocha Shake


    Liquor • Tuborg Food • Poutine with fries
    • Hoegaarden • Oreo Cookie Shake
    • Budweiser

    • Cappuccino
    Merchandise • Ch Tins Beverages • Lemon Iced Tea
    • Caffe Latte

    • Nirvana hookah
    single • VLN Cab Sauv
    Tobacco Wines
    • Sambuca • Red Sangria
    Menu items which can be removed as they are less in sales and don’t generate much revenue:

    • Whiskey(SM) • Mushroom and Corn


    Liquor • Stella Artois Food • Chicken Hum
    • White Rum • Toast Ciabata
    • Brooklyn

    • Cutting Glass • Mocafe Hot


    • Dip Bowl chocolate(SF)
    Merchandise Beverages
    • Mugs Plain Colour • Bottled Water
    • Mocha Mug single • 2 Axe Twist

    • Gold Flake Ultra • 4 Seasons CLAS


    Light(20) Sauv(gls)
    Tobacco Wines • B1G1 4 Seasons CLAS
    • Classics Regular
    • Classic Menthol SAUV(gls)
    • Manadala Valley
    Market Basket Analysis:

    Some Items Frequently bought together.


    After analysis we can suggest below items are best eligible for
    Combo packages.

    • Lemon Infused Char Grilled Veg and Add herb Roast Chicken.
    • Kheema Ghotala with toast Butter.
    • Caffe latte and Add Hazelnut flavor.
    • French Fries and B.M.T. Panini.
    • Saigon noodles with chicken.
    • Red Bull and Maggie noodles Arabiata.
    • Black Currant Iced Tea and Lemon Iced Tea.
    • Bun Maska and Chai and Masala Chai Cutting.
    • Cool California and Miami Melons.
    Recommendations:

    • Give happy Hours offer during daytime to increase revenue from Liquor category.
    • Tobacco is highest selling so we can give goodies of less selling products in combo with the tobacco
    products top up sales also minimizing wastage
    • Combine the food items in combo as shown in previous MBA give combo and zumbo combo offers.
    • Items doesn’t contain the breakfast items. We can include those items to run café full during those hours.
    It is really empty those hours.
    • During weekday sell the product on discounter price and get those money back in late hours of Weekends.
    • Combine merchandise items with other high selling products also can give merchandise as a membership
    or loyalty badge for customer.
    • Increase number of employees on weekends late hours to provide better service.
    • Combine Hookah with any ow selling items to top up there sales.
    • Give Buy one get one offers on Beverage items as many of them are frequently bought together.
    Thank You

    You might also like