🌄 RFM Analysis

✉️ Email: [email protected]

🔗 LinkedIn: linkedin.com/in/tahsinayman | 🐙 GitHub: github.com/TahsinAyman

---

• Overview
• Tools Used
• Files
• How to Run
• Table Structure
• End Result

🚀 Overview

This project involves customer segmentation using RFM (Recency Frequency Monetary) Segmentation in SQL

💼 Tools Used

🛰️ Files

• data.csv - used as primary source of data in table (used bulk insertion)
• table.sql - used to create database and tables necessary
• eda.sql - used for exploratory data analysis
• rfm_segmentation.sql - used to create view with RFM Segmented customer and their rfm score
• rfm_report.sql - used to create rfm report where the amount of customer of each category queried.
• main.sql - used to run operations

How to Run 👈

• Clone the repository using

  git clone https://github.com/TahsinAyman/supermarket_rfm_analysis.git

• Under a stable MySQL connection run table.sql
• From data.csv file import all the data using MySQL Workbench or Data grip
• To get a grasp of the data run eda.sql (Optional)
• Run rfm_segmentation.sql and rfm_report.sql sequentially.
• Run the main.sql to see report or the RFM score

🔥 Table Structure

🔥 End Result