Скачать или смотреть How to perform Product Association using SQL | Market Basket Analysis | Affinity Grouping | SQL

Product Association using SQL, meaning what products are often soled together. This technique is also known as the Market Basket Analysis or affinity grouping. It helps us correlate the events in our data. We will use this method to see what products are often sold together at AdventureWorks. This method is used by Amazon & Netflix to recommend other related products to their customers. Although, they use advance recommendation engines. But the base concept is the same.
This technique is commonly used on e-commerce sites to recommend related products to customers.

We will use AdventureWorks database to carry out this exercise. If you would like to setup a SQL environment then watch the following video:    • Install SQL Server Express 2019 Step by St...  

Link to GitHub repo: https://github.com/hnawaz007/pythonda...

Subscribe to our channel:
   / haqnawaz  

---------------------------------------------
Follow me on social media!

Github: https://github.com/hnawaz007
Instagram:   / bi_insights_inc  
LinkedIn:   / haq-nawaz  
Website: https://hnawaz007.github.io/

---------------------------------------------

#sqlserver #marketbasket #sqlqueries

Topics covered in this video:
0:00 - Introduction Product Association
1:29 - AdventureWorks Tables ERD
1:41 - Select Database
1:51 - Common Table Expression (CTE)
2:53 - SQL JOIN
3:15 - Using CTE
4:01 - Self JOIN
4:48 - Production Association Result set