Association Rules Step by Step

Learn how to recognize good products, products which raise the sales of other products, and toxic products, products which are usually sold alone or are the last product in the basket, thus finishing the shopping.

Market basket analysis with T-SQL, R, Python, Azure ML and SSAS. You will learn how to recognize good products, products which raise the sales of other products, and toxic products, products which are usually sold alone or are the last product in the basket, thus finishing the shopping. Measures like support, confidence and lift, are explained in details. Sequential basket analysis is covered as well. Demos are developed step by step in T-SQL, in order to show how the calculations are made. Then you will see demos also in other languages and on other platforms.

Speaker

Dejan Sarka's Sessions

Association Rules Step by Step

Associations between Pairs of Variables

Text Mining with T-SQL

Statistical Analysis in T-SQL

Data Overview and Manipulation - T-SQL, R, Python

Temporal Data in SQL Server

Using R in SQL Server 2016 Database Engine and SSRS

Analysing Text with SQL Server 2014

Optimizing Temporal Queries

Excel 2013 Analytics

A Deep Dive in SQL Server 2012 Data Warehousing