Customer Analytics Segmentation And Retention

SQL Server | Tableau | Customer Analytics | Retention Analysis

Project Overview

This project analyzes customer behavior, segmentation, customer value, churn risk and retention using SQL Server conected with Tableau.

SQL Server was used to clean and prepare the customer data, create analytical views and build the dataset used in the Tableau dashboards.

The analysis looks at (8,000) customers who made (132,362) orders and spent a total of ($12,465,161) and overall (8.94%) churn rate.

For full discription include (Executive Summary - Business Problem - Skills And Methodology - Results - Strategic Recommendations - Next Steps)

Please check my Readme Page GitHub

SQL Server • Tableau • Views • Data Clinging

Interactive Tableau Dashboard

Open Tableau Dashboard ↗

Project Screenshots

Explore the dashboard pages and SQL analysis screenshots below. Select any image to open the original screenshot in a new tab.

Overview Page 1
01 — Overview Page 1
Overview Page 2
02 — Overview Page 2
Executive Customer
03 — Executive Customer
Customer Behavior
04 — Customer Behavior
Churn
05 — Churn
At Risk
06 — At Risk
Screenshot (273)
07 — SQL View Created 1
Screenshot (270)
08 — View Created Measure 1
Screenshot (271)
09 —View Created Measure 2
Second View Created
10 — Second View Created

Project Walkthrough

A short video explaining the business problem, data preparation, analysis and dashboard results will be added here.

▶

Project Walkthrough — Coming Soon

Video walkthrough will be available here in a future update.

← Back to Portfolio