Analytics in Action

Archive for July, 2013

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

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

Creating Subqueries in Microsoft SQL Server (T_SQL)

Transact SQL allows you to nest queries within queries. The inner query is known as a subquery, and this is used as an input for the outer query. Unlike queries that use constants, the results of a subquery can change...

Logical Query Processing in SQL Server

SQL Server processes code in a sequence which is known as the Logical Query Processing order. In a typical query, the logical processing order is : FROM -> WHERE -> GROUP BY -> HAVING -> SELECT ->ORDER BY. Each step...