We go from analysing sales revenue to creating a customer segmentation analysis using the
RFM technique. We go from basic SQL queries to exploring complex problems using SUB
QUERY, CTEs, AGGREGATE, and WINDOW functions. We work on the following skills in
this video:
- Importing a file into SQL Server Database
- SQL Aggregate Functions
- SQL Window Functions
- SQL Sub Query
- Common Table Expressions (CTEs)
- SQL XML Path Function
- Tableau
we explore a sales dataset and generate various analytics and insights from customers' past
purchase behavior.
RFM analysis is a data driven customer behavior segmentation technique. RFM stands for
recency, frequency, and monetary value. The idea is to segment customers based on when
their last purchase was, how often they've purchased in the past, and how much they've
spent overall.