Skip to content

Latest commit

 

History

3 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 

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

0 stars

Watchers

1 watching

Forks

Releases

Packages

Contributors