Exploring Sales Data in SQL and Tableau | RFM Analysis in SQL | Data Analyst Projects | SQL Projects

In this video, we explore a sales dataset and generate various analytics and insights from customers' past purchase behavior. We go from analyzing 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


-LINK TO SQL QUERY-
https://github.com/AllThingsDataWithA...

--LINK TO DATA SOURCE
https://github.com/AllThingsDataWithA...


-LINKS TO PLAYLISTS-
Data Analyst Portfolio Series:    • Data Analyst Portfolio  

Learn SQL with Microsoft SQL Server:    • SQL  


-LINKS TO TABLEAU DASHBOARDS-
https://public.tableau.com/app/profil...

https://public.tableau.com/app/profil...


HAPPY WITH THE CONTENT?
SUBSCRIBE NOW! CLICK HERE -    / angelinafrimpong  
OR HERE - https://bit.ly/angelinafrimpong


Video Timestamp
00:00:00 Intro
00:00:25 Resources Needed - Data
00:00:53 Resources Needed - Tableau
00:01:41 Resources Needed - SQL
00:02:43 Import File to Database
00:04:10 Inspecting Imported Data
00:05:43 Checking Distinct Values
00:07:41 Analysis 1 - Sales by Product Line
00:08:59 Analysis 2 - Sales by Year
00:10:45 Analysis 3 - Sales by DealSize
00:11:18 Analysis 4 - Best Month for Sales per Year
00:13:21 Analysis 5 - What Product Line Sells Most in Best Month
00:14:31 RFM Explanation
00:16:21 Analysis 6 - Who is the Best Customer
00:30:07 Analysis 7 - What Product Codes sell together
00:42:02 Importing Data in Tableau
00:43:40 Building Worksheets
00:59:30 Building Dashboards
01:03:41 Saving Dashboards to Tableau Public
01:05:13 Outro


#SQLProjects #RFMAnalysis #DataAnalyst