Question

Problem Statement: An automobile parts manufacturing company has...

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 customer

Auto Sales Data:https://www.mediafire.com/file/hywf3ul59ah1ll4/Sales_Data.xlsx/file

• 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 4segments)
• 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
• 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 useany tool(Tableau or Python or KNIME)used in the DSBA program for this project.Its amustto share the code for reference