QuestionProblem 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.xlsxData Dictionary:ORDERNUMBER :Order NumberCUSTOMERNAME :customerQUANTITYORDERED :Quantity orderedPHONE :Phone of the customerPRICEEACH :Price of Each itemADDRESSLINE1 :Address of customerORDERLINENUMBER :order lineCITY :City of customerSALES :Sales amountPOSTALCODE :Postal Code of customerORDERDATE :Order DateCOUNTRY :Country customerDAYS_SINCE_LASTORDER :Days_ Since_LastorderCONTACTLASTNAME :Contact person customerSTATUS :Status of order like Shipped or notCONTACTFIRSTNAME :Contact person customerPRODUCTLINE :Product line – CATEGORYDEALSIZE :Size of the deal based on Quantity and Item PriceMSRP :Manufacturer’s Suggested RetailPricePRODUCTCODE :Code of ProductThis Milestone is of 45 marks and the marks distributions are as per rubric:Agenda & Executive Summary of the dataContents of the presentationProblem statementAbout Data (Info, Shape, Summary Stats, your assumptions about data)Exploratory Analysis and InferencesUnivariate, Bivariate, and multivariate analysis using data visualizationWeekly, Monthly, Quarterly, Yearly Trends in SalesSales Across different Categories of different features in the given dataSummarize the inferences from the above analysisCustomer Segmentation using RFM analysis (make 4 segments)Which tool used?What all parameters used and assumptions madeOutput table headIf KNIME used, Workflow image to be putInferences from RFM Analysis and identified segmentsWho 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 analysisMinimum 4 slides on RFM inferences and identified segmentsDo not add codeIf you are using KNIME, adding KNIME Workflow is a mustIf python, please talk about the packages and functions used.It is a must to add plots/graphs in the PPT itselfPlease 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 referencePlease 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. Please write down your thoughtshereThanksProgram OfficeScoring guide (Rubric) – MRA_Project_DSBA_Milestone_1 (1) (1)CriteriaPointsAgenda & Executive Summary of the data -> Contents of the ppt -> Problem statement -> About Data (Info, Shape, Summary Stats, your assumptions about data)5Exploratory Analysis and Inferences -> Univariate, Bivariate, and multivariate analysis using data visualization (Weekly, Monthly, Quarterly, Yearly Trends in Sales and Sales Across different Categories of different features in the given data) -> Summarise the inferences12Customer Segmentation using RFM analysis (4 segments) -> Which tool used? -> What all parameters used and assumptions made? ->If KNIME used, Workflow image to be put -> Output table head11Inferences 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)12.5Quality of Submission PPT/PDF Report (Please refer to the Evaluation Guidelines for Business report checklist. Marks in this criteria are at the moderator’s discretion)BusinessManagementProject Management
