KPMG | VIRTUAL INTERNSHIP MODULE 2 | SOLUTION - DATA INSIGHT

#KPMG #VirtualInternship #Students #University This Video is a continuation from the previous video which was task 1 of the KPMG virtual internship. This Video focuses on the 2nd part of the virtual internship where I do a walk-through for data insights: Link For The First Video: KPMG Part 1 : https://www.youtube.com/watch?v=1TzlvFWVlZo&t=712s TimeStamps: 00:00 - Intro 00:47 - Task Requirements 02:21 - Picking up from task 1 dataset 03:13 - Feature Construction 1 - Age 03:38 - Feature Construction 2 - Profit 04:52 - Merging the worksheets using primary key 05:39 - Lookup Function to Merge worksheets 07:48 - Conducting a RFM Analysis (Recency, Frequency & Monetary) 08:54 - Feature Construction 3 - Recency 10:15 - Creating Pivot Table for RFM Analysis 13:33 - Creating IFS Statement for further analysis of RFM 16:54 - Customer Profile & RFM Value Visualisations 17:30 - Creating Pivot Table for Age Clusters & Profitability 19:49 - Creating Pivot Table for Car owned in different states 20:11 - Creating Pivot Table for Bike Related Purchases & Indsutry 20:34 - Creating Pivot Table for Profit & Industry 21:02 - Outro & Next Steps I would love to hear back from you, do leave a comment down below and let me know what you think of the video. Socials: Medium - https://ronit-malik.medium.com/ Linkedin - https://www.linkedin.com/in/ronitmalik/