Problem Statement:A Grocery Store shared the transactional data with you. Your job is to identify...

Question

Problem Statement:A Grocery Store shared the transactional data with you. Your job is to identify the most popular combos that can be suggested to the Grocery Store chain after a thorough analysis...

1 answer below »

Problem Statement:

A Grocery Store shared the transactional data with you. Your job is to identify the most popular combos that can be suggested to the Grocery Store chain after a thorough analysis of the most commonly occurring sets of menu items in the customer orders. The Store doesn’t have any combo meals. Can you suggest the best combo meals?

Exploratory Analysis

Exploratory Analysis of data & an executive summary (in PPT) of your top findings, supported by graphs.

Are there trends across months/years/quarters/days etc. that you are able to notice?

Use of Market Basket Analysis (Association Rules)

Write Something about the association rules and their relevance in this case

Add KNIME workflow Image , as that is the only tool to be used for MBA.

Write about threshold values of Support and Confidence

Associations Identified

Put the associations in a tabular manner

Explain about support, confidence, & lift values that are calculated

A suggestion of Possible Combos with Lucrative Offers

Write recommendations

Make discount offers or combos (or buy two get one free) based on the associations and your experience

Tools to be used:

KNIME Analytics Platform or

Tableau or

Python or

Please note the following:

Your submission should include the following:
- A PowerPoint Presentation
  (Deck of min 15 slides) - You will be evaluated based upon this. (You can convert PPT to PDF, that is also acceptable)
- Supporting file-You can use
  any tool(Tableau or Python or KNIME) for EDA but MBA has to done only using KNIMEfor this project.Its a
  must
  to share the
  code/KNIME file/Tableau file
  for reference

Please ensure timely submission as a post-deadline assignment will not be accepted.

Please reflect on all that you have learned while working on thisproject. This step is critical in cementing all your concepts and closing the loop.

datasetgroup-hpkdv25w.csv

Answered 3 days After Dec 31, 2022

Sathishkumar · Accepted Answer

PowerPoint Presentation
AGENTA
Problem Statement:
You now have access to the Grocery Store's financial records. After doing in-depth research on the product combinations that appear most frequently in customer orders, it is your responsibility to establish which product combinations are the most popular so that you can provide recommendations to the chain of grocery shops. The Shop sells absolutely nothing. bargain packages or any other discounts including many items. Which discounts and packages do you think are the best?
Using market basket analysis, our mission is to research the rules of the association in order to come up with the most profitable combination of products and sales for the grocery store chain.
The csv file contains information that includes a Point of Sale column (POS).
Tools Used
Programming Language
Python 3 and above
Library Packages
Sci-Kit 
Matplotlib
Numpy
Pandas
About Dataset
No of transactions : 20682 
No of features : 3 
No missing values 
No duplicates
Data provided from Jan to Sep for 2 years (2018, 2019) and 2020 with 2 months(Jan and Feb) 
INFORMATION & ASSUMPTIONS
# of Unique Orders : (1 to 1139) 
# of Unique Products : 37 
# of Unique Dates : 603
INFORMATION & ASSUMPTIONS 
# of Unique Orders : (1 to 1139) 
# of Unique Products : 37 
# of Unique Dates : 603
Yearly Trend
Since the data for the year 2020 only includes two months, the count of orders for that year is quite low. The year 2018 had the highest number of orders,

Problem Statement:A Grocery Store shared the transactional data with you. Your job is to identify the most popular combos that can be suggested to the Grocery Store chain after a thorough analysis...

Problem Statement:

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment