Expose the power of Recency Frequency analytics to your data using SQL
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!
In the 24 years of his IT career Tony has had experience in a number of languages, first on the IBM mainframe with Application System, PL/1, CICS, DB2 and System W. In 1995 he moved to the Client/Server platform adding Visual Basic, C++ and Oracle to his experience; over the past 17 years beginning with 4.21 he has focused on Microsoft SQL Server. Today he works as a freelance database specialist and is studying for an MSc in Business Intelligence.