Homework answers / question archive / Problem Statement: An automobile parts manufacturing company has collected data of transactions for 3 years

Problem Statement: An automobile parts manufacturing company has collected data of transactions for 3 years

Marketing

Share With

Problem Statement:

An automobile parts manufacturing company has collected data of transactions for 3 years. They do not have any in-house data science team, thus they have hired you as their consultant. Your job is to use your magical data science skills to provide them with suitable insights about their data and their customers.

Auto Sales Data: Sales_Data.xlsx

Data Dictionary:

This Milestone is of 45 marks and the marks distributions are as per rubric:

• Agenda & Executive Summary of the data
  • Contents of the presentation
  • Problem statement
  • About Data (Info, Shape, Summary Stats, your assumptions about data)
• Exploratory Analysis and Inferences
  • Univariate, Bivariate, and multivariate analysis using data visualization
    • Weekly, Monthly, Quarterly, Yearly Trends in Sales
    • Sales Across different Categories of different features in the given data
  • Summarize the inferences from the above analysis
• Customer Segmentation using RFM analysis (make 4 segments)
  • Which tool used?
  • What all parameters used and assumptions made
  • Output table head 
  • If KNIME used, Workflow image to be put
• Inferences from RFM Analysis and identified segments
  • Who are your best customers? (give at least 5)
  • Which customers are on the verge of churning? (give at least 5)
  • Who are your lost customers? (give at least 5)
  • Who are your loyal customers? (give at least 5)

Minimum PPT Requirements:

• Minimum 14 Slides of PPT required:
  • Minimum 8 slides on EDA and Inferences.
  • Minimum 2 Slides on RFM analysis
  • Minimum 4 slides on RFM inferences and identified segments
  • Do not add code
  • If you are using KNIME, adding KNIME Workflow is a must
  • If python, please talk about the packages and functions used.
  • It is a must to add plots/graphs in the PPT itself

Please note the following:

• Your submission should include the following:
  • A PowerPoint Presentation (Deck of min 14 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) used in the DSBA program for this project. Its a must to share the code for reference

Scoring guide (Rubric) - MRA_Project_DSBA_Milestone_1 (1)