Skip to content

Analytical SQL Project where we had to analyze the dataset and come up with 5+ insights and divide the customers into segments using analytical functions.

Notifications You must be signed in to change notification settings

SandraMoses/RFM-Analysis-for-Customer-Segmentation

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 

Repository files navigation

RFM-Analysis-for-Customer-Segmentation

Analytical SQL Project where we had to analyze the dataset and come up with 5+ insights and divide the customers into segments using analytical functions.

Question 1: Insights

Story 1 --> Grand Total By Year

Story 2 --> Most Selling Product

Story 3 --> Top 5 paying Customers

Story 4 --> Group Data By Year and Quarter

Story 5 --> Rush Hour

Story 6 --> Running Totals in 2010

Story 7 --> Time Series Analysis

Question 2:

#sol 1: The Lazy way

#sol 2: Greater and Smaller than

Files contain:

1- The Database Schema

2- .sql file having all the queries

3- .pdf containing screenshots of the output

About

Analytical SQL Project where we had to analyze the dataset and come up with 5+ insights and divide the customers into segments using analytical functions.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published