Sprocket Central Data Quality and Insights Analysis

This project contains a comprehensive data quality assessment on three key datasets from Sprocket Central Pty Ltd: Customer Demographic, Customer Address, and Transactions. The primary goal was to ensure the integrity of the data for accurate analysis and strategic decision-making. Subsequently, valuable insights were extracted from the assessed data, and these insights were applied to a new customer dataset to identify high-potential customers for targeted marketing efforts.

• Conducted a comprehensive data quality assessment on three key datasets from Sprocket Central Pty Ltd: Customer Demographic, Customer Address, and Transactions.

• Addressed various challenges in the datasets including missing values, inconsistent labels, and unrealistic records.

• Standardized inconsistent labels across datasets for consistency.

• Implemented imputation strategies for missing data, using statistical methods like median for numerical fields.

• Rectified date formats and removed entries that could not be standardized or imputed, ensuring data relevancy and accuracy.

• Developed a customer scoring system based on historical data to evaluate the potential value of new customers.

• Included factors such as purchase frequency, property valuation, geographic location, age, wealth segment, and industry in the scoring model.

• Applied the scoring system to a new customer list, ranking individuals by potential value to target marketing efforts efficiently.

• Identified a segment of high-potential customers, characterized by frequent purchases, residence in high-revenue areas, older age demographics, and employment in profitable industries.

• The analysis concluded with strategic recommendations for Sprocket Central Pty Ltd to focus marketing initiatives on the identified high-value customer profiles to drive growth.