Sprocket Central Pty Ltd Data analysis

Sprocket Central Pty Ltd , a medium size bikes & cycling accessories organisation, has approached Tony Smith (Partner) in KPMG’s Lighthouse & Innovation Team. Sprocket Central Pty Ltd is keen to learn more about KPMG’s expertise in its Analytics, Information & Modelling team.

Smith discusses KPMG’s expertise in this space . In particular, he speaks about how the team can effectively analyse the datasets to help Sprocket Central Pty Ltd grow its business.

Primarily, Sprocket Central Pty Ltd needs help with its customer and transactions data. The organisation has a large dataset relating to its customers, but their team is unsure how to effectively analyse it to help optimise its marketing strategy.

As the data analyst I was tasked to complete this project in 3 parts

1. To take a look at the following datasets provided by Sprocket Central Pty Ltd and identify all data quality issues.
2. Create a PowerPoint presentation which outlines the approach that will be taken to identify which of the 1000 customers Sprocket Central Pty Ltd should target, based on this dataset. Using these three phases: Data Exploration; Model Development and Interpretation.
3. Develop a dashboard that can be presented to the client at our next meeting. Specifically, the presentation should specify who Sprocket Central Pty Ltd' should be targeting out of the new 1000 customer list.