Problem Statement: An automobile parts manufacturing company has collected data of transactions for 3 years. They do
Question:
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 can be downloaded below
https://docs.google.com/spreadsheets/d/1BZleidvtrEFier9BQTTXjRDgEPwPfCWt/edit?usp=sharing&ouid=107817545480483209913&rtpof=true&sd=true
Do the following in Python and TABLUAU and KNIME
1) Agenda & Executive Summary of the data -> Problem statement -> About Data (Info, Shape, Summary Stats, your assumptions about data)
2)Exploratory 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 inferences
3)Customer Segmentation using RFM analysis (4 segments) -> What is RFM? -> What all parameters used and assumptions made? ->As KNIME used, Workflow image to be put -> Output table head
4)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)
Please send me the Python , Tableau and KNIME files for this