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 : • 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
На этой странице сайта вы можете посмотреть видео онлайн KPMG | VIRTUAL INTERNSHIP MODULE 2 | SOLUTION - DATA INSIGHT длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Ronit Malik 05 Январь 2021, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 57,942 раз и оно понравилось 597 зрителям. Приятного просмотра!
