Data Analytics

VW11 Analyzing Business Data with T-SQL


11:00am - 12:15pm

Level: Introductory

Kevin Feasel

Predictive Analytics Manager


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.

You will learn:

  • About important key performance indicators (KPIs) in business
  • Use SQL Server's T-SQL language to calculate KPIs
  • How to build on calculations using common table expressions and the APPLY operator