Slides and Code from SQLBits Recency Frequency talk by Tony Rogerson and Alison Coughtrie

tonyrogerson — Sat, 02 Oct 2010 11:01:00 GMT

Abstract:

The technique of Recency Frequency Intensity/Monetary is a powerful analytical technique for identifying data patterns and business performance. An introduction to the technique will be given, however the main focus of the session will be on demonstrating on how RFI/M can be performed using a number of SQL features such as Data Windowing, the OVER clause and PARTITION BY, CROSS APPLY and Common Table Expressions and how you can nest the table expressions. The session should be of benefit to both inexperienced and experienced SQL coders and analysts, each construct will be explained as well as the query plans produced. Demo's will be done on AdventureWorks which we actually discover is going out of business!

Feel free to email me with any quesitons, comments and suggestions - tonyrogerson@torver.net

http://sqlblogcasts.com/blogs/tonyrogerson/UKSSUG/RF_SQLBits2010%20-%20ACC%20and%20TR3.zip

Tony Rogerson's ramblings on SQL Server : Recency Frequency

Slides and Code from SQLBits Recency Frequency talk by Tony Rogerson and Alison Coughtrie