RFM Analysis - Customer Segmentation using AWS s3, Glue and Athena | Data Analytics Projects 2023

preview_player
Показать описание
Hey Data Elites,

Welcome Back! Here is a continuation of the previous video on Getting Started with AWS Analytics tools - S3 | Data Analytics Projects. The project includes all the cloud services you'll need to manage, store, and analyze your data. As we develop our customer classification system with SQL, we will work with customer order data in order to categorize our customers based on their RFM Status. It's Beginner Friendly, so if you're just starting out, I recommend working on it and getting familiar with AWS.

Timestamp:
0:00 Intro
1:30 RFM
3:30 Creating a table and database in AWS Athena
8:55 Inspecting the data
11:00 Analyzing Sales by Customer, Year and Orders
14:45 Introduction to CTEs in SQL
14:47 Define RFM Status
17:20 Introduction to SQL Subquery
20:45 Converting a String data to Date in Athena
24:24 Introduction to NTILE in SQL

LET'S BE FRIENDS

#dataanalytics #aws #cloudcomputing
Рекомендации по теме
Комментарии
Автор

Thanks your video always make data analyst learning 😍easy a bit

marianemuakpor
join shbcf.ru