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--

--LINK TO DATA SOURCE

--LINKS TO PLAYLISTS--

--LINKS TO TABLEAU DASHBOARDS--

HAPPY WITH THE CONTENT?

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

[mensamapees]

Please do more videos, I just can't stop watching them. I'm really learning a lot from you. Thank you

[AliceShisori]

I honestly like how you clearly show how you do each step and process your thoughts on it.
Thank you Angelina!

[danielpanda]

Amazing work! this is helping me a lot to understand how to get valuable insights for my portfolio projects, keep up with these great tutorials!

[franciscoloncq]

Awesome work! There are not that many porftolio projects so complete and well explained as this one! Thanks so much for sharing it!

[victor_peral]

You are a gem, I have done all your projects. It has given me more competence, insights and confidence. The intuitive insights on handling data you bring is top level. Thank you so much. Please help us with resume insights for data analyst jobs

[dnyaneshwar]

One week back I requested you to make video on Sales analysis & you did it. The way you explained everything in video much appreciated. 👍👍❤️❤️✌️✌️

[xdcxslayergaming]

You're fantastic with data. Thank you for the clear walkthrough!

[newworldcurator]

This is the first real-world analysis. The best way to learn. I wil be checking the rest of your projects. Thank you so much for sharing adn educating.

[Numbermind]

I usually don't comment on videos but this one deserves it. Really good job! You deserve way more views and subscribers.

[opeyemiadeyemi]

This video is very helpful, particularly the rfm analysis. Thank you very much.

[Jsola]

I’m only 20 mins in, and so far this is fantastic. Thank you so much

[fabscocoa]

You are a true blessing! I wish you the best of the best.

[Dare_to_dream_s]

Hey i am from india, i love this video thankyou soo muchh for such video i recommend you to make more more videos like this

[IgliFerati]

Amazing work. I just finished my SQL course and also i am following Google Analytics, and really you video step by step made me make my first project. Thank you very much :)

[ameenabdulbarr]

Wow, just wonderful, really grateful for such an opportunity. Thanks so much.

[edwarda.]

Thank you so much Angelina. I needed a mentor and I think I found one. Your explanations are clearly understandable and easy to follow. Glad I stumbled on your channel.

[godfredgyamfi]

Great work ! please do more videos like this, and more often

[효캉]

This content is absolutely perfect and I really appreciate your effort on making this good-quality video!

[lollar]

Fantastic video! Advanced SQL techniques. It was great to follow along!

[RajendraPatel.]

Hi Angelina, Easy, smooth & super awesome Data Analytics & Dashboard. "Subscribed to you" :) Keep up good work.!