Business Analysis with T-SQL

Business Analysis with T-SQL

No matter if you use SQL Server on premises, Azure SQL Database, or Azure Synapse Analytics, you might have a feeling that the main language for these services, the T-SQL language, is somehow obsolete and not capable enough for the need of the modern analytics. This session will show you the opposite. You can make advanced business analytics also with T-SQL, you do not need to use R, Python, or some other currently fashionable language for every single in-depth view in your data. In addition, you can get magnitudes better performance inside a database management system when in statistical languages and engines. You will learn how to use T-SQL for queries that you might already be familiar with, for aggregating queries. But this is only to warm you up. Then you will learn how to do hazard and survival analysis, market basket analysis with association rules using different measures like support and confidence, and even sequential market basket analysis, when there is a sequence in the basket. Then the session introduces the look-alike model, which is a mixture of k-nearest neighbor and decision trees algorithms. The session finishes with Bayesian inference implemented with T-SQL.

Session Type : Deep-Dives – 120 mins (105 mins + 15 mins Q&A) – Slides + Demos

Track: Development

Level: Brain-Hurting