Analyzing Business Data with T-SQL

Transact-SQL (T-SQL) is a powerful language for querying data but it can be a challenge for application developers and business analysts who are not already deeply familiar with the language to solve business problems. In this session, we will use a variety of T-SQL techniques to generate Key Performance Indicators (KPIs) for a common business scenario. We will see how to calculate measures like revenue, cost, profit, lifetime value, days between orders, and much more using techniques like common table expressions, date math, window functions, percentiles, and the APPLY operator. Come learn techniques to transform your business needs into SQL answers.