KPMG | VIRTUAL INTERNSHIP MODULE 2 | SOLUTION - DATA INSIGHT

Publicado el: 05 enero 2021
en el canal de: Ronit Malik

57,942

597

#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

En esta página del sitio puede ver el video en línea KPMG | VIRTUAL INTERNSHIP MODULE 2 | SOLUTION - DATA INSIGHT de Duración hora minuto segunda en buena calidad , que subió el usuario Ronit Malik 05 enero 2021, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 57,942 veces y le gustó 597 a los espectadores. Disfruta viendo!

266