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--
https://github.com/AllThingsDataWithAngelina/Data-Analyst-Projects/blob/main/cohort_rentention_analysis.sql
--LINK TO DATA SOURCE
https://archive.ics.uci.edu/ml/datasets/Online+Retail
https://archive.ics.uci.edu/ml/machine-learning-databases/00352/
--LINK TO TABLEAU PUBLIC DOWNLOAD
https://public.tableau.com/en-us/s/download
--LINKS TO PLAYLISTS--
Learn SQL with Microsoft SQL Server: https://youtube.com/playlist?list=PL3QIj0dCAeARFktUaoy1I4C3qvpeptSjK
Data Analyst Portfolio Projects: https://youtube.com/playlist?list=PL3QIj0dCAeARnHKdYGIEQ--mFFlSb0FNL
HAPPY WITH THE CONTENT?
SUBSCRIBE NOW! CLICK HERE - https://www.youtube.com/c/AngelinaFrimpong
OR HERE - https://bit.ly/angelinafrimpong
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
