This online program gives similar work experince that employees do at KPMG. We learn what it is like working at one of the world’s best data analytics team, and build skills required to excel as a analytics consultant.
Sprocket Central Pty Ltd , a medium size bikes & cycling accessories organisation, has approached KPMG’s Lighthouse & Innovation Team. Sprocket Central Pty Ltd is keen to learn more about KPMG’s expertise in its Analytics, Information & Modelling team. 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.
The client provided KPMG with 3 datasets:
- Customer Demographic
- Customer Addresses
- Transactions data in the past 3 months
We performed the preliminary data exploration and identify ways to improve the quality of Sprocket Central Pty Ltd’s data.
- In building this recommendation, we started with a PowerPoint presentation which outlined the approach which we will be taking.
- The client has agreed on a 3 week scope with the following 3 phases as follows - Data Exploration; Model Development and Interpretation.
- Prepared a detailed approach for completing the analysis including activities – i.e. understanding the data distributions, feature engineering, data transformations, modelling, results interpretation and reporting.
Developed a dashboard using PowerBI that displays the data summary and results of the analysis. Some of the focussed business context when presenting findings were:
- 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?