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
In questa pagina del sito puoi guardare il video online KPMG | VIRTUAL INTERNSHIP MODULE 2 | SOLUTION - DATA INSIGHT della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Ronit Malik 05 gennaio 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 57,942 volte e gli è piaciuto 597 spettatori. Buona visione!
