Andrea Martorana Tusa

Andrea Martorana Tusa

Microsoft MVP Data Platform. BI Front-End engineer in Pandora. Contributing to establish a data-driven culture, through the adoption of a new data architecture. Admin of the company's Power BI tenant with duties of governance, monitoring and auditing. Product Owner for the common Content Management platform built on Sharepoint Solution Owner for the Data Analytics and Identity Access Management Azure platform. Common speaker in events and conferences around Europe (SQL Saturdays, PASS Summit, SQL Nexus, Intelligent Cloud, SQL Konferenz, SQL Day Poland, dataMinds Connect, Power BI Summit, Power Platform Bootcamp, etc). Speaker for DW/BI and the Italian Virtual Chapter. Author for sqlservercentral.com, sqlshack.com, UGISS (User Group Italiano SQL Server).

Title
MVP Data Platform - BI Front-end Engineer at Pandora

Sessions

(Login to save favorite sessions)

Temporal tables in SQL Server: practical usage scenarios

Temporal tables were introduced in SQL Server 2016 as a feature for providing information about the data that was stored at any point in time, rather than just the current record. Using temporal tables is it possible to track all the changes occurred to the records, making it easy to "travel into the time" to figure out what has changed, when and why. During the session will be discussed some of the most common business scenarios for the introduction of temporal tables. All cases are based on real implementation to customers and on the experience gained on the field: - Data audit. What has changed and when. - Point in time analysis. Check the history of changes over the time. - Warehouse inventory stock. Review fluctuation for product quantity. - Anomaly Detection. Detect anomalies and identify trends. - Slowly changing dimension. Query valid data for a specified period of time - Reproduce financial reports invoices and statements.

Level
200
Category
Developers
Room
Bon Jovi
Time
3:15 PM
Code
DEV105
Live session URL
https://bit.ly/3x0rQlg