Finding Islands, Gaps, and Clusters in Complex Data

Being able to group data into logical and meaningful sets can be extremely useful. When the data involved is a non-repeating sequence of integers, grouping is not too difficult. Most real data, though, is made up of dates, times, decimals, and rarely can guarantee non-repeating, non-null data sets.

This is a fast-paced session that delves into methods that can be applied to any data. Want to know how many production incidents make up a single common problem? Can we track sales success by the number of consecutive weeks that an agent has exceeded their goal? How about the longest home run streak hit by Derek Jeter at night games on Tuesdays?

Discussion will include performance, CTEs, recursion, set-based vs. iterative analysis, and some pretty hairy TSQL!

Edward Pollack

Data Architect | Microsoft Data Platform MVP

Albany, New York, United States


Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top