Over three decades of experience in delivering Data driven solutions across multiple industry sectors – Financial Services, Housing Associations, Heavy Engineering and Consultancy across many more. Very strong Technical, Data Analytics and Consultancy skills - Azure Analysis Services, Azure SQL Database/Data Warehouse, Azure Data Factory, Azure Runbooks, SQL, DAX, F#, C#, Python, R, Power BI, SSRS. Spent over two decades supporting the SQL Server community, blogging, presenting on many topics around SQL Server, Big Data and Analytics for which I received the Microsoft Most Valued Professional for SQL Server / Data Platform for 19 consecutive years. Founding member of SQL Bits, SQL Relay, UK SQL Server User Group and Developer Developer Developer. Most recently performing a multi-disciplined role at Clarion Housing Group as a Business Analyst, BI Developer, Team Leader, Trouble-shooter and Data Scientist.
Tony Rogerson's Sessions
Expose the power of Recency Frequency analytics to your data using SQLSQLBits 2010
The technique of Recency Frequency Intensity/Monetary is a powerful analytical technique for identifying data patterns as well as 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!