Skip to content

A project using SQL that centers around implementing the RFM analysis model to extract valuable insights from a sales dataset.

Notifications You must be signed in to change notification settings

basel-ay/Sales-RFM-Analysis-with-SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 

Repository files navigation

Sales-RFM-Analysis-with-SQL

What is RFM stands for?

Stands for Recency - Frequency - Monetary Value. Theoretically, we will have segments like the below:

image

  • Low Value: Customers who are less active than others, not very frequent buyer/visitor, and generate very low - zero - maybe negative revenue.

  • Mid Value: In the middle of everything. Often using our platform (but not as much as our High Values), fairly frequently and generates moderate revenue.

  • High Value: The group we don’t want to lose. High Revenue, Frequency, and low Inactivity.

image

image

Result:

image

Segmenting customers based on the RFM scores:

image

image

Detecting products that are most often sold together:

image

image

About

A project using SQL that centers around implementing the RFM analysis model to extract valuable insights from a sales dataset.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published