Episode

How to Create Operational Analytics with Window Functions in Azure SQL - Part 3

Data Exposed

Running complex aggregations and analytical functions on real-time operational databases is a powerful capability in Azure SQL. In the last part of this three-part series with Silvano Coriani, we will see how Window Functions can be a great tool to express analytical calculations on real-time data sets.
 
[01:30]​ Operational Analytics: what kind of analytics?
[03:12]​ A Common Business Scenario
[05:10]​ Old school
[06:22]​ Performance with self-join and subqueries
[06:42]​ New school
[08:01]​ Performance with Window Functions
[08:50]​ Demo: Performance with Window Functions
[13:18]​ Window Functions capabilities
[14:54]​ Getting started