Exploring Data in SQL and Tableau | Cohort Retention Analysis | Data Analyst Projects | SQL Projects скачать в хорошем качестве

Exploring Data in SQL and Tableau | Cohort Retention Analysis | Data Analyst Projects | SQL Projects

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/AllThingsDataWithA... --LINK TO DATA SOURCE https://archive.ics.uci.edu/ml/datase... https://archive.ics.uci.edu/ml/machin... --LINK TO TABLEAU PUBLIC DOWNLOAD https://public.tableau.com/en-us/s/do... -LINKS TO PLAYLISTS- Learn SQL with Microsoft SQL Server:    • SQL   Data Analyst Portfolio Projects:    • Data Analyst Portfolio   HAPPY WITH THE CONTENT? SUBSCRIBE NOW! CLICK HERE -    / 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