2019 – Enhancing Data Transformation with Analytic Functions

Presentation Summary

Analytic Functions are a powerful tool for transforming data. They have three major advantages over other methods. First, they are typically much faster than self-joins if you need to display detailed data together with aggregate data on the same row—for example a student’s current credits attempted with their cumulative or rolling credits attempted. Second, the use of custom partitions allows the inclusion of multiple levels of detail on the same row. A student’s credits can be displayed beside others in their major or cohort. Third, the windowing functionality allows very precise control over the rows used in an aggregation.

Presentation Speaker(s)

Jonathan Havey, University at Buffalo

Presentation Files

No files for this presentation