Fill This Form To Receive Instant Help
Fill This Form To Receive Instant Help
Homework answers / question archive / An automobile parts manufacturing company has collected data of transactions for 3 years
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
ORDERNUMBER : Order Number CUSTOMERNAME : customer
QUANTITYORDERED : Quantity ordered PHONE : Phone of the customer
PRICEEACH : Price of Each item ADDRESSLINE1 : Address of customer
ORDERLINENUMBER : order line CITY : City of customer
SALES : Sales amount POSTALCODE : Postal Code of customer
ORDERDATE : Order Date COUNTRY : Country customer
DAYS_SINCE_LASTORDER : Days_ Since_Lastorder CONTACTLASTNAME : Contact person customer
STATUS : Status of order like Shipped or not CONTACTFIRSTNAME : Contact person customer
PRODUCTLINE : Product line – CATEGORY DEALSIZE : Size of the deal based on Quantity and Item Price
MSRP : Manufacturer's Suggested Retail Price
PRODUCTCODE : Code of Product
Data Dictionary:
This Milestone is of 45 marks and the marks distributions are as per rubric:
• Agenda & Executive Summary of the data
o Contents of the presentation
o Problem statement
o About Data (Info, Shape, Summary Stats, your assumptions about data)
• Exploratory Analysis and Inferences
o 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
o Summarize the inferences from the above analysis
• Customer Segmentation using RFM analysis (make 4 segments)
o What is RFM?
o What all parameters used and assumptions made
o Output table head
o When KNIME used, Workflow image to be put
• Inferences from RFM Analysis and identified segments
o Who are your best customers? (give at least 5)
o Which customers are on the verge of churning? (give at least 5)
o Who are your lost customers? (give at least 5)
o Who are your loyal customers? (give at least 5)
Minimum PPT Requirements:
• Minimum 14 Slides of PPT required:
o Minimum 8 slides on EDA and Inferences.
o Minimum 2 Slides on RFM analysis
o Minimum 4 slides on RFM inferences and identified segments
o Do not add code
o When you are using KNIME, adding KNIME Workflow is a must
o It is a must to add plots/graphs in the PPT itself
Already member? Sign In
