The 3 datasets attached from Sprocket Central Pty Ltd. :
Assess the quality of their data as well as make recommendations on ways to clean the underlying data and mitigate these issues.
Sprocket Central Pty Ltd has given us a new list of 1000 potential customers with their demographics and attributes. However, these customers do not have prior transaction history with the organisation. The marketing team at Sprocket Central Pty Ltd is sure that, if correctly analysed, the data would reveal useful customer insights which could help optimise resource allocation for targeted marketing. Hence, improve performance by focusing on high value customers. Using the existing 3 datasets (Customer demographic, customer address and transactions) as a labelled dataset, please recommend which of these 1000 new customers should be targeted to drive the most value for the organisation. stomers.)
What are the trends in the underlying data? Which customer segment has the highest customer value? What do you propose should be Sprocket Central Pty Ltd ’s marketing and growth strategy? What additional external datasets may be useful to obtain greater insights into customer preferences and propensity to purchase the products? Specifically, your presentation should specify who Sprocket Central Pty Ltd’s marketing team should be targeting out of the new 1000 customer list as well as the broader market segment to reach out to. Develop a dashboard that we can present to the client at our next meeting. Display your data summary and results of the analysis in a dashboard. (Applied Association Rule Mining techniques to study the behavior of past High Value customers and identify buying patterns for future recommendations and marketing strategy. Developed a dashboard on Tableau Desktop.) https://public.tableau.com/views/sprocketcentral_16726023205430/Dashboard1?:language=en-US&:display_count=n&:origin=viz_share_link