Exploring Sales Data in SQL and Tableau | RFM Analysis in SQL | Data Analyst Projects | SQL Projects скачать в хорошем качестве

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