Cohort Retention Analysis

In this project I work with Microsoft SQL Server to clean and extract customer data and visualize with Tableau to find the cohort retention rates for an online retail business. Below, you will see the SQL codes with explanatory comments and the final Tableau Visualization.

SQL code

To begin, I loaded my data into SQL Server with SQL Server Management Studio (SSMS) and performed the following operations to arrive at the data needed to create the cohort retention visualization with Tableau

Final Data

Snapshot of final data after performing SQL operations

Tableau Visualization