Scribd Logo
Upload

Welcome to Scribd!

  • 18 views

    Rajendra MRA Project Grocery

    Uploaded by

    Rajendra Ladda

    Copyright:

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

    Rajendra MRA Project Grocery

    Uploaded by

    Rajendra Ladda
    18 views12 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    Rajendra MRA Project Grocery

    Uploaded by

    Rajendra Ladda

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    of 12

    MRA Project

    Automobile Parts Company


    Rajendra Ladda
    PGDSBA
    Tableau Link:
    https://public.tableau.com/app/profile/rajendra.ladda/viz/MRAProjectGroceryStoreRajendraLadda/GroceryStoresMRA
    ProjectRajendraLadda?publish=yes
    Agenda

     Executive Summary
     Problem Statement
     Data Analysis Methodology
     Key Findings
     Customer Insights
     Marketing Strategy Recommendations
     Conclusion
    Executive Summary

     There are totally 20642 rows and 3 columns of the data


     There are 1139 unique transactions
     There are 37 unique products
     The data spans from January 2018 to February 2020 (26 months) out of which oct to dec data is
    missing in both the years.
     There are 533 unique transactions in 2018 (59 per month), 507 in 2019 (56 per month) and 99 in
    2020 (50 per month), which shows a clear downtrend in number of transactions
     The store needs to seriously introspect the reasons and come out with solutions as how to increase
    sales in upcoming months.
    Problem Statement

     A grocery store shared the transactional data. We have to


     Conduct a thorough analysis of Point of Sale (POS) data
     Identify the most commonly occurring sets of items in the customer orders
     Provide recommendations through which a grocery store can increase its revenue by
    popular combo offers & discounts for customers.
    EDA – Exploratory Data Analysis
    EDA - Products Sold (Highest and Lowest
    Sold)
    Quarter Top 1 Top 2 Top 3 Bottom 3 Bottom 2 Bottom 1
    Q1 2018 Bagels Cheeses Poultry Dinner Rolls Laundry Detergent Milk
    Q2 2018 Cereals Beef Pasta Flour Pork Dishwashing
    Liquid
    Q3 2018 Mixes Ketchup Flour Bagels Paper Towels Sandwich Loaves
    Overall 2018 Cereals Poultry Mixes Pork Paper Towels Sandwich Loaves
    Q1 2019 Dishwashing Milk Cheeses Tortillas Pasta Flour
    Liquid
    Q2 2019 Toilet Paper Dishwashing Yogurt Shampoo Hand soap Mixes
    Liquid

    Q3 2019 Lunch Meat Individual Meals Sugar Flour Toilet Paper Ketchup
    Overall 2019 Poultry Waffles Dishwashing Mixes Flour Hand soap
    Liquid
    Q1 2020 Poultry Dinner Rolls Pork Hand Soap Fruits Sugar
    Overall Data Poultry Ice Cream Cereals Flour Sandwich Loaves Hand Soap
    Period
    Trend
    Yearly Sales Transactions
    Product wise Sales Transactions
    Knime Work Flow
    Knime Grouped Data with Product List

    First Last Rows


    Rows
    Conclusion

     There is no specific product which is selling more or less in a particular period


     Top selling product in this period can be bottom selling product in next period
     There is a clear down trend in sales
     Because of absence of monetary data and customer identification it is not possible to
    conduct RFM analysis on this data

    You might also like