Creating Association Rules using the SQL Server Data Mining Addin for Excel

preview_player
Показать описание
Association Rules are a quick and simple technique to identify groupings of products that are often sold together. This makes them useful for identifying products that could be grouped together in cross-sell campaigns. Association rules are also known as Market Basket Analysis, as they used to analyse a virtual shopping baskets.

In this tutorial I will demonstrate how to create association rules with the Excel data mining addin that allows you to leverage the predictive modelling algorithms within SQL Server Analysis Services.

Sample files that allow you follow along with the tutorial are available from my website at

  1. Analyse US
  2. Data Mining (Technology Class)
  3. Association Rule Learning
  4. Microsoft Excel (Software)
  5. Technology (Professional Field)
Рекомендации по теме
Creating Association Rules 0:06:16

Creating Association Rules using the SQL Server Data Mining Addin for Excel

#2 Solved Example 0:12:02

#2 Solved Example Apriori Algorithm to find Strong Association Rules Data Mining Machine Learning

RapidMiner Tutorial - 0:16:00

RapidMiner Tutorial - How to create association rules for cross-selling or up-selling

Apriori Algorithm Explained 0:18:27

Apriori Algorithm Explained | Association Rule Mining | Finding Frequent Itemset | Edureka

Generating Association Rules 0:04:15

Generating Association Rules using Apriori algorithm

Mastering Association Rule 0:05:57

Mastering Association Rule Learning in R with the Apriori Algorithm

Association Rules with 0:05:22

Association Rules with RapidMiner

#1 Solved Example 0:11:23

#1 Solved Example Apriori Algorithm to find Strong Association Rules Data Mining Machine Learning

42 : Association 0:08:37

42 : Association Rules

Finding association rules 0:07:46

Finding association rules using WEKA.

#12 Mining Various 0:08:25

#12 Mining Various Kinds Of Association Rules |DM|

3. Apriori Algorithm 0:14:25

3. Apriori Algorithm | Association Rule Mining | Frequent Item Sets Solved Example by Mahesh Huddar

1. Association Rule 0:17:08

1. Association Rule Mining – Apriori Algorithm - Numerical Example Solved by Mahesh Huddar

How to use 0:11:56

How to use Apriori Algorithm to find the Association Rules Mining Hot Dog Ketchup Coke Chips Mahesh

Association Rules Step 0:57:13

Association Rules Step by Step using T-SQL, R, Python, Azure ML, and SSAS

Association Rules Fundamentals 0:09:20

Association Rules Fundamentals

Determine 'Next Best 0:03:54

Determine 'Next Best Offer' Product Recommendations using Association Rules

Recommendation System using 0:11:55

Recommendation System using Python| Association Metrics| Association Rules

Unsupervised Learning - 0:05:51

Unsupervised Learning - Association Rules Using XLMiner

Association Rules Analysis 0:15:04

Association Rules Analysis with Rapid Miner (Altair AI Studio)

Data Science using 0:13:37

Data Science using Python -- Association Rule Mining (Demo using mlxtend)

Generating Association Rules 0:02:49

Generating Association Rules from Frequent Itemsets - Frequent Pattern Mining

Experiment Set 3: 0:04:15

Experiment Set 3: Generate Association Rules from the Full Data

Generating Association rules 0:06:54

Generating Association rules