Details

What You're Missing If You Aren't Using SQL Windowing Functions

Speaker: Steve Moss

Duration: 75

Track: BI Platform Architecture, Development & Administration

We’ll explain and demo techniques you are missing out on that you can use to solve difficult sql problems using sql windowing functions including: - Determining how many stops a sport-band user made during a day and how long their average stop was, adjusting for altitude and position using both windowing functions and sql spatial functions. - Merging separate fiscal calendars with differing periods and different granularities (month vs. day, etc.) - Finding equivalent fiscal days or calendar days in previous or future years - Calculating percentiles on data to be used for Analytic tools and more! 


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids