Overview
The KPMG Data Analytics Virtual Internship is an online program designed to gain practical insight into what KPMG work is all about. This program enables applicants to build real skills from working on data quality assessment, data insights and data insights and presentation to leverage career skills and experience.
Task Module
Task 1: Data Quality Assessment
Assessment of data quality and completeness in prepareation for analysis. The task was to take a look at the given datasets provided by Sproket Central Ply Ltd and identify all data quality issues. Data cleaning and imputation was done by using Python programming language. View task 1 here.
Task 2: Data Insight
The objective of task 2 was to target high-value customers based on customer demographic and attributes. Used the RFM (Recency, Frequency and Monetary) method and the Quartile concept in Statistics to segment the customers into 4 groups (Platinum, Gold, Silver and Bronze). Supposed that Platinum and Gold customers are ones to be targeted, used machine learining models to train and predict who should be targeted in the new dataset (accuracy score 84%). View task 2 here.
Task 3: Data Insight and Presentation
Used visualization to present insights. Developed a report that displayed data summaries and results of the analysis in a dashboard. View task 3 here.