top of page

Portfolios 

Optimizing the quality of customer datasets

Background information about the task

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. 
 

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. 
 

However, in order to support the analysis, you speak to the Associate Director for some ideas and she advised that “the importance of optimising the quality of customer datasets cannot be underestimated. The better the quality of the dataset, the better chance you will be able to use it drive company growth.”

 
The Task
  1. Assessment of data quality and completeness for preparation for analysis

  2. Targeting high value customers based on their demographics and attributes

  3. Using visualizations to present insights

Skills and Techniques
  • Data Quality Framework Table

  • RFM Analysis

  • Computer skills: PowerPoint, Excel.

Data Exploration
Interprtation
Target Customer Background

© 2023 by Actor & Model. Proudly created with Wix.com

bottom of page