#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 : • HOW TO GET A TECH INTERNSHIP IN COMPANIES ...
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 - / ronit-malik
Linkedin - / ronitmalik
Nesta página do site você pode assistir ao vídeo on-line KPMG | VIRTUAL INTERNSHIP MODULE 2 | SOLUTION - DATA INSIGHT duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Ronit Malik 05 Janeiro 2021, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 57,942 vezes e gostou 597 espectadores. Boa visualização!