In this video, we explore an online retail dataset and create a retention cohort analysis in SQL and Tableau. This is a hands-on video and w work on the following skills in this video:
• Understand what is cohort and cohort analysis
• Handling missing values
• Month extraction from date
• Assign cohort to each transaction
• Assigning cohort Index to each transaction
• Create cohort table for retention rate
• Visualize the cohort table using Tableau
• Interpret the retention rate
--LINK TO SQL QUERY--
--LINK TO DATA SOURCE
--LINK TO TABLEAU PUBLIC DOWNLOAD
--LINKS TO PLAYLISTS--
HAPPY WITH THE CONTENT?
Video Timestamps:
00:00 Intro
01:15 Getting Data
02:23 Importing Data
08:56 Cleaning Data in SQL
19:28 Begin Cohort Analysis
19:40 Discuss Data Required for Cohort Analysis
21:19 Create Cohort Group
24:00 Why Cohort Analysis
26:11 Create Cohort Index
36:35 Extract Data for Tableau
37:23 Group Customers By Cohort Index
39:02 Create Cohort Table
43:33 Create Cohort Retention Rate in SQL
48:36 Downloading Tableau Public
49:28 Creating Cohort Retention Rate Dashboard
58:42 Outro
#SQLProjects #CohortAnalysis #DataAnalyst